Backing up Databases using SQLServer

I have SQL 2000 on a W2K advanced server. I want to use SQL server's
backup routine to backup the databases to a directory on a separate
computer. I have set up the SQL Client Agent on that other server hoping
that would somehow facilitate this, but there doesn't seem to be any way
to force SQL server to backup the file to a device that is not local to
the server itself.
I understand that one possible option would be to install a full version
of SQL 2000 on the other server and has the primary backup to that
secondary server. But that would mean 2 licenses of SQL Server. I
don't think we have 2 licenses, though I will check on that.
Surely there is some way to backup databases to an non-local device.
CurtisHowTo: Backup to UNC name using Database Maintenance Wizard
http://support.microsoft.com/?id=555128
The same technique applies to manual backup jobs as well.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Curtis Vaughan" <curtis@.npc-usa.com> wrote in message
news:eiqgAsisEHA.1468@.TK2MSFTNGP12.phx.gbl...
> I have SQL 2000 on a W2K advanced server. I want to use SQL server's
> backup routine to backup the databases to a directory on a separate
> computer. I have set up the SQL Client Agent on that other server hoping
> that would somehow facilitate this, but there doesn't seem to be any way
> to force SQL server to backup the file to a device that is not local to
> the server itself.
> I understand that one possible option would be to install a full version
> of SQL 2000 on the other server and has the primary backup to that
> secondary server. But that would mean 2 licenses of SQL Server. I
> don't think we have 2 licenses, though I will check on that.
> Surely there is some way to backup databases to an non-local device.
> Curtis|||So, if I understand correctly the MSSQLSERVER service must be switched
from running under the LocalSystem account to running under a
domain-level account, such as, let's say, DataAdmin with a password. And
which account is not local to the server, but global to the domain. Right?
If that's true, what rights do I have to give the DataAdmin account?
Curtis
Geoff N. Hiten wrote:

> HowTo: Backup to UNC name using Database Maintenance Wizard
> http://support.microsoft.com/?id=555128
> The same technique applies to manual backup jobs as well.
>|||Curtis,
Per the KB article ...
2) The SQL Server service account must have FULL CONTROL rights to the file
system folder and to the share
Tunji
"Curtis Vaughan" <curtis@.npc-usa.com> wrote in message news:envLaWjsEHA.160@.
TK2MSFTNGP11.phx.gbl...
So, if I understand correctly the MSSQLSERVER service must be switched
from running under the LocalSystem account to running under a
domain-level account, such as, let's say, DataAdmin with a password. And
which account is not local to the server, but global to the domain. Right?
If that's true, what rights do I have to give the DataAdmin account?
Curtis
Geoff N. Hiten wrote:

> HowTo: Backup to UNC name using Database Maintenance Wizard
> http://support.microsoft.com/?id=555128
>
> The same technique applies to manual backup jobs as well.
>|||Everything works better if you give the domain-level account (DataAdmin in
your example) local administrator rights on the SQL server host computer.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Curtis Vaughan" <curtis@.npc-usa.com> wrote in message
news:envLaWjsEHA.160@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> So, if I understand correctly the MSSQLSERVER service must be switched
> from running under the LocalSystem account to running under a
> domain-level account, such as, let's say, DataAdmin with a password. And
> which account is not local to the server, but global to the domain. Right?
> If that's true, what rights do I have to give the DataAdmin account?
> Curtis
> Geoff N. Hiten wrote:
>