SQL Server Performance

Can SQL Server 2000 be backed up when database is being used by staff

Discussion in 'Getting Started' started by yazzy, Nov 8, 2007.

  1. yazzy New Member

    Hi
    My boss asked me tthis week o do a backup of a databse when the database is being used by users through an application.
    I am trying elimate backing up database during office could be the cause of CRM application grinding to a halt. Resu;lting in no one can work. In the event log MSSQL errors are logged from 8am until 14:00.
    Could I have advise if backing up in morning causes performance degradtion?
    Thanks in advance
    yazzy, Nov 8, 2007
    #2

  2. satya Moderator

    Welcome to the forum!
    If the backups are taking longer time to finish and causing performing issues to the application means that is something problem on the hardware too. When the backup is performed the local disks on server are used to extent to write the information. In this regard you should monitor or get hardware vendor to perform health check of hardware completely.
    What is the size of database?
    Do you perform any transaction log backups?
    You can perform backup during anytime and that shouldn't cause any issues or locking to the application.
    satya, Nov 9, 2007
    #3

Share This Page