USE master;
GO
DROP DATABASE BulkLoggedRecovery;
CREATE DATABASE BulkLoggedRecovery;
ALTER DATABASE BulkLoggedRecovery SET RECOVERY BULK_LOGGED;
BACKUP DATABASE BulkLoggedRecovery TO DISK ='C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\BulkLoggedRecovery.bak'
USE BulkLoggedRecovery;
SELECT top(200) REPLICATE('a',2000) AS Somecol
INTO SomeTable
FROM sys.COLUMNS AS c;
GO
SHUTDOWN WITH NOWAIT;
SELECT * FROM sys.DATABASES WHERE name = 'BulkLoggedRecovery'
BACKUP LOG BulkLoggedRecovery TO DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\BulkLoggedRecovery_tail.trn' WITH NO_TRUNCATE
RESTORE DATABASE BulkLoggedRecovery FROM DISK ='C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\BulkLoggedRecovery.bak' WITH NORECOVERY
RESTORE LOG BulkLoggedRecovery FROM DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\BulkLoggedRecovery_tail.trn' WITH RECOVERY,CONTINUE_AFTER_ERROR
USE BulkLoggedRecovery
SELECT * FROM SomeTable