Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-08-03 : 11:52:50
|
| Paul writes "Dear Sir, The sqlguru stated, "My favorite method is ... BACKUP DATABASE Foo TO DISK'\\myserver\myshare\foo.bak' WITH INIT I try this and get a "Kernel" error in the Server Error Log saying, "BackupDiskFile:CreateMedia: Backup device '\\MyRealServer\d$\SQLServer\Backup\Data\Test.BAK'failed to create. Operating system error = 5 (Access is denied). The UNC pathname is correct and the 'Data' directory will appear if Icopy/paste into a Start/Run dialog. Also, if I use xp_sqlmaint, I get the same O/S error 5. Am I doing something wrong in SQL Server, or is this an operating systemproblem. We're running Win NT 4.0 SP 6a and both the SQL Server andremote server are in the same domain.PaulColumbia, MD" |
|
|
|
|
|
Re: Can I Backup Across the Network - ItemID=408