Restore LiteSpeed Backup from Local and Remote Location

Restoring LiteSpeed Backup from Local and Remote Location.

 

–Read the Backup file—-

exec master.dbo.xp_restore_filelistonly

  @filename =
‘Server nameDrive$restoreDatabaseName_Format.LSB or BAK’

Restore the Database

exec master.dbo.xp_restore_database @database=‘DataabseName_NewDatabase’

, @filename =
‘Server nameDrive$restoreDatabaseName_Format.LSB or BAK’

, @with =
‘move “Logical Filename” to “LocationDataFileName.mdf”‘

, @with =
‘move “Logical Filename” to “LocationLogFile.ldf”‘

, @with =
‘recovery’

 

If you have more than one Datafile, move them the same way as this does for mdf (Datafile) file.

 

exec master.dbo.xp_restore_database @database=‘DataabseName_NewDatabase’

, @filename =
‘Server nameDrive$restoreDatabaseName_Format.LSB or BAK’

, @with =
‘move “Logical Filename” to “LocationDataFileName.mdf”‘

, @with =
‘move “Logical Filename” to “LocationDataFileName.ndf”‘

, @with =
‘move “Logical Filename” to “LocationLogFile.ldf”‘

, @with =
‘recovery’

 


 

 

Leave a Reply

Your email address will not be published. Required fields are marked *