Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
R. Stan
Starting Member
3 Posts |
 Posted - 2010-04-05 : 12:02:42
|
| Hello,I re-enabled LOG SHIPING for my company last week and ever since then, we are getting event logs from windows event viewer stating that state: MSSQLSERVER The log shipping primary database ******DB has backup threshold of 60 minutes and has not performed a backup log operation for 765638 minutes. Check agent log and logshipping monitor information.The problem is that this database does not exist on the primary server- although it does exist on secondary. How can I completely remove this database from sending out alerts or how can I get this one off the log shipping. I mean how is it that the database is not on primary at all and is sending out messages. There is no such database on the primary. I am not sure how it got there.There are other databases I create log shipping for but this one is not one of them/Please and thank you for your help!R. Stan |
|
|
DBA in the making
Aged Yak Warrior
638 Posts |
Posted - 2010-04-05 : 14:57:20
|
| Log shipping is handled by SQL Server Agent. There's probably a SQL Server Agent job (or a series of such jobs) setup to log ship this database. Have a look in the Jobs folder as see if you can find the job(s) that are associated with this, and disable them.There are 10 types of people in the world, those that understand binary, and those that don't. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
R. Stan
Starting Member
3 Posts |
Posted - 2010-04-06 : 11:53:19
|
| But I deleted the jobs and when I run msdb.dbo.sp_help_job I do not see the job there. Is that query pulling from the MSDB table right? Pleae is there anywhere else I need to look.ThanksStan |
|
|
|
R. Stan
Starting Member
3 Posts |
Posted - 2010-04-06 : 12:03:31
|
| Ok I searched the msdb and there are the primary job ids for the ones but heres the thing -the primary database it has listed is not a database in the enterprise manager where I view databases. How can I delete these jobs if they arent showing up in the alerts or jobs or database lsitingPlease help! ThanksStan |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
LOG SHIPPING ALERTING FOR NONEXIST DATABASE