"Yannick Turgeon" <no****@nowhere.com> wrote in message
news:U4*********************@news20.bellglobal.com ...
Hello all,
We currently have disk space problem on our main SQL server (say server
"A") and I'l like to save DBs and logs backups on another server (say
"B"). Is that possible? I tried to set the backup path to point to B but
it generate an error. Serurity/Account issue? SS2K on A was running under
the System account. I tried to change it to an account that was created on
both server. Still an error.
Any help/suggestion would be appreciated.
Both server are running SS2000 SP3. Server A is W2K and B is NT4.
Thanks for your time.
Yannick
The MSSQL service account on server A needs to be a domain account with
access to the share on server B where you want to place the backups. Then a
command like this should work fine:
backup MyDB to disk = '\\serverB\share\folder\MyDB.bak
If you have a local account on each server with the same name and password,
then it will probably work too (I've never tried it myself), but using a
domain account would be easier anyway. There's more information about using
a domain account in Books Online under "Setting up Windows Services
Accounts" and "Changing Passwords and User Accounts".
If this doesn't help, it would be useful to know exactly what backup command
you're executing and what the error messages are.
Simon