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 device, start Microsoft SQL Server in single-user mode.

1. From a command prompt, 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:

   sqlservr.exe -c -m

   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 the master database backup.
   NOTE: The master database can only be restored from a backup created on an instance of SQL Server 2000 and newer. You cannot restore master database backups which were made on SQL Server version 7.0 or earlier.
   
   Examples:
   
   
   
   

2. 1. Restore a master database.

      sqllitespeed.exe -Rdatabase -T -Dmaster -F"C:\MSSQL\Backup\master.bak"

   2. Restore to named instance.

      sqllitespeed.exe -Rdatabase -T -S "<Server\Instance>" -Dmaster -F"C:\litespeed\backup\full\master.bak" -L

   3. Restore with encryption.

      sqllitespeed.exe -Rdatabase -T -Dmaster -Kpassword -FC:\litespeed\backup\full\master.bak

   4. Restore with replace.

      sqllitespeed.exe -Rdatabase -T -Dmaster -FC:\litespeed\backup\full\master.bak -WREPLACE -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'"

   5. Restore using the Tivoli Storage Manager.

      sqllitespeed.exe -Rdatabase -T -Dmaster -i"fsMH\nw\testcmd" -c"nodename" -k"password" -j"c:\program files\Tivoli\TSM\baclient\dsm.opt"

3. Restart SQL Server and LiteSpeed

4. (If the process hangs) Stop the following services and retry:

   • 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