Member Avatar for Geek-Master

When ever I restore the master database I put the server in single user mode using "sqlsrvr.exe -c -m" at the command prompt. When I successfully restore the database I go to restart MSSQLSERVER service and it will say it is starting but will stop. I am able to login using SA but can't seem to stop the single user mode. I pretty much end up reinstalling the SQL instance and manually typing the user logins back into the Master db. Very painful :mad:.

Running MS SQL 2000 Standard Edition under SP4.

  • 1 Contributor
  • 1 Reply
  • 69 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by Geek-Master
Member Avatar for Geek-Master

I noticed I didn't present a question, so I was wondering what methods you have done to successfully restore your master database from backups.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.