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 |
|
sandesh_moghe
Constraint Violating Yak Guru
310 Posts |
 Posted - 2003-02-15 : 03:57:46
|
| Hi,When i restart the server, SQL Server 7 takes minimum 10 mins to start. Due to this my application doesnt work.If i try to open enterprise manager, it also gets hang.But in servives, it show that the service is started.What is the problem?Thanx in advance.---------------------------Sandesh - The Messanger |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-02-15 : 08:52:24
|
| It is probably recovering/rolling back a big transaction(s) that did not complete when it shut down. You have to let it complete this process before you restart it again, otherwise it will just keep doing it with each restart. |
 |
|
|
|
|
|
Restart Problem with SQL Server 7