Post reply

Backup Problem in sql server 2000

  • August 19, 2008 at 6:19 am

    #71807

    Hi,

    my company is having sqlserver 2000 sp3a and we have windows 2003 sp1. I have been taking a back up of 110 G Database to a different server.....from the past 6 months.......and suddenly i got an error yesterday saying

    "Operating system error 1450(Insufficient system resources exist to complete the requested service.)".

    Can you guys please help of how to overcome this problem?

  • August 19, 2008 at 12:35 pm

    #860212

    Check these out. Sound like the issue is backing up across the wire as opposed to local, especially for 100Gb database. Ever consider a third party backup tool (Litespeed, SqlBackup - among others) for compression and speed?

    http://support.microsoft.com/kb/304101

    http://support.microsoft.com/kb/274310

    HTH

    -- You can't be late until you show up.

  • August 20, 2008 at 7:21 am

    #860604

    Thanks Terry

  • August 20, 2008 at 8:21 am

    #860640

    Suri, did either link prove helpful? If you find (or don't find) a resolution, post it for either additional help replies or for the benefit of others. Thanks and best of luck.....

    -- You can't be late until you show up.

Viewing 4 posts - 1 through 3 (of 3 total)

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