SQL Server 2008 Default Backup behavior?


We have a client that is using SQL Server 2008 as the database for an application that should have components of the application running 24 hours a day.  I have several questions about the backup that is happening.

Every evening SQL server performs a backup of the database.  When this happens it kills the connections that the various workstations running the application have to the database.

I did not specifically setup the backup on this database, is there a default backup routine that is created when a new database is created?

A second question I have is can I setup the backup so that it does not close the connections I have to the database?  The applications that we are running become non functioning when they lose their connection and keep trying to connect.

I am finding that for what I need books online is not giving me the answers I need quickly enough.

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

The backup-command of sql does not disconnect sessions. The easiest way is to create a maintenance plan with the maintenance plan wizard http://msdn.microsoft.com/en-us/library/ms177266.aspx.

Why disconnecting? Probably the backup is done by a thirth party tool.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
apilkingtonAuthor Commented:
As far as I can tell there is not a third party backup tool on the SQL server. Unless TrendMicro has a backup utility built into it.

I know from looking my databases are being backed up every night at 9:00 PM and when this happens it is disconnecting our applications connections to the database.  
apilkingtonAuthor Commented:
Ok, after looking at the article that was at the link provided and looking at the scheduled tasks on the server in question, I have figured out that the problem we are having is most likely being caused by Windows Server Backup, not any specific SQL server tools.  This now gets us in a discussion with the client about how this server is being backed up.
Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

apilkingtonAuthor Commented:
I've requested that this question be closed as follows:

Accepted answer: 0 points for apilkington's comment http:/Q_27400975.html#36982387

for the following reason:

I was able to do research and found the main issue I was having on my own while I was waiting for a response.
Odd on 17/10 you say
Ok, after looking at the article that was at the link provided and looking at the scheduled tasks on the server in question, I have figured out that the problem we are having is most likely being caused by Windows Server Backup

From SQL Server point of view Windows Server Backup is a third party tool. And now you found it by yourself.

For as far as I can read you were waiting on your client.
Bob StoneIT GuruCommented:
There is a nice server backup tool that does SQL backups and restorations by BackupAssist that works well. It is pretty cheap too.

See - http://www.backupassist.com/BackupAssist/tour_SQL.html
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.