<div>
It should be as easy as deleting the tempdb.mdf and the ldf file--SQL Server will recreate them on startup. &nbsp;If SQL Server doesn't want to recreate them, take a look at traceflags (3607, 3608 and 3609)<br />
<br />
Brett
</div>


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

<div>
Hi Brett<br />
<br />
The files were deleted ....and SQL2000 recreated them, but then the services stopped showing the same error &quot;Could not run begin transaction in database 'tempdb' because the database is in bypass recovery mode&quot; 
</div>


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"

<div>
based on the above &nbsp;the service cannot be started....therefore how does one one look at traceflags (3607, 3608 and 3609)<br />
gene_jm
</div>


based on the above  the service cannot be started....therefore how does one one look at traceflags (3607, 3608 and 3609)
gene_jm

<div>
<div class="content wysiwyg-content">
Whenever I try to start the SQL2000 sevice, I get the error &quot;table tempdb in bypass recovery mode&quot; 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). &nbsp;We created a second log and this message appeared... HELP!!!<br />
<br />
Gene
</div>
</div>


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

Bypass recovery mode

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.