July 3, 2013 at 12:43 am
Hi all,
I am getting this message in error log frequently. Actually there is no database with name test in our environment.
The log shipping primary database QBSECPU01.Test has backup threshold of 20 minutes and has not performed a backup log operation for 70399 minutes. Check agent log and log shipping monitor information.
How to suppress or workaround for this issue.
July 3, 2013 at 1:38 am
Based on the error message it sounds like a db was setup for log shipping and stopped working a little over 19.5 days ago.
In SSMS if you right-click on the instance, select Reports > Transaction Log Shipping Status you should get a report with every database that is setup for log shipping and the current status of it.
Joie Andrew
"Since 1982"
July 3, 2013 at 2:15 am
Yes that is the problem. i can see those ones in red color and having an alert in reports . i want to delete them. what is the method to delete them
July 3, 2013 at 2:25 am
How to: Remove Log Shipping (Transact-SQL)
Joie Andrew
"Since 1982"
July 3, 2013 at 2:43 am
when i run the commands in the article it is expecting parameters.....
July 3, 2013 at 2:53 am
Correct. There are many pieces to log shipping. You need to specify the log shipping server and database in log shipping that you are removing. There are links to the parameters each command requires at the bottom of that link.
Joie Andrew
"Since 1982"
July 3, 2013 at 3:21 am
the database 'test' is not there in the instance how can i specify the database id
July 3, 2013 at 3:38 am
Did you actually read any of the articles that talk about remoivng log shipping? All stored procedures for log shipping rely on database NAME, not ID. DB ID would not work between multiple instances of SQL Server because it would most likely be a different value assigned to the database in each instance.
Joie Andrew
"Since 1982"
July 3, 2013 at 4:34 am
Thanks for clarifying.. its a great help for me..
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply