Archive

Archive for April, 2011

Restore LiteSpeed Backup from Local and Remote Location

April 4, 2011 Leave a comment

Restoring LiteSpeed Backup from Local and Remote Location.

 

–Read the Backup file—-

exec master.dbo.xp_restore_filelistonly

  @filename =
‘Server name\Drive$\restore\DatabaseName_Format.LSB or BAK’

Restore the Database

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

, @filename =
‘Server name\Drive$\restore\DatabaseName_Format.LSB or BAK’

, @with =
‘move “Logical Filename” to “Location\DataFileName.mdf”‘

, @with =
‘move “Logical Filename” to “Location\LogFile.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 name\Drive$\restore\DatabaseName_Format.LSB or BAK’

, @with =
‘move “Logical Filename” to “Location\DataFileName.mdf”‘

, @with =
‘move “Logical Filename” to “Location\DataFileName.ndf”‘

, @with =
‘move “Logical Filename” to “Location\LogFile.ldf”‘

, @with =
‘recovery’

 


 

 

Categories: Uncategorized