Does anybody know how to change the default backup location for SQL Server
2003 without re-installing it? My backup location is defaulting to the C:
drive & I want to change this to the E: drive?
Many thanks,
RitaHi
SQL Server 2003 does not exist. SQL 2000?
In the registry:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MS
SQLServer\MSSQLServer
BackupDirectory key
If it is a named instance, adjust the path.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Rita" <Rita@.discussions.microsoft.com> wrote in message
news:B9E59639-209E-4D6B-86AA-239D623D4BB2@.microsoft.com...
> Does anybody know how to change the default backup location for SQL Server
> 2003 without re-installing it? My backup location is defaulting to the C:
> drive & I want to change this to the E: drive?
> Many thanks,
> Rita|||Many thanks Mike - and yes, it is SQL Server 2000!
Regards,
Rita
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> SQL Server 2003 does not exist. SQL 2000?
> In the registry:
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MS
SQLServer\MSSQLServer
> BackupDirectory key
> If it is a named instance, adjust the path.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Rita" <Rita@.discussions.microsoft.com> wrote in message
> news:B9E59639-209E-4D6B-86AA-239D623D4BB2@.microsoft.com...
>
>
Tuesday, February 14, 2012
Changing Default Backup Location for SQL Server 2003
Labels:
backup,
changing,
database,
default,
defaulting,
location,
microsoft,
mysql,
oracle,
re-installing,
server,
server2003,
sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment