Restore master db..?

[Kujen]

Hi all,

I'm trying to restore a SQL-server 2000 Master database from a backup. I need to restore the security.
I understand that I have to be a single user on the server to do this.
To do this I have sqlserver.exe -m -c as a startup parameter.
But after startup I'm not allowed to access the SQL-server!

How can I deal with this?


Kent J.

 

[mrdenny]

Don't use Enterprise Manager to connect to the SQL Server after it has started. Use Query Analyzer or osql to do the actual restore. EM actually requires several database connections, but with the server is this state it only allows one connection to the server.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2008 Implementation and Maintenance / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Admin (SQL 2005/2008) / Database Dev (SQL 2005)

My Blog

 

[Kujen]

Do I really have to restore the master db?
I want to migrate the users from a old server to a new server.

I saw this (revlogin):

http://www.tek-tips.com/faqs.cfm?fid=6608

Kent J.

 

[mutley1]

If you are just after restoring the permissions etc. then I would go for the sp_help_revlogin route. If you restore the master from a different server then there may be plenty of other items you would need to change.

HTH,

M.