Thursday, March 22, 2012

Default Backup Directory

I have put my backup directory on a seperate drive from the data and logs.
Is the only way to change the default backup directory (that shows up when
you create a new maintenance plan) is to change the registry entry or is
there some option/ parameter that will do this?
Thanks
MACason,
Declare @.Backup_Directory VarChar(255)
exec master..xp_regread 'HKEY_LOCAL_MACHINE' ,
'SOFTWARE\Microsoft\MSSQLServer\MSSQLServer',
'BackupDirectory', @.Backup_Directory OUTPUT
Select @.Backup_Directory
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
MACason wrote:
> I have put my backup directory on a seperate drive from the data and logs.
> Is the only way to change the default backup directory (that shows up when
> you create a new maintenance plan) is to change the registry entry or is
> there some option/ parameter that will do this?
> Thanks

No comments:

Post a Comment