Dacă eşti interesat de subiect te poţi informa din BOL 2000: căutare după "log shipping, configuring" pentru configurare folosind Enterprise Manager.
Pentru o configurare manuală poţi studia următoarul exemplu:
--<configurare>
USE master
GO
CREATE DATABASE TestLogSh
GO
USE TestLogSh
GO
CREATE TABLE Factura
(
CodFactura INT
IDENTITY(1,1) PRIMARY KEY,
Serie VARCHAR(10) NOT NULL,
Nr INT NOT NULL,
Data DATETIME
NOT NULL
)
GO
CREATE UNIQUE INDEX
idx_factura_serienr ON Factura(Serie,Nr)
GO
INSERT INTO Factura (Serie,Nr,Data) VALUES ('A',1000,'2007-01-01')
INSERT INTO Factura (Serie,Nr,Data) VALUES ('A',1001,'2007-01-02')
INSERT INTO Factura (Serie,Nr,Data) VALUES ('A',1002,'2007-01-03')
GO
BACKUP DATABASE TestLogSh
TO DISK =
'D:\backup_sursa.bak'
GO
--RESTORE FILELISTONLY FROM DISK = 'D:\backup_sursa.bak'
RESTORE DATABASE TestLogSh_Destinatie
FROM DISK =
'D:\backup_sursa.bak'
WITH MOVE 'TestLogSh'
TO 'd:\bd_destinatie.mdf'
,
MOVE 'TestLogSh_log'
TO 'd:\bd_destinatie_log.ldf'
,
STANDBY = 'D:\undo_destinatie.ldf'
GO
--</configurare>
--<test_1>
USE TestLogSh
GO
INSERT INTO Factura (Serie,Nr,Data) VALUES ('B',1000,'2007-02-01')
INSERT INTO Factura (Serie,Nr,Data) VALUES ('B',1001,'2007-02-02')
GO
BACKUP LOG TestLogSh
TO DISK =
'D:\backup_sursa_log_01.bak'
GO
SELECT * FROM
TestLogSh_Destinatie.dbo.Factura
GO
--Se afişează facturile A1000,A1001,A1002
--RESTORE FILELISTONLY FROM DISK = 'D:\backup_sursa_log_01.bak'
RESTORE LOG TestLogSh_Destinatie
FROM DISK =
'D:\backup_sursa_log_01.bak'
WITH STANDBY = 'D:\undo_destinatie.ldf'
GO
SELECT * FROM
TestLogSh_Destinatie.dbo.Factura
GO
--Se afişează facturile A1000,A1001,A1002 + facturile B1000,B1001
--</test_1>
--<test_2>
USE TestLogSh
GO
INSERT INTO Factura (Serie,Nr,Data) VALUES ('C',1000,'2007-03-01')
INSERT INTO Factura (Serie,Nr,Data) VALUES ('C',1001,'2007-03-02')
INSERT INTO Factura (Serie,Nr,Data) VALUES ('C',1002,'2007-03-03')
GO
BACKUP LOG TestLogSh
TO DISK =
'D:\backup_sursa_log_02.bak'
GO
SELECT * FROM
TestLogSh_Destinatie.dbo.Factura
GO
--RESTORE FILELISTONLY FROM DISK = 'D:\backup_sursa_log_01.bak'
RESTORE LOG TestLogSh_Destinatie
FROM DISK =
'D:\backup_sursa_log_02.bak'
WITH STANDBY = 'D:\undo_destinatie.ldf'
GO
SELECT * FROM
TestLogSh_Destinatie.dbo.Factura
GO
--</test_2>
--<test_3>
USE TestLogSh
GO
INSERT INTO Factura (Serie,Nr,Data) VALUES ('D',1000,'2007-04-01')
INSERT INTO Factura (Serie,Nr,Data) VALUES ('D',1001,'2007-04-02')
GO
BACKUP LOG TestLogSh
TO DISK =
'D:\backup_sursa_log_03.bak'
GO
SELECT * FROM
TestLogSh_Destinatie.dbo.Factura
GO
--RESTORE FILELISTONLY FROM DISK = 'D:\backup_sursa_log_01.bak'
RESTORE LOG TestLogSh_Destinatie
FROM DISK =
'D:\backup_sursa_log_03.bak'
WITH STANDBY = 'D:\undo_destinatie.ldf'
GO
SELECT * FROM
TestLogSh_Destinatie.dbo.Factura
GO
--</test_3>