Post reply

SQL 2005 master.6, model.6 etc files in Windows\Temp folder

  • November 16, 2007 at 2:51 am

    #180573

    I have an issue with spurious files being created in the Windows\Temp folder. The names relate to the databases which are being backed up each night and the files are very large (similar to the database size).

    The filenames all begin with the name of the database Master, Model MSDB etc and then a number is appended as the extension for example Master.6, msdb.6 and Master.43, msdb.43. The number is the same for each day and these files appear daily, rapdily consuming diskspace.

    See attached screenshot

  • November 16, 2007 at 2:56 am

    #751750

    Does your backup window start at 9pm by any chance?

    Are you using native SQL backups or a third party tool like litespeed?


    Nuke the site from orbit, its the only way to be sure... :w00t:

  • November 16, 2007 at 3:03 am

    #751754

    Thanks for the quick response - I will have to check back with our systems chaps to be sure of the 9:00 time. I assumed SQL backup but thinking about it there may be a 3rd party app then backing up the SQL backup to another device - if you get my drift!

    I'll go and get my facts straight

  • November 19, 2007 at 8:26 am

    #752311

    Please let us know. I never checked before, but I wouldn't be surprised if some process is using temp space as temporary storage. I'd expect them to clean up, however.

    Are the files close in size to a backup or log backup size?

  • November 19, 2007 at 8:31 am

    #752318

    Yes the files are a similar size - still waiting for a response from the powers that be but they do use a third-party app to backup and I am guessing it is this which is creating the files and, as you intimate, failing to tidy up afterwards...

  • November 19, 2007 at 8:36 am

    #752323

    Is this third party tool for SQL or for the OS?

    For example litespeed uses a number of volume shadow copies and then compresses these together in a single compressed file. This would be SQL third party backup tool where as other tools like NetBackup may be setup to just backup the filesystems...


    Nuke the site from orbit, its the only way to be sure... :w00t:

  • November 19, 2007 at 9:04 am

    #752338

    Don't know at the mo. I have just e-mailed the system chaps (again!) to get more info - its a 3rd party app but it doesn't yet have a name!

    STOP PRESS

    Just had an e-mail reporting that it that the files are temporary and ARE deleted afterwards (now they tell me) - the problem was that another backup process was backing up these temp files before they were deleted and so causing huge back up files. If I ever find out, I will let you know what the backup software is

  • November 19, 2007 at 9:05 am

    #752340

    Suppress the backup software from backing up the temp directory. That may stop your issue.


    Nuke the site from orbit, its the only way to be sure... :w00t:

  • November 19, 2007 at 9:08 am

    #752343

    Backup product is Asigra. The huge temp files meant back ups were not finishing til 8:30 a.m. hence the concern.

  • November 19, 2007 at 9:11 am

    #752345

    yeah - that has now been done - thanks.

  • November 19, 2007 at 9:22 am

    #752355

    David,

    Thanks for the update and I'm sure someone else will appreciate it in the future.

    Enjoy the day now that the crisis is solved! 😉

  • November 19, 2007 at 9:30 am

    #752362

    Bit of a wild goose chase!

Viewing 12 posts - 1 through 11 (of 11 total)

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