Default Backup Location

Hi

I am almost ashamed to ask but I cannot find the setting

Is there a way to set the default backup location in sql 2005? I dont want to change the folder every time I specify a new media.

Thanks

Alex

Hi Alex,

I don't think you can do it with the SSMS. Here's a registry key you can modify, however:

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

Regards,
Jake Marx

|||

I suggest that you do not use the default setting in SQL Server (even if you change it) as it makes administration and maintenance more of a headache for (us) DBAs

Come up with a standard approach suitable for your organization on doing backups of databases