Created
May 24, 2017 09:53
-
-
Save Stuart-Moore/1e02cc73af28a093870d525a346fc8e0 to your computer and use it in GitHub Desktop.
restoretimediff
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment