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 |
|
d.docouto
Starting Member
5 Posts |
 Posted - 2005-07-11 : 13:54:39
|
| I am attempting to backup my database to a network shared folder. The folder does have the appropriate permissions, however if I try to backup the database it fails. The error message that appears in the error log is as follows:BackupDiskFile::CreateMedia: Backup device '\\COMPUTERNAME\SharedDocs\Backup\Jul1105.bak' failed to create. Operating system error = 5(Access is denied.).BACKUP failed to complete the command BACKUP DATABASE TestDatabase TO DISK = '\\COMPUTERNAME\SharedDocs\Backup\Jul1105.bak' WITH STATSIf I attempt to backup the same file to the local computer, it works no problem. I know for sure, the permissions are fine. Is there something I should be doing different to backup over a network?Thanks in advance for the help everyone! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-07-11 : 15:28:22
|
| The permissions aren't correct though. That's why you are getting Access is denied error. How is the backup command being issued? Via a job scheduler? Via osql.exe?Tara |
 |
|
|
d.docouto
Starting Member
5 Posts |
Posted - 2005-07-11 : 16:24:00
|
| BACKUP DATABASE TestDatabase TO DISK = '\\COMPUTERNAME\SharedDocs\Backup\Jul1105.bak' WITH STATSI am using the osql.exe command. The permissions are Everyone, Full control |
|
|
|
TimS
Posting Yak Master
198 Posts |
Posted - 2005-07-11 : 17:05:11
|
| Have you verified BOTH the NT folder permission AND the NT Share permissions?If the file Jul1105.bak already exists; delete it, or rename it, if you can.Tim S |
|
|
|
d.docouto
Starting Member
5 Posts |
Posted - 2005-07-11 : 17:30:47
|
| I have checked the permissions and I have Everyone to full control for both share and folder permissions |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2005-07-11 : 18:22:23
|
| The problem is most likely that the account being used as the SQL Server service account does not have access to the share or folder.If the SQL Server service account is local to your machine or is the NT system account, you will not be able to access a network share.CODO ERGO SUM |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-07-11 : 18:22:45
|
| From Start..Run, can you get to this without having to type in anything about credentials:\\COMPUTERNAME\SharedDocs\BackupWhen you connected via osql.exe, did you use the -E switch or did you use -S and -P?Tara |
|
|
|
|
|
|
Backup MSDE database fails over network