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?
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.
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.
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!
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)
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.
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