Follow sqlserver-dba.com

Subscribe to RSS feed  Follow @jackvamvas - Twitter

*Use the Comments section for questions

SQLServer-DBA.com Links

Dba_db2_button

dba-ninja.com

SQL Server DBA Jobs

Researching FlashCopy Manager for backup and restore management

21 March,2015 by Tom Collins

Data sets are growing. Requirements for increased Production data availability are expanding in the 24 x 7 world. But amongst all this change – there still remains the critical demand for the DBA to support the agreed Recovery Point Objective (RPO).

I’m  always looking for ways to offload the backup  workload . During the backup window, server performance degrades. I’ve recently been researching Flash Copy Manager. These are some scenarios \ thoughts \ issues requiring investigation.

When investigating new  Backup and Restore products and how they may apply to an environment, simple or obvious questions can sometimes elicit responses revealing gold mine information. I’m never scared to ask the obvious question.

Scenario 1 – Data corruption and FlashCopy Manager

Can we complete a data recovery of an older level of data , for example, due to a logical application error? Would that be at a database level or drive level?

Scenario 2- ETL and FlashCopy Manager

Can Flash Copy of data be restored onto another server, with another server name, security and supporting files, maintaining  consistent transactions and be available for read\write?

Is there a documented process for Instant restore of volume process?

Scenario 3 – High Availability and FlashCopy Manager

If the SQL Server is set up in an AlwaysOn configuration i.e high availability  databases – do the nodes on TSM need to be set up differently.?

Is the snapshot transaction consistent across all the drives?If  data and transaction log files are stored across different drives

If any Production DBAs have  Flash Copy Manager experience in a Production Database Server environment, I’d like to hear from you. Your feedback will assist me to assess Flash Copy manager

Read More on Disaster Recovery

Creating a Disaster Recovery Plan - SQL Server DBA

Powershell and Disaster Recovery preparation - SQL Server DBA

Full Recovery without Log Backups - SQL Server DBA

Redundancy for SQL Server - SQL Server DBA

 


Author: Tom Collins (http://www.sqlserver-dba.com)


Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on Researching FlashCopy Manager for backup and restore management


sqlserver-dba.com | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer