dbTalk Databases Forums  

Help could not create tempdb

comp.database.ms-sqlserver comp.database.ms-sqlserver


Discuss Help could not create tempdb in the comp.database.ms-sqlserver forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
achoonho (Offline)
Junior Member
 
Posts: 1
Join Date: Jul 2006

Default Help could not create tempdb - 07-14-2006 , 08:33 AM






Hi,
need help urgently in resolving the follow issue for ms sql 2005.

Unable to startup the databases. Following is a summary of the error in the log file

Clearing tempdb database
Error:913, severity :16 l state 8.
could not find database 2. Database may not be active or may be in transition. Reissue the query once the database is available. ....
could not create tempdb. you may not have enough disk space available. Free additional disk space by deleting other files on the tempdb drive

This happen after i accidentally did a sp_detach_db tempdb

I had tried to perform the following as mentioned in one of the thread but it don't help.
Start the SQL with the -T3608 and -f flags, and do the work in Query Analyzer.

1) Start SQL and QA as above

2) Run sp_attach tempdb (see BOL for full syntax).
==> it mentioned tempdb already exist. But when I query master..sysdatabases, dbid 2 is not there.
3) Run UPDATE master..sysdatabases set dbid = 2 where name = 'tempdb'
It throw update error
4) Remove the -T3608 and -f flags and restart SQL.

Please help

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.