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

Default Backup Location

Where do I setup the default backup folder location on SQL Server 2005?
Thanks,
Ademar.I didn't find a way to set it with the GUI, but you can always modify the registry. On my machine, I
have a path:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer
And there is a key named BackupDirectory
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Ademar" <ademar@.nospam.com> wrote in message news:OZ9D5YvbGHA.3344@.TK2MSFTNGP03.phx.gbl...
> Where do I setup the default backup folder location on SQL Server 2005?
> Thanks,
> Ademar.
>

Default Backup Location

How do I change the default backup location in SQL Server
2000?
Thanks in advance.From bol under backup
Note If a relative path name is entered for a backup to
disk, the backup file is placed in the default backup
directory. This directory is set during installation and
stored in the BackupDirectory registry key under
KEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\MSSQLServe
r.|||I would not recommend the use of the default backup folder. It's better to
be explicit about where you want to backup your database/log. Personally, I
don't use it and have not found it of any use. I'd be curious about any
significant value anybody may find it offers.
--
Linchi Shea
linchi_shea@.NOSPAMml.com
"Evan" <anonymous@.discussions.microsoft.com> wrote in message
news:0c9001c39f4b$17bc0ef0$a001280a@.phx.gbl...
> How do I change the default backup location in SQL Server
> 2000?
> Thanks in advance.

Default Backup Location

Where do I setup the default backup folder location on SQL Server 2005?
Thanks,
Ademar.I didn't find a way to set it with the GUI, but you can always modify the re
gistry. On my machine, I
have a path:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Mi
crosoft SQL Server\MSSQL.1\MSSQLServ
er
And there is a key named BackupDirectory
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Ademar" <ademar@.nospam.com> wrote in message news:OZ9D5YvbGHA.3344@.TK2MSFTNGP03.phx.gbl...[
vbcol=seagreen]
> Where do I setup the default backup folder location on SQL Server 2005?
> Thanks,
> Ademar.
>[/vbcol]sql

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

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?
ThanksMACason,
Declare @.Backup_Directory VarChar(255)
exec master..xp_regread 'HKEY_LOCAL_MACHINE' ,
'SOFTWARE\Microsoft\MSSQLServer\MSSQLSer
ver',
'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

decrease the size of Sql backup files

Hi,
I am looking for sql tool that it could shrink the sql data backup and log
files size.
I know one software called litespeed. There is any more good software that
could do the same function as litespeed does?
Thanks,Sonasafe by SonaSoft
SQL Safe by Idera
SQL Backup by Red Gate Software|||thanks,
"mecn" <mecn2002@.yahoo.com> wrote in message
news:Ob9yTYNLGHA.1424@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I am looking for sql tool that it could shrink the sql data backup and log
> files size.
> I know one software called litespeed. There is any more good software that
> could do the same function as litespeed does?
> Thanks,
>

decrease the size of Sql backup files

Hi,
I am looking for sql tool that it could shrink the sql data backup and log
files size.
I know one software called litespeed. There is any more good software that
could do the same function as litespeed does?
Thanks,
Sonasafe by SonaSoft
SQL Safe by Idera
SQL Backup by Red Gate Software
|||thanks,
"mecn" <mecn2002@.yahoo.com> wrote in message
news:Ob9yTYNLGHA.1424@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I am looking for sql tool that it could shrink the sql data backup and log
> files size.
> I know one software called litespeed. There is any more good software that
> could do the same function as litespeed does?
> Thanks,
>

decrease the size of Sql backup files

Hi,
I am looking for sql tool that it could shrink the sql data backup and log
files size.
I know one software called litespeed. There is any more good software that
could do the same function as litespeed does?
Thanks,Sonasafe by SonaSoft
SQL Safe by Idera
SQL Backup by Red Gate Software|||thanks,
"mecn" <mecn2002@.yahoo.com> wrote in message
news:Ob9yTYNLGHA.1424@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I am looking for sql tool that it could shrink the sql data backup and log
> files size.
> I know one software called litespeed. There is any more good software that
> could do the same function as litespeed does?
> Thanks,
>