Has anybody used log shipping in SQL Server 2005?

[maswien]

The process to configure the log shipping seems to be very easy, then after the configuration the database is initialized on the secondary server. but the transaction logs generated to the target server had never been restored to the secondary database. I don't know where to check the error.

Look the job properties, just some binary executables with long and meaningless parameters. I guess the DBA must be sad about it, I would rather to learn something complicated at beginning and soon things get under control, but here microsoft just want you click and play and want u nothing about why it failed.

 

[mrdenny]

No idea. I used the one that I wrote.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com