Solved

Help tempdb GONE - sql 2005

Posted on 2006-10-20
8
824 Views
Last Modified: 2012-06-22
I was attempting to move the tempdb to a different drive using sql 2005.

Here are the steps i took:
Added: -T3608 to the startup parameters
stopped and started sql service

detached the tempdb

attempted to reattach and i got the error 'tempdb already exist'

So, i tired to detach again and it said 'tempdb' does not exist

I have tried using the alters:
use master
go
Alter database tempdb modify file (name = tempdev, filename = 'E:\Sqldata\tempdb.mdf')
go
Alter database tempdb modify file (name = templog, filename = 'E:\Sqldata\templog.ldf')
go

and i got the correct message - but again when i stopped and started sql service - tempdb was still not there.

Please help



0
Comment
Question by:DJMoonLight
  • 2
  • 2
8 Comments
 

Author Comment

by:DJMoonLight
ID: 17778792
well, i have tried just about everything..

I just tried to rebuild my master and i get the following error:

The installer has encountered an unexpected error.  The error code is 2711.  The specified Feature name (‘sql_engine’) not found in Feature table

any suggestions?
0
 
LVL 29

Expert Comment

by:Nightman
ID: 17779180
did you remove the -T3608 from the startup parameters?

SQL Server does not recover any database except the master database with this flag.
0
 

Author Comment

by:DJMoonLight
ID: 17779944
yes - when i remove the trace flag - sql will not start..

I was finally able to restore my master and got everything back..  
0
 
LVL 29

Accepted Solution

by:
Nightman earned 250 total points
ID: 17780239
glad you got it sorted out - at least now you knwo for next time that you don't need to detach it, simply Alter Database and restart SQL
0
 
LVL 42

Assisted Solution

by:Eugene Z
Eugene Z earned 250 total points
ID: 17792163
<and i got the correct message - but again when i stopped and started sql service - tempdb was still not there.
if you started the sql server than you just needed to refresh view of your windows explorer...
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

679 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question