Saturday, July 6, 2013

[MS SQL Server] issue with tempdb

[MS SQL Server] issue with tempdb

issue with tempdb

Posted: 05 Jul 2013 05:36 AM PDT

I needed to move the temp db that was in e:\mssql\data to c:\ This was temporary, because I was replacing the e drive. The sql application is installed on c drive in the default location, but tempdb was in e drive. I ran the code below and restarted the sql services and now SQL studio won't work for me. I can't connect to the server. Is reinstalling SQL server 2008 the only way to fix this?USE master;GOALTER DATABASE tempdbMODIFY FILE (NAME = tempdev, FILENAME = 'c:\tempdb.mdf');GOALTER DATABASE tempdbMODIFY FILE (NAME = templog, FILENAME = 'c:\templog.ldf')
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog