How to change the default backup location in SQL Server2005

There doesn't appear to be a simple way of changing this setting from within SQL Server Management Studio.

you can however change this setting by modifying this registry key:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\BackupDirectory

This is very handy if you are wanting to restore a load of databases from backup (e.g. when migrating databases from another server...)

Comments (Comment Moderation is enabled. Your comment will not appear until approved.)
sbee's Gravatar awesome! thank you sir. i've been restoring about 5 db's per day, and this definitely makes that process more efficient... click-wise.
# Posted By sbee | 08/04/09 16:51
BlogCFC was created by Raymond Camden. This blog is hosted by DotLance Ltd.