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 |
|
mattssi
Starting Member
1 Post |
 Posted - 2010-01-21 : 18:54:07
|
| I have a server that was decommissioned, but prior to doing so we did NOT uncheck the "Monitor Server Instance" check box, so now I continue to get alerts for a database that no longer exists.I've looked many places but can't seem to figure out what I need to remove this log shipped server/db pair from the monitoring server database. Anyone have any ideas?Thanks! |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2010-01-22 : 03:27:18
|
| Have you looked at the log shipping stored procedures in Books Online? Never used them before but maybe this one will do the trick:sp_delete_log_shipping_primary_database [ @database = ] 'database'- Lumbagohttp://xkcd.com/327/ |
 |
|
|
quistdba
Starting Member
4 Posts |
Posted - 2010-02-02 : 08:31:43
|
| You need to delete the log shipping configuration by running the below stored procedure on the primary and then recreate the log shipping configuration:EXEC sp_delete_database_backuphistory 'DBName'GOhttp://msdn.microsoft.com/en-us/library/aa215391(SQL.80).aspx |
|
|
|
|
|
|
How to remove server/db from log shipping monitor?