SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Move DB Online
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

aswindba1
Yak Posting Veteran

USA
62 Posts

Posted - 09/20/2013 :  17:28:15  Show Profile  Reply with Quote
Hi

Is 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.

Thanks
Aswin

tkizer
Almighty SQL Goddess

USA
36851 Posts

Posted - 09/20/2013 :  17:47:25  Show Profile  Visit tkizer's Homepage  Reply with Quote
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 Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

aswindba1
Yak Posting Veteran

USA
62 Posts

Posted - 09/20/2013 :  17:57:35  Show Profile  Reply with Quote
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.
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36851 Posts

Posted - 09/20/2013 :  18:02:25  Show Profile  Visit tkizer's Homepage  Reply with Quote
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 Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.16 seconds. Powered By: Snitz Forums 2000