1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52
| CREATE DATABASE DB
GO
USE DB;
GO
CREATE TABLE T (C INT)
GO
INSERT INTO T VALUES (0)
GO 1000
CHECKPOINT
GO
BACKUP DATABASE DB
TO DISK = 'C:\DATABASE\DB_BACKUP'
GO
TRUNCATE TABLE T;
GO
INSERT INTO T VALUES (1)
GO
CHECKPOINT
GO
BACKUP LOG DB
TO DISK = 'C:\DATABASE\DB_BACKUP_L1'
GO
RESTORE DATABASE DB2
FROM DISK = 'C:\DATABASE\DB_BACKUP'
WITH MOVE 'DB' TO 'C:\DATABASE\F1',
MOVE 'DB_log' TO 'C:\DATABASE\F2',
NORECOVERY;
RESTORE LOG DB2
FROM DISK = 'C:\DATABASE\DB_BACKUP_L1'
WITH RECOVERY;
USE DB2;
GO
SELECT *
FROM T;
C
-----------
1 |
Partager