SQL 2005 Log Shipping
Posted on 2010-11-07
I am trying to setup log shipping on my test server. This is what I did.
I created a test database on primary server (SQL 2005) with full recovery model
Took a full backup of this database and restored on secondary server (SQL 2005)
On primary server, selected the database and enabled log shipping using wizard. I left most of the options to default. Selected the "Network path to Backup folder" as a shared folder on secondary server (shared folder with write permission to everyone). Same folder is mentioned as "Destination folder for copied files". Selected "No, the secondary database is initialized".
After this two jobs are created in primary server and three jobs created in secondary server. The two jobs in primary server and two jobs in secondary server executed without any errors. But the job LSRestore_PrimaryServer_TestDB on secondary server fails with the below messages
Date 08/11/2010 11:15:01 AM
Log Job History (LSRestore_PrimaryServer_TestDB)
Step ID 1
Job Name LSRestore_PrimaryServer_TestDB
Step Name Log shipping restore log job step.
Sql Severity 0
Sql Message ID 0
Operator Net sent
Retries Attempted 0
Executed as user: CHSAPTEC\Administrator. The step failed.