How to disable the creation of the $IDR file when backing up a Microsoft SQL server.

Article:TECH49015  |  Created: 2006-01-12  |  Updated: 2012-02-17  |  Article URL http://www.symantec.com/docs/TECH49015
Article Type
Technical Solution

Product(s)

Issue



How to disable the creation of the $IDR file when backing up a Microsoft SQL server.


Solution




Copies of the Master and Model databases are made by Backup Exec every time a backup of these databases has been performed.

These files are created in the same directory that the databases are in.

File names:

 
  • Master$4idr
  • Mastlog$4idr
  • Model$4idr
  • Modellog$4idr

For Backup Exec 10.x
This feature can be disabled if desired by applying Hotfix 37 and creating the following registry key on the SQL server:

Create a new DWORD Value under "SOFTWARE\Veritas\Backup Exec\Engine\SQL Server"
Value name: Enable Disaster Recovery File Updates
Value data:  0 = no updates, non-zero = updates

Backup Exec 10.1.5629 Hotfix 37
 www.symantec.com/docs/TECH49014

For Backup Exec 11.x and above

Create a new DWORD Value under "SOFTWARE\Symantec\Backup Exec for Windows\Backup Exec \Engine\SQL Server"
Value name: Enable Disaster Recovery File Updates
Value data:  0 = no updates, non-zero = updates


Warning: Incorrect use of the Windows registry editor may prevent the operating system from functioning properly. Great care should be taken when making changes to a Windows registry. Registry modifications should only be carried-out by persons experienced in the use of the registry editor application. It is recommended that a complete backup of the registry and workstation be made prior to making any registry changes.

 



Legacy ID



285070


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


Terms of use for this information are found in Legal Notices