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 |
Problem
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.
|
|
Related Articles
Legacy ID
285070
Article URL http://www.symantec.com/docs/TECH49015
Terms of use for this information are found in Legal Notices
Thank you.