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 |
|
Peter99
Constraint Violating Yak Guru
498 Posts |
 Posted - 2011-09-29 : 13:46:17
|
| Hi,I was moving tempdb log file from one drive to other. I used following command:alter database temdbmodify file(name=tempdev,filename='d:\data\temp_log.ldf'By mistake I wrote data file name in name=filename. I copied log file to new location. Now I cannot start sql server instance. Any help?Thanks |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-09-29 : 14:02:44
|
| Can you start SQL with the -f paramater?If so, then you can re-run your alter database statement and restart (without the -f param).http://msdn.microsoft.com/en-us/library/ms190737.aspx |
 |
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2011-09-29 : 15:46:20
|
| Thanks Russell for your help. That's works. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-09-29 : 17:06:25
|
| You're welcome. Glad to help. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-09-30 : 09:34:02
|
| By the way, with tempdb, no need to actually move the files. Just restart MSSQL. |
|
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2011-09-30 : 13:23:44
|
| But old files will be there. I have to delete them manually. Anyhow thanks for help. |
|
|
|
|
|
|
Moving Tembdb file