x

Database Mirroring with multiple filegroups

Is it possible to implement Database Mirroring in SQL Server 2005 (any mode) if the database being mirrored has multiple filegroups, i.e. one of more .ndf files?

more ▼

asked Oct 13, 2009 at 07:22 AM in Default

Lempster gravatar image

Lempster
21 1 1 1

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

4 answers: sort oldest

Also, be aware when adding a new file to a mirrored database that the underlying directory structure has to already exist on the mirror server or adding the new file will fail on the mirror.

more ▼

answered Oct 17, 2009 at 06:56 PM

Robert L Davis gravatar image

Robert L Davis
172 3

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

Yes, it is, but you can't mirror FILESTREAM filegroups under 2008.

more ▼

answered Oct 13, 2009 at 07:42 AM

Matt Whitfield gravatar image

Matt Whitfield ♦♦
29.4k 61 65 87

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

When you restore the initial backup, you specify the filegroup structure, and can have the filegroups in different locations, however as mentioned by Matt, the FILESTREAM filegroup is not supported.

more ▼

answered Oct 13, 2009 at 04:44 PM

Steve Jones - Editor gravatar image

Steve Jones - Editor ♦♦
5.1k 77 79 82

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

Yes you can ;)

Best is to have the same logical disk names and directory structures underneath your databases. (that guarantees that you can add files to filegroups, ...)

more ▼

answered Oct 18, 2009 at 10:56 AM

ALZDBA gravatar image

ALZDBA
11

(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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x343
x57

asked: Oct 13, 2009 at 07:22 AM

Seen: 2529 times

Last Updated: Oct 15, 2009 at 05:47 AM