Single user mode

[muppetmad]

When I try to restore my master from a back up fiel it says I need to be in single user mode. How do I get there? SQL 2000

 

[rogerwin7]

Hay,
following are the steps to start sql server in single user mode -

Start >> Run >> type in CMD >> command prompt window will be appeared >> here execute command - net stop mssqlserver >> this will stop your sql server >> now to start sql server in single user mode execute the command -
sqlservr -m

 

[SQL_Hell]

What Rogerwin7 says is correct, but the real question is....


Why do you need to restore your master database?

 

[rogerwin7]

Hay SQL_Hell,

Thanks
Well I am a newbie for MSAccess and don't know much about MSAccess, but I have good experience with MSSQL.
Hope I will get help from you guys in my MSAccess issues

 

[muppetmad]

Thanks!

I am creating a duplicate server for upgrade testing and want to restore the master from a my production server as well as my other databases so that everything is identical. Some of the programs were created by my predessor and I don't want any surprises. When it is time for the real upgrade.

 

[SQL_Hell]

Ok, I have done similar things in the past.

Masterdb doesn't have that much in it tbh (logins, attached databases, linked servers)

One thing you need to be aware of it is that if you restore the masterdb from another server then internally the new server will think it is called the name of the old server.

So when you run SELECT @@SERVERNAME it will be incorrect.

In sql server 2000 you can change the value of the master system table dbo.sysservers

In sql server 2005 you cannot make ad hoc changes to system tables, so you will need to do the following:

sp_dropserver <old_name> 
GO 
sp_addserver <new_name>, local 
GO

 

[SQL_Hell]

Hay SQL_Hell,

Thanks
Well I am a newbie for MSAccess and don't know much about MSAccess, but I have good experience with MSSQL.
Hope I will get help from you guys in my MSAccess issues

Hey

I am sure you will there are plenty of people here with excellent access skills