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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 backup to mapped drive

Author  Topic 

matt_calhoon
Posting Yak Master

235 Posts

Posted - 2004-05-24 : 23:51:30
Hi there,

I have created a mapped drive with the hope that sql server 7.0 can backup to it. However, I get the following error: Operating system error = 3(The system cannot find the path specified.) when scheduling the job.

Do I need to restart the sql service for it to recognise the mapped drive or is what I am trying to do not possible?

thanks - matt

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2004-05-25 : 03:06:22
When you map a drive, that is mapped for you in your session. The SQL Server service can't see your mapped drive.

Can you use UNC paths instead ?


Damian
Go to Top of Page

matt_calhoon
Posting Yak Master

235 Posts

Posted - 2004-05-25 : 03:55:53
thats a good point!

I tried using UNC but says "invalid" in the Db Maintenance screen in EM.
Go to Top of Page

JimL
SQL Slinging Yak Ranger

1537 Posts

Posted - 2004-05-25 : 08:15:26
Matt the backup must be in reference to what the SQL Server sees.

I use plain network paths for backups to my snapserver but I run SQL 2000, I do not know if it will work on 7.

Jim
Users <> Logic
Go to Top of Page
   

- Advertisement -