Showing posts with label re-installing. Show all posts
Showing posts with label re-installing. Show all posts

Tuesday, February 14, 2012

Changing Default Backup Location for SQL Server 2003

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...
>
>

Changing Default Backup Location for SQL Server 2003

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
Hi
SQL Server 2003 does not exist. SQL 2000?
In the registry:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ 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\MSSQLServer\ 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...
>
>

Changing Default Backup Location for SQL Server 2003

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\MSSQLServer\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\MSSQLServer\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
>
>