Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 4478
  • Last Modified:

Bypass recovery mode

Whenever I try to start the SQL2000 sevice, I get the error "table tempdb in bypass recovery mode" and the process is terminated... It started when we first received the message that the transaction log for the 'tempdb' database was full although it was set to grow and ample space was availiable (2GB).  We created a second log and this message appeared... HELP!!!

Gene
0
gene_jm
Asked:
gene_jm
  • 2
  • 2
1 Solution
 
arbertCommented:
It should be as easy as deleting the tempdb.mdf and the ldf file--SQL Server will recreate them on startup.  If SQL Server doesn't want to recreate them, take a look at traceflags (3607, 3608 and 3609)

Brett
0
 
gene_jmAuthor Commented:
Hi Brett

The files were deleted ....and SQL2000 recreated them, but then the services stopped showing the same error "Could not run begin transaction in database 'tempdb' because the database is in bypass recovery mode"
0
 
gene_jmAuthor Commented:
based on the above  the service cannot be started....therefore how does one one look at traceflags (3607, 3608 and 3609)
gene_jm
0
 
arbertCommented:
You apply a trace flag when you start sql server--if you look at the service property, you can add /t startup option--see the options below....It's weird that it recreated tempdb and then gave a recovery error--did you try moving the files or something?  What happened to make the recovery mode kick in?

http://www.transactsql.com/Articles/startupparms.html

http://www.databasejournal.com/features/mssql/article.php/1442191#part_2


Brett
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now