Home > Uncategorized > Restore LiteSpeed Backup from Local and Remote Location

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 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
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: