Restore master using LiteSpeed

Question

Post reply

Restore master using LiteSpeed

SQL ORACLE

One Orange Chip

Points: 27807
More actions
May 15, 2008 at 9:08 pm

#186646

Does anyone has such experiences? If yes, please describe it in detail.
We have backup of master using LiteSpeed. Now, we would like to restore it.
Any input will be greatly appreciated.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Vivien Xing SSChampion Points: 12297 More actions · Answer 1

search "Restoring the Master Database from a LiteSpeed 2005 Backup Device Example"

from All programs-> Imceda-> Litespeed 2005 -> LiteSpeed 2005 Help

No experience in restoring master db using Litespeed, but the online help gives details.

Hope this helps.

KenpoDBA SSCrazy Eights Points: 9811 More actions · Answer 2

He's right. The LS help file gives detailed directions on this topic. However, another good method is to convert the file back to native format, which the LS help file can also help you with.

Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant

Minion Maintenance is FREE:

Anurag Tripathi Old Hand Points: 364 More actions · Answer 3

Hi,

You can use this script,It might have helped you.

From a command prompt, enter: sqlservr.exe -c -m for confirming that SQL Instance is in single user mode.

Then u can go through the next step as I am defining as an exam:

sqlllitespeed.exe -Rdatabase -T -Dmaster -FD:\MSSQL\Backup\MasterBU.bak

Regards,

Anurag Tripathi.

murthykalyani SSCarpal Tunnel Points: 4500 More actions · Answer 4

You can restore master database using sql litespeed. reason being once sql server is started in single user mode, when we try to restore master databse using sql litespeed, sql litespeed cann't make a connection as sql server started with single user connection,so extract master database of sql litespeed to native format and then restore.

EdVassie SSC Guru Points: 60472 More actions · Answer 5

My preference is to always use SQL native backup for master database. A restore of master is normally only done when things are broken, and at that stage I do not want to find my recovery tool can no longer speak to SQL Server. Using SQL native backup for master means I know that if a restore can run, I have a backup that can be used.

For mssqlsystemresource, I take a Windows copy of the .mdf and .ldf while SQL is down. This only needs to be done after the initial install, and after a SP or CU install. Getting a corruption in mssqlsystemresource is unlikely, but SQL will not start if it happens.

Tempdb does not need any backups. For all other databases I am hapy to use a tool such as Litespeed, SQL backup, etc, as these typically run faster and use less disk space thanh SQL native backup.

Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

Vivien Xing SSChampion Points: 12297 More actions · Answer 6

EdVassie (8/5/2008)
My preference is to always use SQL native backup for master database. ...

Agree. System databases are usually very small. It is not worth to use LiteSpeed. Quick/easy recovery is more important when system goes down.