Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Backup DB over network to remote computer 1

Status
Not open for further replies.

redlam

MIS
Jun 28, 2000
218
US
I know I'm missing something obvious but this has been giving me a headache for over an hour now so I have to ask...
I'm trying to send my backup files (SQL2000) over the network to another server on the same domain. I have mapped a drive from the SQL server to this machine. I am using Windows Authentication and I have verified permissions on both servers for this user. I am executing the following backup statements, neither of which are working:

BACKUP DATABASE [mydb] TO DISK = N 'g:\backup\mydb.bak' WITH NOINIT , NOUNLOAD , NAME = N 'My backup', NOSKIP , STATS = 10, NOFORMAT

BACKUP DATABASE [mydb] TO DISK = N '\\server_name\backup\mydb.bak' WITH NOINIT , NOUNLOAD , NAME = N 'My backup', NOSKIP , STATS = 10, NOFORMAT

SQL is returning this error (for both):
Server: Msg 3201, Level 16, State 1, Line 1
Cannot open backup device '\\server_name\backup\mydb.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.

This is what the error log says:
BackupDiskFile::CreateMedia: Backup device '\\server_name\backup\mydb.bak' failed to create. Operating system error = 5(Access is denied.).

Like I said... I've tested permissions on both servers. Backups for the same server run properly when saved to the local machine. This is making me nutty s-) Can anyone shed some light for me?
Thanks!
 
The SQL backup statement will use the permissions of the account used to start SQL Server. Does that account have permissions on the other server? Terry

The reason why worry kills more people than work is that more people worry than work. - Robert Frost
 
This is definitely the problem. Permissions and security type stuff always trips me up :)
Thanks Terry.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top