Database backup to a remote server

Hi All,
I am trying to do a backup of the SQL Server database to a remote server. I
tried mapping the remote server to the server that has the SQL Server
installed and then specifying the drive letter and the folder. I also tried
giving the complete path - \\ipaddress\folder\backup.bak but I got a error
message. Can someone please let me know what's the correct way of doing this?
Thanks in advance.
Hi
SQL Server and SQL Server agent need to run under a Domain Account that has
permissions on the destination server and share.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"sharman" wrote:

> Hi All,
> I am trying to do a backup of the SQL Server database to a remote server. I
> tried mapping the remote server to the server that has the SQL Server
> installed and then specifying the drive letter and the folder. I also tried
> giving the complete path - \\ipaddress\folder\backup.bak but I got a error
> message. Can someone please let me know what's the correct way of doing this?
> Thanks in advance.
|||Hi,
1.You Should start SQL server using Domain user who got access to remote
machine Share
2. Should have share in the remote machine
3. If you need to schedule this as a job then SQL Agent should use the same
Domain user in which SQL server was started
4. Restart the services
Now you can execute the Backup script with UNC path
BACKUP Database <dbname> to disk='\\computername\sharenameXX\dbname.bak'
with init
Note:
Backup to remote machine will not work if you start SQL server using Local
system account
Thanks
Hari
SQL Server MVP
"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:CDA2BE2A-EC9C-4519-A4CA-3D97EEAF0A64@.microsoft.com...
> Hi All,
> I am trying to do a backup of the SQL Server database to a remote server.
> I
> tried mapping the remote server to the server that has the SQL Server
> installed and then specifying the drive letter and the folder. I also
> tried
> giving the complete path - \\ipaddress\folder\backup.bak but I got a error
> message. Can someone please let me know what's the correct way of doing
> this?
> Thanks in advance.