Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 backup on remote comupter

Author  Topic 

acko
Yak Posting Veteran

52 Posts

Posted - 2006-05-29 : 07:57:23
Hi

How can i make backup on the other computer.

1. SQL computer is express edition, and computers are in workgroup?

2. SQL computer is express edition and is not on domain, and backup computer is on domain.

thanks

alex

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2006-05-29 : 09:05:28
use the unc pathname in the backup procedure like
\\machinename\directory
--------------------
keeping it simple...
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-05-29 : 09:16:47
And make sure that it is shared and you have permission to access that
It is better to take backup on the local server and copy that to other server

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

Norwich
Posting Yak Master

158 Posts

Posted - 2006-06-01 : 09:31:39
or backup locally and shedule an ntbackup job that will copy it to your remote

Regards
N

The revolution won't be televised!
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2006-06-02 : 06:41:49
I would recommend that you backup locally and then copy/move the files to the remote machine. I have lots of horror stories about backups direct to remote systems failing (network outage etc. etc.) and the problem not being spotted until it is too late!

Kristen
Go to Top of Page
   

- Advertisement -