How to change the default backup location in SQL Server2005

Posted At : 04 July 2008 20:46 | Posted By : Dan Lancelot
Related Categories: SubVersion,Windows

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 (0) | Print | Send | del.icio.us | Linking Blogs | 623 Views
Comments

There are no comments for this entry.

[Add Comment]
BlogCFC was created by Raymond Camden. This blog is running version 5.5.1, hosted by TalkWebSolutions.