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 - 2003-11-12 : 08:26:26
|
| Michael Theron writes "I have installed a new Windows 2003 server with SQL server 2000.On the server, I have used Net Use to capture network drives to other Windows 2000 servers on which we keep our backup files.If I go through windows explorer, I can see all the mapped drives and go onto them without a problem.When I go through the SQL Enterprise manager to create a backup device, I can only see the local drives. Why can SQL not see any of the network drives ?" |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-11-12 : 08:32:17
|
| The drive mappings are created for you when you log on. SQL Server isn't logged on as you in a desktop session so those mappings don't exist for it.Can you use unc paths insead ? i.e. \\server\shareDamian |
 |
|
|
gercr
Yak Posting Veteran
53 Posts |
Posted - 2003-11-12 : 11:20:52
|
| Isn't true that to restore a Backup from a File it must reside on the local Hard drivers?? |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2003-11-12 : 11:39:53
|
| No, you can restore from a UNC with the following:RESTORE DATABASE setups FROM DISK = '\\10.0.7.22\e$\MSSQL\BACKUP\db_name_full_20031010.bak' WITH FILE = 1, NOUNLOAD , STATS = 5, RECOVERY , REPLACE , MOVE 'DTSetup_dat' TO 'f:\mssql\data\db_name_data.mdf', MOVE 'DTSetup_log' TO 'e:\mssql\log\db_name_log.ldf'MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-11-12 : 12:23:46
|
| Enterprise Manager can not see networked drives. Use Query Analyzer with Derrick's example as a template.Tara |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2003-11-12 : 14:00:25
|
| The SQLServer service account will need to have access on that remote machine as well.-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
|
|
|
|
|
|
Network Drives