Solved

Can a database be moved to a new drive without needing to rebuild the mirror?

Posted on 2013-11-21
1
232 Views
Last Modified: 2013-11-25
I have a 2005 database in the standard edition of SQL Server that is mirrored to a disaster recovery site.  I plan to move one of it's data files to a new drive this weekend.  Can I pause the mirroring, detach the primary database, move it's data file, reattach it, and resume it's mirror?  Or will I need to rebuild the mirror once the move is complete?
0
Comment
Question by:navajo26354
1 Comment
 
LVL 75

Accepted Solution

by:
Aneesh Retnakaran earned 500 total points
ID: 39667239
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

706 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now