Restoring LiteSpeed Backup from Local and Remote Location.
–Read the Backup file—- exec master.dbo.xp_restore_filelistonly @filename = —Restore the Database exec master.dbo.xp_restore_database @database=‘DataabseName_NewDatabase’ , @filename = , @with = , @with = , @with =
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 = , @with = , @with = , @with = , @with =
|