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 |
|
krajdba
Starting Member
43 Posts |
 Posted - 2008-03-26 : 06:32:54
|
| HiI have Production DB backups on Server1 and I need to restore this DB in server2 DB instance, both the servers are in clustered environment which has SAN and LUNs in it.How can I restore the DB without actually migrating it to server2 across the network?Very urgent please.Thanks & RegardsRaj. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-26 : 10:01:29
|
| Not possible unless you disconnect the lun so that other server can access the bak files which is very dangerous. I had similar situation so i had to copy the bak files. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-26 : 21:55:43
|
| You can restore with this command on server2 as long as sql service account on server2 has permission to read backup file:restore database db_name from disk = '\\server1\path\file' with ... |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-03-27 : 00:09:49
|
quote:
Originally posted by sodeep
Not possible unless you disconnect the lun so that other server can access the bak files which is very dangerous. I had similar situation so i had to copy the bak files.
Not true. You can access the drives across the network and therefore restore from the file as rmiao showed. Luns just point to a drive letter, which is available remotely.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-27 : 09:35:51
|
| Oops, I was talking about attach/detach method. |
|
|
|
|
|
|
How to Restore a DB