CREATE DATABASE STANDBY;
GO
USE STANDBY;
GO
-- Create Table_A
CREATE TABLE dbo.STANDBY_Table_A
(
ID_A int not null IDENTITY(1,1) PRIMARY KEY,
Value_A nvarchar(80) NULL
)
-- Create Table_B
CREATE TABLE dbo.STANDBY_Table_B
(
ID_B int not null IDENTITY(1,1) PRIMARY KEY,
Value_B nvarchar(80) NULL
)
ALTER DATABASE STANDBY SET RECOVERY FULL WITH NO_WAIT;
-- Insert data to tables
INSERT INTO dbo.STANDBY_Table_A(Value_A) VALUES ('ability'),('able'),('about'),('above'),('accept')
INSERT INTO dbo.STANDBY_Table_B(Value_B) VALUES ('baby'),('back'),('bad'),('bag'),('ball')

USE STANDBY
BACKUP DATABASE STANDBY TO
DISK='\\WS01\Sources\STANDBY_FULL_BACKUP.bak'
WITH
MEDIANAME = 'STANDBY_BACKUP',
NAME= 'Full Backup';
GO
INSERT INTO STANDBY_Table_A(Value_A) VALUES ('After Full backup')
INSERT INTO STANDBY_Table_B(Value_B) VALUES ('After Full backup')
GO
BACKUP DATABASE STANDBY TO
DISK='\\WS01\Sources\STANDBY_DIFF_BACKUP.bak'
WITH
DIFFERENTIAL,
MEDIANAME = 'STANDBY_BACKUP',
NAME = 'Differential Backup';
GO
INSERT INTO STANDBY_Table_A(Value_A) VALUES ('After Differential backup')
INSERT INTO STANDBY_Table_B(Value_B) VALUES ('After Differential backup')
GO
BACKUP LOG STANDBY TO
DISK='\\WS01\Sources\STANDBY_LOG_BACKUP.bak'
WITH
MEDIANAME = 'STANDBY_BACKUP',
NAME = 'LOG Backup';
GO
INSERT INTO STANDBY_Table_A(Value_A) VALUES ('After Log backup')
INSERT INTO STANDBY_Table_B(Value_B) VALUES ('After Log backup')
GO

RESTORE DATABASE STANDBY FROM
DISK='\\WS01\Sources\STANDBY_FULL_BACKUP.bak'
WITH
STANDBY='C:\Sources\STANDBY_UNDO.bak'

RESTORE DATABASE STANDBY FROM
DISK='\\WS01\Sources\STANDBY_DIFF_BACKUP.bak'
WITH
STANDBY='C:\Sources\STANDBY_UNDO.bak'

RESTORE DATABASE STANDBY FROM
DISK='\\WS01\Sources\STANDBY_LOG_BACKUP.bak'
WITH
STANDBY='C:\Sources\STANDBY_UNDO.bak'

BACKUP LOG STANDBY TO
DISK='\\WS01\Sources\STANDBY_LOG_BACKUP_1.bak'
WITH
MEDIANAME = 'STANDBY_BACKUP',
NAME = 'LOG Backup';

RESTORE DATABASE STANDBY FROM
DISK='\\WS01\Sources\STANDBY_LOG_BACKUP_1.bak'
WITH
STANDBY='C:\Sources\STANDBY_UNDO.bak'

RESTORE DATABASE STANDBY WITH RECOVERY