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>