Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

On our SQL Server 2005 SP4 server we have a maintenance plan in place which performs a full backup of selected databases on a nightly basis. The databases are configured in Simple recovery mode and the maintenance plan cleans up backups that are older than 3 days.

The maintenance plan specifies that the backups be stored on the J:\ drive of our server and everything appears to work properly.

Our issue is that around the time the backup step of the maintenance plan finishes we have noticed that the K:\ drive on our server loses free disk space. This will continue until the drive is almost completely full and then the next backup will free up 50-100gb and it will repeat the cycle of taking up disk space and then freeing up the space.

We have used WinDirStat many times to try and find the file that are taking up the space on our K: drive and are unable to locate them. The disk usage appears to be directly associated with the SQL Server maintenance plan that runs.

Is there a way to verify that the backups are not accessing the K:\drive? I can't find any references to the K:\ drive in the SQL Server logs.

Thank you in advance for any assistance you can provide.

Josh

share|improve this question

closed as too localized by Max Vernon, RolandoMySQLDBA, Mat, Mark Storey-Smith, Marian Apr 2 '13 at 9:54

This question is unlikely to help any future visitors; it is only relevant to a small geographic area, a specific moment in time, or an extraordinarily narrow situation that is not generally applicable to the worldwide audience of the internet. For help making this question more broadly applicable, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.

2  
What do you store on K:? –  Jon Seigel Mar 29 '13 at 14:57
    
sysinternals filemon will help you. –  Max Vernon Mar 29 '13 at 15:12
2  
Sounds like a snapshot file or a temp file from 3rd party backup; is it a normal sql backup? Filemon should definitely have something jump out. –  SqlACID Mar 29 '13 at 17:18
2  
Might also check if your OS backups happen to occur during this time frame. NetBackup for example puts a cache file sometimes on each drive letter it is backing up for Windows. Older versions of the agent have problems deleting the file sometimes and the next go around will finally delete it. –  Shawn Melton Mar 29 '13 at 17:35
2  
document management system: do you use FILESTREAM? Filestream files are included in the backup. –  Remus Rusanu Mar 29 '13 at 18:24