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 |
|
swnz
Starting Member
2 Posts |
 Posted - 2004-06-10 : 00:19:59
|
| I'm having a few problems adding a dump device, located on a different machine than the instance of SQL Srv 2000.When I try to use a UNC path, either via Enterprise manager->Backup-New Backup device, or the sp_addumpdevice stored procedure, it complains that it is "unable to verify the existence of the backup file location." It will also give this error if I map a network drive to the server, and when I map it to a shared folder on a different server.I have also tried to install Enterprise manager on the server that I want the backups to be copied to. But, when you are presented with the choice of drive letters available to store the backup on, it shows the drives that are on the SQL server, not the server it is installed on!Is there any other way I can force SQL Srv to use a different server to store the dump media on? I don't want to write a batch file that copies the files to another srv, for a variety of reasons. |
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2004-06-10 : 02:28:41
|
| Hi swnz,So, you don't have any issues mapping the drive, or writing to it (test by copying a 1kb text file if you haven't). So, if it isn't a permission's problem, then try to backup via script:backup database DBNAMEto disk = '\\targetservername\sharename\backupfilename.bak'with init,stats=1goCiaO*##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here! |
 |
|
|
ericc@cidp.com
Starting Member
3 Posts |
Posted - 2005-06-03 : 19:52:13
|
| Hello, I see that this is an old thread but I just ran into this same issue. I have tried the script mentioned and it failed to backup to the desired mapped drive.FYI - When I tried to add a new backup device, I only see the servers local drive and 1 other mapped drive(I can successfully backup to this drive) . I can't see the mapped drive that I added the other day. I have full access to the new mapped drive through the OS but SQL Server will not backup to it. When I try to enter the UNC to the new OS mapped drive I get the message "Unable to verify the existence of the backup file location. Do you want to use the backup file location anyway?"In summary, On my SQL Server Machine I have 2 mapped drives. the mapped drives are on 2 separate servers. I can successfully backup to one and not the other. As far as I can tell, on the OS level I have equal and full access to each server.Any idea what the problem might be?(other than my lack of knowledge)Does SQL Server use its own user/pass to access the mapped drives? If so, what is it? Thanks in advance for any help. |
|
|
|
|
|
|
|
|
Backup to a different server.