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 |
|
packetsmacker
Starting Member
4 Posts |
 Posted - 2011-04-15 : 11:09:17
|
| i have sql 2008 express. When i go to add a backup device i cannot see any mapped drives. If i use t-sql to create the device using the mapped drive letter or unc path it lets me create the device. When i try to use it i get an error saying can’t open backup device. I think could do this with 2005. I am guessing I am missing something surely this option has not be removed. |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2011-04-15 : 11:14:27
|
Don't try to use mapped drives.Use the UNC name:\\servername\sharename\foldername\backupfile.bak CODO ERGO SUM |
 |
|
|
packetsmacker
Starting Member
4 Posts |
Posted - 2011-04-15 : 15:06:16
|
quote:
Originally posted by Michael Valentine Jones
Don't try to use mapped drives.Use the UNC name:\\servername\sharename\foldername\backupfile.bak CODO ERGO SUM
I used unc as well same error. |
|
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2011-04-15 : 16:20:39
|
| What user is running SQL Server? Is it the default local system? If so, then you need to change it to a domain account and grant that domain account access to the share. |
|
|
|
Jahanzaib
Posting Yak Master
115 Posts |
Posted - 2011-04-16 : 01:12:27
|
| First check the network path with the help of Run and pass the full network path to it as \\Testserver\Backupcreate a txt file on this folder ,this will verify the accessibilityof this path if SQL Server service account is running on local account then use Domain account for SQL server service account and this account should have access on that server or folder or mapped drive then execute the script it will workRegards,Syed Jahanzaib Bin HassanMCTS,MCITP,OCA,OCP,OCE,SCJP,IBMCDBAMy Blogwww.aureus-salah.com |
|
|
|
|
|
|
network backup