April 4, 2006 at 3:01 am
Hello,
I have done a restore off the master DB, following the steps bellow
1. Stop MSSQLServer and SQLServerAgent services.
2. From a command prompt, enter this command:
sqlservr.exe -m
3. Run
Something went wrong, I don’t know what (maybe I shouldn’t have closed the cmd prompt window), the problem is that now SQL SERver service is not running so I cant access my databases. The following error is showing on the event viewer for every database that can´t be loaded :
Event id: 17055
Or: MSSQLSERVER
17207 :
udopen: Operating system error 3(O sistema não conseguiu localizar o caminho especificado.) during the creation/opening of physical device C:\Program Files\Microsoft SQL Server\MSSQL\data\model.mdf.
(SQL2000)
How can I repair this, it’s worth to run a rebuildm ?
What is the correct procedure to restore the MASTER database ?
Thanks !
April 4, 2006 at 8:37 am
Pedro, you need to learn the restore db syntax. Enterprise Manager requires more than one connection to run, so as soon as you start it, you can't restore master.
You need to restore master using query analyzer. Start the server and only connect with QA.
April 6, 2006 at 8:39 am
Pedro
Do you get those messages if you use sqlservr -m to start SQL Server? If so, then I think you do need to rebuild your master database, and then restore it from a backup. Also, are you restoring on a different server from the one on which the backup was taken? If my understanding of Portuguese is correct, SQL Server couldn't find the file in the specified path, so you may wish to check that the path to the database files on the old server also exists on the new one.
John
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply