February 27, 2003 at 2:16 am
Hi All,
I need some ideas. Here is my situation.
I have various windows services that connect to the database to the there thing.
My problem is that at night when the database maintenance job starts the job is unable to complete. If the services are not running there is no problem.
It there any way that I can detect a backup starting or get the date and time of when the backup will start. This way my services can disconnect and sleep for a while.
Regards,
Martin
February 27, 2003 at 7:37 am
It really depends on what's kicking off the backup. If it's being kicked off through SQL Agent, you can query the appropriate tables in msdb. However, if you have an outside application, such as ArcServe or Backup Exec or a scheduling engine, then you're going to have to coordinate with them.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
February 27, 2003 at 7:42 am
Hi,
The backup is done by sql agent. It is a maintenance job scheduled to run every night.
Which tables do I need to look at in msdb?
Regards,
Martin
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply