January 26, 2011 at 4:57 am
Dear All,
Can some one advise on the below please.
I have configured logshipping on SQLServer2000.
Backup job is working fine as I can see log backups in primary server - Shared folder
and Copy/Restore jobs are showing as working good but I couldn't find any tlog backups in secondary server.
Note: 1.Restore- alert is getting failed in primary server
2.Logshipping monitor is showing last copied and loaded files as first_file_000000000000.trn.
and also when I ran these queries select * from log_shipping_primaries & select * from log_shipping_secondaries as I got empty result ( tables are not updated)
3.I can see this error in eventvwr Error: 14421, Severity: 16, State: 1
The log shipping destination BACKUPSERVER8.SOSInfiniscale is out of sync by 45 minutes.
Thanks and Regards,
Ravichandra.
January 27, 2011 at 4:52 am
Can any one help me out on this? please
I have setup the Logshipping using the wizard without problems,
The Tlog files are created on my primary server, but they are not
copied to the secondary server
I think, that can be a permissions issue, can anyone tell me how to
solve this
more info:
In my LogShipping monitor allways shows the same :
"last file copied: first_file_000000000000.trn"
I use SQL200 sp4
The log shipping monitor is the same as the primary server
Thanks and Regards,
Ravi.
January 28, 2011 at 2:22 am
Try running the SQL Server Agent with an Account which has sysAdmin Access on both DBs and Modify Access to all the involved Directorys
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply