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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-07-15 : 08:24:43
|
| Rob writes "After backing up a production database from a server (with multiple databases) and restoring it and the master database on a test server, the mssqlsever service cannot be started. However, starting it from a DOS prompt starts the service to a point where you can access the tables, although services still shows the mssqlserver service as "stopped". Can this be fixed on the destination (test) server?" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-07-15 : 13:01:42
|
| Did the test server configuration match the production server configuration, meaning same drive letters, etc...? Have you checked the Event Log to determine what the error is?Tara |
 |
|
|
|
|
|
mssqlserver service says stopped but database is accessible