How can we help you today? How can we help you today?

Does SQL Backup use tempdb?

I'm splitting my backup into two files for performance - each file goes to a different raid 0 drive array. I then copy these files onto my report server and restore them using two different drives.

In both cases, one of the drives is used for my tempdb. Is the backup or restore causing significant tempdb activity? If that's the case, I may get better performance by using a different drive.

Thanks
Keith_Walton
0

Comments

1 comment

Sort by
  • petey
    Usually, you shouldn't see much activity on tempdb during backups, and almost none during restores. There are a couple of queries ran after backups to retrieve backup details from some msdb tables, and if there are a lot of records in those tables (backupset, backupmediafamily), SQL Server might decide to use tempdb as a temporary store.
    petey
    0

Add comment

Please sign in to leave a comment.