SQL Server Performance

Backup Database

Discussion in 'General DBA Questions' started by fauzanf, Aug 7, 2009.

  1. fauzanf New Member

    Hello My Friends,
    I have a question about manual backup of sql server 2K database.
    I have a database. Some users connect to the database via an application that i made.
    Is it OK....? If i backup the database while users connecting to it.
    Need advice please...
    Thanks & Regards,
  2. preethi Member

    Hi Fauzan,[quote user="fauzanf"]Is it OK....? If i backup the database while users connecting to it[/quote] My Answer to your question is "It depends" It depends on the type of backup (and the disk activity you expect through the backup process), the number of users connected and their activity.I believe you may have concerns over two areas:
    1. Performance of the application
    2. Data consistency.
    On the first issue, you need to worry much. As backup process generates a lot of disk activity, users might experience timeout errors and slowness of the application. It is better to find a low usage period to backup the database. This is where partial backups and file group/file backups in addition to differential and log backups might help you.On the second issue, you don’t have to worry much. SQL Server takes care of it.
    Hope this helps.
  3. fauzanf New Member

    Thanks for your explanation. Very Clear. [:)]
    I willl backup while users not connected to the database.

Share This Page