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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 websites down during backup process

Author  Topic 

DNF98
Starting Member

12 Posts

Posted - 2008-03-04 : 08:43:19
Good Morning,

I've been asked to research an issue in which ipMonitor is sending alerts that websites are down. One correlation that can be found is that most of the outages occur between 12-4 am which is when we also have our database backups scheduled. Review of the CPU and Memory on the database servers during that time do not indicate any significant usage. Does anyone know if there may be a correlation between the two?

And, our applications run ColdFusion. We have separate servers for IIS, CF, and SQL.

Thanks in advance for your help.

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2008-03-04 : 11:07:38
how does the ipMonitor monitor if your sites are up or down?
because backup doesn't interfere with normal db operations.


_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
SSMS Add-in that does a few things: www.ssmstoolspack.com
Go to Top of Page

DNF98
Starting Member

12 Posts

Posted - 2008-03-04 : 11:25:01
The ipMonitor is sending emails to the Network Administrator with a subject of "website name [https] is down" and a status of "The remote device timed out before sending a response".

There are a number of reasons for getting the emails that are totally unrelated to the sql servers at all, but I was asked to research in case there may be a correlation. Everything I've learned has told me that database backups should not interfere with normal db operations, too, but I thought I'd throw the question out there and see what more I can learn...

Thank you!
Go to Top of Page

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2008-03-04 : 11:31:13
look here
http://www.sqlteam.com/article/introduction-to-sql-server-database-backups
in the paragragh "How backup works" at the top


_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
SSMS Add-in that does a few things: www.ssmstoolspack.com
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-03-04 : 23:13:13
How do you backup db? Any other db maintenance task at that time?
Go to Top of Page
   

- Advertisement -