restoretimediff

gistfile1.txt

use master
go

if exists (select * from sys.databases where name='RestoreTimeDiffStripe')
begin
	ALTER DATABASE RestoreTimeDiffStripe SET single_USER with rollback immediate
	drop database RestoreTimeDiffStripe
end
go


create database RestoreTimeDiffStripe
go

alter database RestoreTimeDiffStripe set recovery full
go

use RestoreTimeDiffStripe
go

IF EXISTS (SELECT * FROM SYS.tables WHERE name='steps')
begin
	drop table steps
end
go

create table steps(
step integer,
dt datetime2
);
go

declare @i integer

set @i=0


backup database [RestoreTimeDiffStripe] to disk='c:\dbatools\RestoreTimeDiffStripe\RestoreTimeDiffStripe1a.bak',
disk='c:\dbatools\RestoreTimeDiffStripe\RestoreTimeDiffStripe1b.bak',
disk='c:\dbatools\RestoreTimeDiffStripe\RestoreTimeDiffStripe1c.bak'

while (@i<10)
begin
insert into steps values (@i, getdate())
select @i=@i+1
waitfor delay '00:00:15'
end


backup database [RestoreTimeDiffStripe] to disk='c:\dbatools\RestoreTimeDiffStripe\RestoreTimeDiffStripe2a.bak',
disk='c:\dbatools\RestoreTimeDiffStripe\RestoreTimeDiffStripe2b.bak',
disk='c:\dbatools\RestoreTimeDiffStripe\RestoreTimeDiffStripe2c.bak'
 with differential