Solved

Help tempdb GONE - sql 2005

Posted on 2006-10-20
8
812 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:EugeneZ
EugeneZ 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

773 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