SQL backup of ( Master, Model,MSdb- System DB) create Temp folder

Created: 17 Feb 2013 | Updated: 19 Feb 2013 | 2 comments

madhugvr

This issue has been solved. See solution.

Hi,

I ma trying to backup( Full backup to D2D) Ms SQL 2005 complete databses, includeding Master, Model and MSDB using symantec Exec 2012 , the job completes but it also create a temperory folder of the same size of the database, whihch consume the space in the storage drive . this happens only when i include the master Model and MSDB databases . how to get rid of this ? .

Another issue with Backup Exec 12 is dosent show the exact capacity of tape drive . I ma using LTO 5 tape and its only showing 1.49 TB instead of 3 TB. i have neabled hardware compression both in the tape device and in the job crated . is this a bug with exec 2012?.

Discussion Filed Under:

Backup and Recovery, Backup Exec - 2012, Backup Exec, Agent for Microsoft SQL Server

Comments RSS Feed

Comments 2 Comments • Jump to latest comment

Backup_Exec Symantec Employee Accredited

SQL backup of ( Master, Model,MSdb- System DB) create Temp folder - Comment:17 Feb 2013 : Link

Please check below link for tape capacity issue with BE2012

http://www.symantec.com/docs/TECH196841

About creating temp file may be you are mentioning about $idr file here please check below link

http://www.symantec.com/docs/TECH49015

Hope that helps

Thanks

Sameer

Don't forget to give a "Thumbs Up" or Mark as "Solution" if someones advice has helped you.

SOLUTION

pkh Trusted Advisor

SQL backup of ( Master, Model,MSdb- System DB) create Temp folder - Comment:17 Feb 2013 : Link

The 3TB capacity is a marketing thing which assumes a 2:1 compression ratio. This is hardly achievable in real-life. 1.5TB is the true native (uncompressed) capacity of a LTO5 tape, so there is no mistake in the BE GUI.

SQL backup of ( Master, Model,MSdb- System DB) create Temp folder

Comments 2 Comments • Jump to latest comment

Would you like to reply?

Links