Hi All,

I am trying to take a database backup from a sql server which is on 'x' domain and trying to store it on 'y' domain and I get the below error. 

--------------------------------------------------------------------------------------------------------------------
Server: Msg 3201, Level 16, State 1, Line 1
Cannot open backup device '\\servername\shared_folder_name\north_wind.bak'. Device error or device off-line. See the SQL Server error log for more details.
Server: Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.
--------------------------------------------------------------------------------------------------------------------

Below is my understanding on this problem:

I guess, I need to make the x & y domain as trusted connection, and give the permission for sqlservice account to y(domain) shared folder.

Please confirm whether my understanding is correct or not.

Thanks,
Bala

I would guess the domains would need a trust in place for this and SQL service accounts with correct permissions.

cant ya cheat and just copy the backup to the other servers drive :)

true, to achieve this both domain have trust relationship (trusted domains) and then you can access their shared resources but again you have to manage NTFS permission too

If not you can use the same account between thse 2 domains with necessary privileges in order to perform the backup.

All,

Thanks for the reply, I try out the options suggested.

Thanks once again.

- Bala