Backup database over network not working.

The database server is on computer P4.
Computer P3 has a shared folder with full access.
Computer P5 on which I have my Backup Device and will execute the Backup Database Command using Query Analyzer.

On P5 I created the Backup Device:

USE master
EXEC sp_addumpdevice 'disk', 'myDevice',
'\\P3\temp\test.bak'

Then I executed the following on P5 Query Analyzer:

Backup Database myDatabase TO myDevice

But I get this error:

Server: Msg 3201, Level 16, State 1, Line 1
Cannot open backup device 'myDevice'. 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.

Any idea? Thanks and regards.Originally posted by juniper
The database server is on computer P4.
Computer P3 has a shared folder with full access.
Computer P5 on which I have my Backup Device and will execute the Backup Database Command using Query Analyzer.

On P5 I created the Backup Device:

USE master
EXEC sp_addumpdevice 'disk', 'myDevice',
'\\P3\temp\test.bak'

Then I executed the following on P5 Query Analyzer:

Backup Database myDatabase TO myDevice

But I get this error:

Server: Msg 3201, Level 16, State 1, Line 1
Cannot open backup device 'myDevice'. 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.

Any idea? Thanks and regards.

yeah, go into Enterprise Manager, right click on the db you are trying to backup and all tasks - bring online|||Better yet...don't dump across a network...

It'll be much slower and be at risk for blips in the network...

Dump local then copy...|||Hi guys, thanks for your advice. Brett, I am doing it the way you suggested. However, it would mean that the computer running the database server would have to have a folder permanently shared for my program to copy the file across the network.

Any workaround so that I do not need to share folders? The user might inadvertently unshare the folder and would create problems.

Thanks and regards.|||Ensure the account used to execute this task does have required privileges to access the share specified.

If you're scheduling this task then ensure SQLAgent account used does have admin privileges or a domain account to access so.

Backing up to a server on another domain ?

Hi,
I'm trying to get a SQL 2005 server to backup it's databases to a
shared folder on a server on another domain. It used to work with
older versions of SQL by setting up a null session share on the
destination server, but something's changed in 2005 and it won't play
anymore. No matter what I do re null sessions, it still gives me the
'Cannot open backup device (OS error 1326, error not found)' message
in the log.
Any ideas ? I don't want to setup a trust between the two domains.
Cheers.I suspect the account that SQL Server is running under does not have the
correct permissions to access this share. I have no idea what a NULL session
share is but the account needs to be able to read and write to the share.
Don't use a mapped drive.
--
Andrew J. Kelly SQL MVP
Solid Quality Mentors
<pcmangler@.googlemail.com> wrote in message
news:4639622a-56de-41e9-b0ad-68ee2b52eeec@.c30g2000hsa.googlegroups.com...
> Hi,
> I'm trying to get a SQL 2005 server to backup it's databases to a
> shared folder on a server on another domain. It used to work with
> older versions of SQL by setting up a null session share on the
> destination server, but something's changed in 2005 and it won't play
> anymore. No matter what I do re null sessions, it still gives me the
> 'Cannot open backup device (OS error 1326, error not found)' message
> in the log.
> Any ideas ? I don't want to setup a trust between the two domains.
> Cheers.|||I'm not entirely sure why you're using a null share anyway. If it's a
different domain and you want to save a backup to it, then they need to
provide the acct with permissions on that drive. Even a simple one-way trust
would solve your problem. However, that being said, and the obvious security
risks involved with such a venture, here's a KB article that has some things
to check to make sure you've got everything setup right.
http://support.microsoft.com/default.aspx/kb/289655
"pcmangler@.googlemail.com" wrote:
> Hi,
> I'm trying to get a SQL 2005 server to backup it's databases to a
> shared folder on a server on another domain. It used to work with
> older versions of SQL by setting up a null session share on the
> destination server, but something's changed in 2005 and it won't play
> anymore. No matter what I do re null sessions, it still gives me the
> 'Cannot open backup device (OS error 1326, error not found)' message
> in the log.
> Any ideas ? I don't want to setup a trust between the two domains.
> Cheers.
>