Friday, October 30, 2009

Disable AutoRecover in Microsoft SQL Server Management Studio

According to numerous posts and my own poking around, Microsoft did not make the Auto Recovery feature configurable. This means you can’t turn it off in the UI or change the frequency of the saves. This is a bit of a pain when I work from home because I have a roaming profile and the location the Auto Recovery feature writes to is on the network and makes SSMS hang.

Thankfully, there are two registry keys that you change.

Put the contents below in a file with a .reg extension, double-click it and this will turn off the auto recovery feature.

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\90\Tools\Shell\General\AutoRecover]
"AutoRecover Always Enabled"=dword:00000000
"AutoRecover Enabled"=dword:00000000

To turn it back on, just change the AutoRecovery Enabled = 00000001.

No comments: