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 |
|
aswindba1
Yak Posting Veteran
62 Posts |
 Posted - 2013-09-20 : 17:28:15
|
| HiIs there any way to move DB to different location with out downtime.It means We have to move DB online with zero downtime. This move can be different hard drive or different server.Currently I am using sql server 2008 R2 Enterprise edition.ThanksAswin |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2013-09-20 : 17:47:25
|
| You can do it with a few seconds of downtime if you use mirroring and have scripts ready to execute to make the switch. Not possible with zero downtime.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
aswindba1
Yak Posting Veteran
62 Posts |
Posted - 2013-09-20 : 17:57:35
|
| Oike..thanks for your prompt reply..What are the options if we want to move DB files lke MDF or NDF to different location.Can we move with zero down time. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2013-09-20 : 18:02:25
|
| I would not recommend moving the database files. That is a slower solution. Setup mirroring in advance as async and then 5 minutes before your maintenance window, switch to sync mode. Then perform the failover. Voila. Using this method will require a connection string change unless you are also planning on renaming the server (standalone) or doing some renames at the cluster level (failover cluster). That type of stuff will take a few minutes.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
Move DB Online