Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
richieasir
Starting Member
13 Posts |
 Posted - 2010-09-23 : 04:03:19
|
| Hi All,Greetings to you!I have tried to move the tempp db files.Below are the steps i followed.1. Run the following query:USE masterGOalter database tempdb MODIFY FILE (NAME = tempdev,FILENAME=’NEW PATH’);GOalter database tempdb MODIFY FILE (NAME = templog,FILENAME=’NEW PATH’);GO2. Stop SQL Service.3. Delete the database files as they will be recreated on new locations.4. Start SQL Service.Now am not able to start the service(i have deleted the temp files from the folder). Its throwing error like unable to start the service.What i want to do to start the service.Regards..........Your Friend |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2010-10-04 : 08:26:22
|
| Could you check in your Event Viewer and post the error message . It usually gives you a reason why the SQL server can't restartJack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
|
|
|
tempdb deleted