Database backup takes long

  • Hi,

    We have a (MSDE) database on our client site and the backing up of the same takes a good long 6 hours. We got the latest backup and the poor thing is on the slimmer side (only 239 MB) as well. We tried a restore and backup of the same on our PCs (also with MSDE) and both came up with flying colors in less than 1 minute. Unfortunately, we cannot get hold of the the remote PC but somehow gathered from the client that the CPU usage does not cross 20% at any point of time.

    Will appreciate any direction in this issue please.

    Regards

  • Backups are very unlikely to be CPU bound.

    Are you backing up to the same machine the database is on?

    If so, it sounds like you have some serious I/O problems on that machine.

    If you are backing up to a disk on another machine, then either that machine has serious I/O problems, or you have serious Network prroblems.

  • Thanks,

    I guess you might be correct. Unfortunately both the database and backup are on the same box, and more to that it is a straigt forward desktop, thus possibility is the physical drive will be the same as well.

    Just one confusion, the problem surfaced only a month back, before that it was less than a minute as usual, and nothing has been altered since then.

    Any thoughts please?

    Regards,

  • It could be a disk issue, then. It isn't a large database, so even on a workstation, it shouldn't take that long. If you run an ad hoc backup, is it still that long? Are you running to one file or using WITH INIT?

    Most servers run backups to the same drives or at least same machine.

  • Sorry, I am bit late with update, sa suggested, no issues with the database, the problem was with the box itself. It's completes in a flicker now.

    Regards,

  • Kaushik, can you say what the problem with the box was?

    I have a similar problem where a 500mb, 10 second, backup (which will happily run manually) takes 1-3 hours as a scheduled. job. This is running outside our 4-6am window and is a pain to troubleshoot i.e. I have to get up at 4 am :angry:

    There are no locks it just sits there. Data is on a SAN, backup lun seperate from data LUN, dual fibre channel (double redundant everything).

    Fortunately it is a small database so I can do it in the day but other databases on this server are 170GB+ and if the problem spreads.....

    Any ideas?

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply