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 |
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
 Posted - 2010-07-28 : 08:16:20
|
| Dear All,If any body done the DB restore from network path,please share with me the script ?Thanks,Gangadhar |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-07-28 : 09:30:44
|
http://social.msdn.microsoft.com/Forums/en/sqldisasterrecovery/thread/adb9c515-9b70-4a8e-a10f-55c7881523b4
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2010-07-28 : 12:41:50
|
| It's no different than a regular restore, it's just that the PATH changes:Local:FROM DISK = 'E:\Backup\SomeFile.bak'Network:FROM DISK = '\\server1\share1\dir1\SomeFile.bak'What will be different though is the speed of the restore. Restoring from a network path will take longer, could be much longer. We've got a system that takes just 2 hours (it's a huge database) when we restore it from the local disks (SAN), yet it takes 5+ hours from a network path. Ensure that your network latency is minimal if this is a concern for you.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
GoldenSQL
Starting Member
3 Posts |
Posted - 2010-07-28 : 14:08:00
|
quote:
Originally posted by webfred
http://social.msdn.microsoft.com/Forums/en/sqldisasterrecovery/thread/adb9c515-9b70-4a8e-a10f-55c7881523b4
No, you're never too old to Yak'n'Roll if you're too young to die.
You can use the network path in place of local drive name for restoration via network.Only one thing you have to keep in mind that you should have permission on the remote network system to read and open the file.Can I help you any more? SQL Guru 4 U |
|
|
|
|
|
|
Can we restore the DB from Network path