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