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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment