-- restore main bak first exec master.dbo.xp_restore_database @database = 'Accounts' , @filename = '\\FILESTORE\SQL$\Accounts\Accounts_20060502001507_Friday_LS.bak' , @filenumber = 1, @with = 'NORECOVERY', @with = 'NOUNLOAD', @with = 'STATS = 10', @with = 'REPLACE' go -- restore latest diff exec master.dbo.xp_restore_database @database = 'Accounts', @filename = '\\FILESTORE\SQL$\Accounts\Accounts_20060502014913_Thursday.diff', @filenumber = 1, @with = 'NORECOVERY', @with = 'NOUNLOAD', @with = 'STATS = 10', @with = 'REPLACE' go -- restore transaction log backups -- repeat for each one, changing NORECOVERY to RECOVERY for the last one. exec master.dbo.xp_restore_database @database = 'Accounts', @filename = '\\FILESTORE\SQL$\Accounts\Accounts_20060502060107_Thursday.trn', @filenumber = 1, @with = 'NORECOVERY', @with = 'NOUNLOAD', @with = 'STATS = 10', @with = 'REPLACE' go
Monday, 15 May 2006
TSQL : Restoring a database to a point in time (Litespeed version)
Sql to restore LiteSpeed backups.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment