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 |
|
yshalli
Starting Member
1 Post |
 Posted - 2002-04-29 : 08:29:58
|
| We have a SQL cluster 7.0 and our model database log got corrupted and the server went down and it is not restarting.we have a back up of model db.how do we go about correcting this problem ? |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2002-04-29 : 11:12:45
|
| You can start SQL Server with trace flag 3608 which will suppress recovery of all databases besides master on startup. I believe that once you get your server up, you should be able to restore your model database from backup. After that simply remove the trace flag, and restart the server.---------------Strong SQL Developer wanted in the Boston area. Please e-mail if interested.Edited by - izaltsman on 04/29/2002 11:13:47 |
 |
|
|
|
|
|
Model database log got corrupted