What are the challenges you face when working across database platforms? Take the survey

Does SQL Backup use tempdb?

Keith_WaltonKeith_Walton Posts: 24
edited May 19, 2009 9:00PM in SQL Backup Previous Versions
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.

Keith Walton
Chief Software Architect


  • Options
    peteypetey Posts: 2,358 New member
    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.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
Sign In or Register to comment.