SQL Server 2008 Default Backup behavior?

Posted on 2011-10-17
Last Modified: 2012-06-27

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.

Question by:apilkington
    LVL 25

    Accepted Solution

    The backup-command of sql does not disconnect sessions. The easiest way is to create a maintenance plan with the maintenance plan wizard

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

    Author Comment

    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.  

    Assisted Solution

    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.

    Author Comment

    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.
    LVL 25

    Expert Comment

    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.
    LVL 12

    Expert Comment

    by:Bob Stone
    There is a nice server backup tool that does SQL backups and restorations by BackupAssist that works well. It is pretty cheap too.

    See -

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
    Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now