Solved

Help tempdb GONE - sql 2005

Posted on 2006-10-20
8
793 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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
CREATE DATABASE ENCRYPTION KEY 1 44
SQL query to summarize items per month 5 27
Sql query for filter 12 22
Stored procedure 23 9
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
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 information from SQL Server on Database, Connection and Server properties
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

757 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now