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.