LiteSpeed for SQL Server 8.9.5 - Security and Compliance Guide

Manually Restore a Master Database

To restore the master database from a LiteSpeed backup, start the server instance in single-user mode and execute the LiteSpeed restore statement.

To manually restore a master database

1. From a command prompt, run as administrator, change the directory until you are in the directory containing sqlservr.exe. Usually:

   C:\Program Files\Microsoft SQL Server\MSSQL\Binn

2. Run the following to start the server instance in single-user mode:

   sqlservr.exe -c –m"LiteSpeed"

   For named instance:

   sqlservr.exe -c –m"LiteSpeed" –s"<instance name>"

   NOTE: You must switch to the appropriate directory (for the instance of Microsoft SQL Server you want to start) in the command window before starting sqlservr.exe.

3. Using another command prompt, change the directory until you are in the directory containing SQLLiteSpeed.exe. Usually:

   C:\Program Files\Quest Software\LiteSpeed\SQL Server\Engine

4. Execute the LiteSpeed restore statement to restore a full database backup of master.

   SQLLiteSpeed.exe -R"Database" -D"master" -F "<path to backup file\backup file name>" -W"REPLACE" -S "<server name>\<instance name>" –T

   Example	Script
   Restore a master database to the default instance	sqllitespeed.exe –R"Database" -D"master" -F"c:\backup\master.bak" –W"REPLACE" -S "<server name>" -T
   Restore a master to the named instance	sqllitespeed.exe –R"Database" -D"master" -F"c:\backup\master.bak" –W"REPLACE" -S "<server name>\<instance name>" –T
   Restore with encryption	sqllitespeed.exe –R"Database" -D"master" -F"c:\backup\master.bak" -Kpassword –W"REPLACE" -S "<server name>\<instance name>" –T
   Restore with replace	sqllitespeed.exe –R"Database" -D"master" -F"c:\backup\master.bak" -Kpassword –W"REPLACE" -S "<server name>\<instance name>" –T -W"MOVE 'master' TO 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\master.mdf'" -W"MOVE 'master_log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\master_Log.ldf'"
   Restore using the Tivoli Storage Manager	sqllitespeed.exe –R"Database" -D"master" –W"REPLACE -i"filespace\highlevel\lowlevel" -c"nodename" -k"password" -j"c:\program files\Tivoli\TSM\baclient\dsm.opt"

5. Restart SQL Server and LiteSpeed. If the process hangs, stop the following services and retry them:

   • Alerter

   • Cluster

   • Computer Browser

   • Event Log

   • License Logging

   • Logical Disk Manager

   • Messenger

   • Net Logon

   • NTLM Security Support Provider

   • Plug and Play

   • Remote Procedure Call (RPC) Locator

   • Remote Procedure Call (RPC)

   • Server

   • Print Spooler

   • TCP/IP NetBIOS Helper

   • Windows Time

   • Workstation

NOTE: To restore the master database from a native full backup, refer to msdn.microsoft.com. For example, SQL Server 2012: http://technet.microsoft.com/en-us/library/ms190679(v=sql.110).aspx.