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 |
|
jpotucek
Constraint Violating Yak Guru
273 Posts |
 Posted - 2008-05-19 : 16:08:51
|
| I think one of my system database files is corrupted. I did an alter database... to move my Model and MSDB and now I can only start the instance with /f /t3608I can connect to the instance but I can't do anything I get an error that one of the database files does not match it's primary file.. I don't know if it's MSDB or MODEL but I pretty much can't do anything.I made a backup of model and msdb before I started.. how do I go about restoring them? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
jpotucek
Constraint Violating Yak Guru
273 Posts |
Posted - 2008-05-20 : 05:57:02
|
| Thanks Tara. That is the article I followed but I must have messed something up. I can bring the instance up in single user mode (NET START mssqlserver /f /t3608) but when I try to do a query to re-do my alter statements, it says i can't attach because only one seesion is allowed. in 2000 i used to be able to start query analyzer without starting enterprise manager.. When i try and start with a minimal config (sqlservr -c -m) it won't start. I get an error saying that one of my files does not match it's primary file (either model or msbd don't know which) any ideas? |
 |
|
|
jpotucek
Constraint Violating Yak Guru
273 Posts |
Posted - 2008-05-20 : 09:51:34
|
| i ended up starting the instance in single user (netstart mssqlserver /f /t3608), opening SSMS, cancelling the connect dialog and then opening a new query window and issueing my alter statements again to move the model and msdb files. little different than working with ENT manager and query analyzer!!! |
|
|
|
|
|
|
2005 instance is dead after moving system DBs