sql server mirroring issue


I've got a problem with mirroring, the mirroring database server without witness is almost full and I want to move the mirroring database server to new hard disk. So, can anyone let me know can it be done.


more ▼

asked Feb 05 '10 at 02:31 PM in Default

sachin gravatar image

21 1 1 1

Do you mean source database or mirror? There isn't a mirroring database.
Feb 21 '10 at 11:02 PM Steve Jones - Editor ♦♦
(comments are locked)
10|1200 characters needed characters left

3 answers: sort voted first

Provided you named your disk volumes identical on both the Principal and Mirror servers, I believe you can add a new data file at the Principal server and that the same DDL change will also be made at the Mirror. Doing so could negate the need to move the entire Mirror database to new storage.

If you wish to move the Mirror to new storage then I believe that you will need to suspend the Mirroring session.

My advice to you is that you test the "entire" process ahead of time, in a non-production environment, so that you can validate all of your work steps.

more ▼

answered Mar 22 '10 at 09:00 AM

John Sansom gravatar image

John Sansom
897 2

(comments are locked)
10|1200 characters needed characters left

How can you move a database without getting it offline, which means you have to stop the DBmirroring until the process is done.

more ▼

answered Feb 20 '10 at 02:57 PM

SQLMaster gravatar image

81 2

(comments are locked)
10|1200 characters needed characters left

By any means changes to the hardware for SQL server environment, you must stop the DB mirroring session in order to affect the new changes.... I wouldn't recommend trials of any such practices to jeopardise the SQL environment availability.

more ▼

answered May 07 '10 at 07:09 PM

SQLMaster gravatar image

81 2

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Feb 05 '10 at 02:31 PM

Seen: 1663 times

Last Updated: Feb 05 '10 at 02:35 PM