Results 1 to 2 of 2

Thread: DB Backup Performance

  1. 11-29-2001, 05:00 AM #1
    Krishnakumar Guest

    DB Backup Performance

    I have a problem in my production server. It is taking long time to take BACKUP or RESTORE of a particular Database. Where as I am trying the same BACKUP and RESTORE task with the same Database in another test server which is very less configuration compared to earlier. In this test server BACKUP and RESTORE task is completing in 10 Mins where as in the earlier Higher configuration server the same task is taking 30 Mins. How can I improve the BACKUP and RESTORE performance?. Can anyone clarify to me?
    Reply With Quote Reply With Quote
  2. 11-29-2001, 01:23 PM #2
    Sundar Guest

    DB Backup Performance (reply)

    Is the database in use by anyone at the time of the backup? Check what locks you have on it, there should be no one other than the backup SPID holding locks.


    ------------
    Krishnakumar at 11/29/2001 5:00:12 AM

    I have a problem in my production server. It is taking long time to take BACKUP or RESTORE of a particular Database. Where as I am trying the same BACKUP and RESTORE task with the same Database in another test server which is very less configuration compared to earlier. In this test server BACKUP and RESTORE task is completing in 10 Mins where as in the earlier Higher configuration server the same task is taking 30 Mins. How can I improve the BACKUP and RESTORE performance?. Can anyone clarify to me?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules