Re: Single user mode

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: David G. (david_nospam_at_nospam.com)
Date: 08/24/04 

Date: Mon, 23 Aug 2004 23:27:22 -0400

Ed wrote:
> HI,
> I try to backup a Master Database (Play with it) and restore it,
> but when i do that, i got an error message - Restore Database must be
> used in single user mode when try to restore the master database.
> How am i able to set it as single user mode. I tried to go to the
> properties of Master Database but the Restrict Access is gray out.
> Any help?
> Please also mention how to change it back to multi-user mode, too.
> Thanks a lot
> Ed

See the section: "Restoring the master Database from a Current Backup"
in the Help File.

Under the section for Starting Server in Single User Mode, you see the
command line options: sqlservr.exe -c -m 

-- 
David G.

Relevant Pages

  • Re: restoring sql with VBscrip
    ... I found everything for backup and no topics, ... I have used VBScript program similar to below to restore. ... ' VBScript Program to restore the MyDatabase database from a specified ... ' Specify connection string to Master Database on SQL server. ...
    (microsoft.public.windows.server.scripting)
  • Re: Single user mode
    ... You need to start SQL Server in single user mode from the ... After you restore the master database, ...
    (microsoft.public.sqlserver.server)
  • Re: Cant restore master db!!
    ... Login to sql server using query analyzer and retore the master database. ... After the restore .. ... Go to control panel and start the MSSQL server and Sql agent service. ...
    (microsoft.public.sqlserver.server)
  • Re: Single user mode
    ... You can restore the Master database backup to another SQL Server. ... restore Master database you have to start the sql server in single user. ...
    (microsoft.public.sqlserver.server)
  • Re: Upgrading Hardware, how best to move?
    ... > backup and restore to move my databases. ... > over all the users and security settings. ... > restore the master database? ...
    (microsoft.public.sqlserver.security)