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 - 2002-07-23 : 08:58:04
|
| Raj writes "Hi,Is it alright to store your (complete, differential, transaction) backups on a NAS solution located on your network? Please let me know if this is alright.Raj Antony" |
|
|
solart
Posting Yak Master
148 Posts |
Posted - 2002-07-24 : 11:07:48
|
| The question as I understand it is one of whether something works, not one of if its a good idea or practical.I believe the answer is yes. I did find this covered in a book I have, but don't remember which one.I don't remember if using a "mapped" drive works, but pretty sure using Universal Naming Convention should work. May require a specific network protocol such as TCP/IP. Named pipes may not work.Will try and find this info again in the books I own.Setup and test.HTHs solart |
 |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-07-24 : 17:11:45
|
| Use UNC path'sIf you have enough local storage on your SQL Server dump your backups locally and then copy them across - this will be more efficent (and have less impact on your server) than backing up across the network.HTHJasper Smith |
|
|
|
solart
Posting Yak Master
148 Posts |
Posted - 2002-07-26 : 16:35:20
|
| I have learned that NAS is only OK if hardware/network meets specific conditions.Local Disk and SAN supported.Please read Q304261 Support for Network based files.solart |
|
|
|
|
|
|
Storing SQL Backups On NAS