February 27, 2004 at 7:37 am
Hello All,
I have a slight issue that I've been trying to find information on without much success, so I thought I'd get with the experts here. I've configured log shipping between 2 servers, primary (A) and secondary (B), with Log Shipping Monitor on (C). I'm shipping logs for 15 db's and all is going well with the copy and load sequences for all of them. My issue is when I view the list of plans on server (C), all listed have "the big red X", indicating a problem. On further review of the properties and results, the Status tab/sheet, under Status: the note reads - "Backup not occurring". As I stated, when viewing the history of backups and/or the copy and load history, all are successful. If I Disable the Backup Alert, the red X goes away and the status then displays "Normal".
Q: What backup is it reporting on, that supposedly isn't occurring? T-logs are being backed up on A, copied to B and then loaded (restored) on B, with success, according to the results listed in the backup and copy/load histories for each plan.
Notes:
1. Aside from the T-Log backups that are taking place every hour as part of the log shipping scheme, I am backing up the server A db's as part of a separate maintenance plan nightly. So it seems the backups are occurring successfully there.
2. As you know, once log shipping is configured the plans shows up on server B as well as on server A where they were created, with slightly different config tabs. When viewing the server B property sheets for the plans, there is a tab for Complete Backup. I've tried configuring a backup schedule there, but the results are that these backup jobs can't run because the db's are in "Warm Standby" mode.... So that won't fix it.
Anyway, that's it. Any help out there would be cooler than ice. Thanks much for any assistance anyone can lend.
Thank You SQL Community!
February 27, 2004 at 2:47 pm
I am not sure how to help you on that, Nevertheless, I am interested to know if you can help me out with my log shipping. For two days now, I have been trying to get log shipping going without any luck.
I have two SQL servers that I'm doing log shipping testing on. One Enterprise Edition, and one developer's Edition. On ServerA, I am setting it up as a primary and monitor server. On ServerB, it is the read-only log shipped server.
After I created the initial backup restore on ServerB from ServerA, none of the sequencial logs are shipped or copied to ServerB. All SQLagents are running under my Windows NT account and I also have admin right from my NT account to these two servers. I have shared file folders on both network share drive and backup drives. Again, permission doesn't seems like an issue since my first restore on ServerB was successful.
The Logshipping monitor keep showing that the transaction logs are not being copied. I went into SQL agent jobs and Copying and restore on ServerB job history was all successful.
Is there any other trick I have to teach this puppy to behave like MS is promising? Your time and help is so much appreciated.
thanks
Jon
DBA/OLAP Developer -
San Francisco, CA
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply