Post reply

How do I reassign the temp file/directory used by SQL Svr 2000 during backups?

  • September 13, 2007 at 7:24 am

    #73544

    Hey guys,

    Just wondering if there is a way to change the directory that SQL Server is using when it does a back up. Currently I have a 100+GB DB with data and log files sitting on a drive that 500+GB, the DB used to be around 70+GB and the backup jobs would run fine, since the DB resized itself (auto growth) the jobs have failed. I've noticed when the backup job runs the free disk space only drops on my C:\ drive and not any of my other drives. This leaves me to believe that SQL Server is using some sort of swap/temp space to create the backup prior to dropping it off at the desired location. Can anyone confirm?

    Thanks

    Mike

  • September 13, 2007 at 7:56 am

    #733473

    I don't recall seeing anything happen with temp and backups but could be your page file needed to grow due to the amount of memory work being done at the time.

  • September 13, 2007 at 8:10 am

    #733480

    I've looked at memory consumption and it seems to me minimal at best - only thing that is changing is the disk space.

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

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