Sql server 2005
- IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do?-
Answers
- what do you mean by move the database?
are you trying so the database can be access from multiple app?
some links about minimizing down time
http://www.pythian.com/news/1159/how-to-minimize-downtime-when-moving-to-a-new-sql-server-environment
http://blogs.msdn.com/sqlcat/archive/2009/02/09/minimize-downtime-with-db-mirroring.aspx
http://msdn.microsoft.com/en-us/library/bb677181.aspx
Best Regards,
Melissa Suciadi
If you have found this post helpful, please click the 'Vote as Helpful' link (the green triangle and number on the top-left).If this post answers your question, click the 'Mark As Answered' link below. It helps others who experience the same issue in future to find the solution.
- Proposed As Answer byChunSong Feng -MSFTMSFT, ModeratorTuesday, November 10, 2009 6:02 AM
- Marked As Answer byChunSong Feng -MSFTMSFT, ModeratorMonday, November 16, 2009 9:56 AM
All Replies
- Are you meaning to move the database in the same server (file relocation) or different server ?
Thanks, Leks - what do you mean by move the database?
are you trying so the database can be access from multiple app?
some links about minimizing down time
http://www.pythian.com/news/1159/how-to-minimize-downtime-when-moving-to-a-new-sql-server-environment
http://blogs.msdn.com/sqlcat/archive/2009/02/09/minimize-downtime-with-db-mirroring.aspx
http://msdn.microsoft.com/en-us/library/bb677181.aspx
Best Regards,
Melissa Suciadi
If you have found this post helpful, please click the 'Vote as Helpful' link (the green triangle and number on the top-left).If this post answers your question, click the 'Mark As Answered' link below. It helps others who experience the same issue in future to find the solution.
- Proposed As Answer byChunSong Feng -MSFTMSFT, ModeratorTuesday, November 10, 2009 6:02 AM
- Marked As Answer byChunSong Feng -MSFTMSFT, ModeratorMonday, November 16, 2009 9:56 AM
