Post reply

Drive C: filled during last full backup to drive D:

  • December 29, 2010 at 3:27 pm

    #232817

    I did a manual full backup of one of my production databases to capture an end of fiscal year copy. I wrote the backup file to my D: drive. During the backup I received a message from my monitoring system telling me that my C: drive space was over 80% utilized. By the time I saw the message, the backup was complete and I received a new message reporting space on drive C: was now fine.

    Does a full backup that is going to disk create a temp file on the c: drive somewhere? If so can this location be changed? and if so, how/where do I change it?

    Thanks,

    Mike

  • December 29, 2010 at 9:27 pm

    #1267516

    A backup of a database does not need create a temporary file anywhere. SQL Server writes the backup data directly to disk, even if it was to a network share.

    SQL BAK Explorer - read SQL Server backup file details without SQL Server.
    Supports backup files created with SQL Server 2005 up to SQL Server 2017.

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

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