Backup to an other server

[solo1234]

Dear user of sql server 2000,

We are busy to make a backup to an other server, we did the next things:

1) We made a shared drive on the target drive on the server where the sql server is running, for example: Z:.
2) test via the explorer or the z: drive is writable: is ok.
3) Configuring the backup there is no posibillity for choosing the z: drive.
4) Configuring the backup there is no posibillity for choosing the \\server\shared_directory\file_name.

Can some give a solution for this problem?

Nice regards,
Michelle.

 

[ptheriault]

SQL Server will only see local resources. You will have to script out the backup command using t-sql. Something like this.

backup database msdb 
TO DISK ='\\NetworkShare\somefolder\msdb.bak'

Also in order for this to work the account that sql is running on must have permissions to the network share. If it doesn't then this will fail. If you are running on Localsystem then this won't work.

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[solo1234]

Hello ptheriault,

As I wrote we can reach the sheared directory on the target server from the server where sqlserver is running.

We are logging in as administrator

We don't understand you're last part. If we are going to the server and open the enterprice manager the sqlserver is local. Via the ip address we can reach him everywhere!

Maybe you have other ideas?

Nice regards,
Michelle.

 

[ptheriault]

The sql server service and sql server agent runs on either a local server account or a domain account. In order for you to be able to backup to a shared network resource then the account your sql server services are running on must have access to the share. So if your services are running on a local account you will not be able to backup to the share. You will not have access to the domain.

Also,
just because you are logged in as administrator does not mean that sql server can see the share. SQL Server can only see local system resources. A share is not a local system resource.

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[LawnBoy]

I do this with Maintenance Plans all the time on SQL2k. You can't select a UNC path, but you can just type it in. The SQL Agent service cannot be running with "system" credentials, it will need to be running with credentials that can access the remote share.



"We must fall back upon the old axiom that when all other contingencies fail, whatever remains, however improbable, must be the truth." - Sherlock Holmes

 

[solo1234]

Hello everybody,

Thanks for the information.

The solution we made is making a scheduled backup with a date in the filename. One hour later a small scheduled task is starting an application thats moves all *.bak to an other server (directory).

Nice regards,
Michelle.