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!
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!