White Papers

24 TR1081 | Microsoft SQL Server Database Protection Using EqualLogic Auto-Snapshot Manager / Microsoft Edition
--Create tail-log backup.
BACKUP LOG testdb
TO DISK = 'Z:\SQLServerBackups\testdb_tail.bak'
WITH NORECOVERY;
GO
--Restore Database using appropriate Smart Copy in ASM/ME with Apply Logs
option.
--Restore the regular log backup (from backup set 1).
RESTORE LOG testdb
FROM DISK = 'Z:\SQLServerBackups\testdb_log.bak'
WITH FILE=1,
NORECOVERY;
--Restore the tail-log backup (from backup set 2).
RESTORE LOG testdb
FROM DISK = 'Z:\SQLServerBackups\testdb_tail.bak'
WITH FILE=2,
NORECOVERY;
GO
--Recover the database:
RESTORE DATABASE testdb
WITH RECOVERY;
GO