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 |
|
Revuca
Starting Member
19 Posts |
 Posted - 2002-12-18 : 09:17:12
|
| Hi,Can I backup my sql databases to a mapped network drive ?I can't seem to pick up my mapped drives in Enterprise Manager.As always any suggestions would be highly appreciated.Thanks.Mike |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-12-18 : 09:26:15
|
| Have you tried the T-SQL BACKUP DATABASE command? You should be able to use the UNC in the TO FILE construct.Jay White{0} |
 |
|
|
Revuca
Starting Member
19 Posts |
Posted - 2002-12-18 : 10:25:33
|
| Thanks. Got it sorted. Was referencing the mapped drive letter 'f:' instead of referencing the host/server name. |
|
|
|
royv
Constraint Violating Yak Guru
455 Posts |
Posted - 2002-12-18 : 10:39:46
|
| You will run into problems with Enterprise Manager. I suggest taking Page47's advice and learn how the TSQL BACKUP DATABASE command works. It allows you more control as well, which makes me feel better.***************************************Death must absolutely come to enemies of the code! |
|
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-12-18 : 17:31:13
|
| The drives that are presented by EM result from the exteneded stored procedure xp_fixeddrives which as the name suggests only presents the local drives for the server. If you wish to back up to a network share then run the backup from TSQL using the BACKUP DATABASE command and specify a UNC path.HTHJasper Smith |
|
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2002-12-20 : 02:10:10
|
quote:
The drives that are presented by EM result from the exteneded stored procedure xp_fixeddrives which as the name suggests only presents the local drives for the server. If you wish to back up to a network share then run the backup from TSQL using the BACKUP DATABASE command and specify a UNC path.HTHJasper Smith
I think this is also possible by creating backupdevices, you can define a backup device which can be any network device and have a backup on that device.harshal.Expect the UnExpected |
|
|
|
|
|
|
Backing up to a network drive