dajonx

updated

15 years ago

D

dajonx

2 Intern

294 Posts

0

85033

October 26th, 2011 10:00

SAN Replication and SQL Server 2008 R2

Hi,

I currently have SAN Replication going from the primary SAN to the backup SAN.  I am replicating SQL database volumes.  I was wondering if it would be possible if I clone the replica on the backup SAN, will I be able to attach the SQL database and perform a backup (on the backup SAN/server)?  This shouldn't affect the replication schedule from the primary SAN to the backup SAN, correct?

Thank you!

  • Joe S586

    9 Technologist

    729 Posts

    1422

    1

    Posted October 28th, 2011 10:00

    dajonx,

    On the clone volume also check this:

    Start Diskpart

    DISKPART> diskpart

    DISKPART> list volume

    Now locate the volume in question and identify the volume number

    DISKPART> select volume [volume #]

    DISKPART> detail volume

    example:

    Disk ### Status Size Free Dyn Gpt

    -------- ---------- ------- ------- --- ---

    * Disk 3 Online 10 GB 0 B

    Readonly : Yes

    Hidden : Yes

    No Default Drive Letter: Yes

    Shadow Copy : Yes

    DISKPART> attributes volume clear hidden

    Volume attributes cleared successfully.

    DISKPART> attributes volume clear readonly

    Volume attributes cleared successfully.

    DISKPART> detail volume

    Disk ### Status Size Free Dyn Gpt

    -------- ---------- ------- ------- --- ---

    * Disk 3 Online 10 GB 0 B

    Readonly : No

    Hidden : No

    No Default Drive Letter: Yes

    Shadow Copy : Yes

    Optionally you may also need to clear the following:

    DISKPART> attrib volume clear shadowcopy

    DISKPART> attrib volume clear nodefaultdrivelette

    Regards,

    Joe

  • dajonx

    2 Intern

    294 Posts

    1422

    1

    Posted October 28th, 2011 10:00

    Joe,

    The "attributes volume clear readonly" worked.  Another thing that I had to do to attach the database to SQL Server is open SSMS with Run As Administrator.  

    Yay!  Success!  Thanks!

  • Joe S586

    9 Technologist

    729 Posts

    1648

    0

    Posted October 26th, 2011 11:00

    dajonx,

    Yes, you can clone a replica to create a new volume on the secondary group. The new volume contains the same data that existed at the time you created the replica; initiators can connect to it in the usual way. Cloning a replica has no impact on the original volume and the replication configuration. If the original volume is still available, replication can continue, as usual.  Ensure you have enough free space available on the DR PS Array group cloning a replica volume.

    Regards,

    Joe

  • DELL-Chris H

    7 Practitioner

    9682 Posts

    48046 Points

    1648

    0

    Posted October 26th, 2011 11:00

    Dajonx,

    There are a couple things that can be done. Your way is possible, but there are faster options.

    Such as you can take a snapshot of the SAN and then go to another host and load the snapshot for backup. Or you can go to support.equallogic.com/support and then click on Back Up Solutions for other methods, that may work a bit better for you.

    The Replication is a consistent backup, but it takes a lot longer to perform than some of the others.

    DELL-Chris H

    Social Media and Communities Professional

    Dell Technologies | Enterprise Support Services

    #IWork4Dell

    Did I answer your query? Please click on ‘Mark as Accepted Answer’. ‘Thumbs up’ the posts you like!

  • dajonx

    2 Intern

    294 Posts

    1648

    0

    Posted October 26th, 2011 11:00

    Thank you very much!  

    Chris; I was not able to locate the "Back Up Solutions" on the Support page.  Can you please link to that page?

  • dajonx

    2 Intern

    294 Posts

    1648

    0

    Posted October 27th, 2011 08:00

    I have attempted to mount a snapshot on the DR SAN from the Primary SAN which worked.  When I tried to attach the database to SQL Server, it said:

    CREATE FILE encountered operating system error 5(Access is denied) while attempting to open or create the physical file 'F:\SQL Data\Database.MDF'. (Microsoft SQL Server, Error: 5123)

    What am I doing wrong here?

  • dajonx

    2 Intern

    294 Posts

    1648

    0

    Posted October 27th, 2011 08:00

    I have initially tried attaching the database using the SSMS GUI.  When I tried attaching the database using T-SQL, the error message is:

    Unable to open the physical file "F:\SQL Data\Database.MDF".  Operating system error 5: "5(Access is denied.)".

  • dajonx

    2 Intern

    294 Posts

    1648

    0

    Posted October 27th, 2011 09:00

    Hmm...  When I tried cloning, I was unable to attach the database and getting the same error message...

  • Joe S586

    9 Technologist

    729 Posts

    1648

    0

    Posted October 27th, 2011 12:00

    Ensure you cloned the inbound replica volume by follow these procedure:

    psonlinehelp.equallogic.com/.../groupmanager.htm - select Replication Tasks> Cloning an Inbound Replica.

    Then,  take a look in the server event log, or the sql event log, what event did you see when the database tried to attach, and see what it says.

    Joe

  • dajonx

    2 Intern

    294 Posts

    1648

    0

    Posted October 28th, 2011 07:00

    I have figured out that you must open SSMS as "Run As Administrator" to bypass the "Access is denied" error message.

    However, I still cannot attach the database.  The error message now is "Could not open new database 'Database_TEST'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 1813)"

    In the Application Logs, I have four error messages:

    1) fcb::close-flush: Operating system error (null) encountered.

    2) FCB::ZeroFile(), GetOverLappedResult(): Operating system error 19(The media is write protected.) encountered.

    3) FixupTail: Operating system error 19(The media is write protected.) encountered.

    4) Starting up database 'Database_TEST'.

    Do you know how to resolve these issues?