• Add a Comment
  • Edit
  • More Actions v
  • Quarantine this Entry

Comments (8)

1 Amit Vallabh commented Permalink

Hi Del

 
Can you perhaps provide me with more information on how FCM works with MSSQL database. I would like to know when the backup is taken it will quiesce the DB, will this FC commit the log to the DB thus providing us with a PIT copy of the DB. Please advise on functionality.
 
Regards,
Amit

2 Delbert Hoobler commented Permalink

Hello Amit,
Yes, the VSS architecture works in such a way that the application "VSS Writer" (in this case, the SQL Server) works in a federated fashion to make sure the snapshot that it creates is consistent and can be restored. I encourage you to read the "Using Tivoli Storage Manager for performing VSS operations" document and the "How Volume Shadow Copy Service Works" document to learn more.
Del

3 Eiad Al-Aqqad commented Permalink

Hi Del,

 
Thanks for linking to my Tivoli Storage FlashCopy Manager Tutorial. I thought I will share with you and others that I have completed the POC of the TFCM & have used it to do a migration at one of the major banks in our area with a great success about 3 months ago .
 
The bank has really appreciated the product, as it made their parallel run possible & helped do the the migration without a glitch. Keep up the great work.
 
Feature Request: I think it will be nice to include the cloning feature for SQL Databases, just as you have done for Oracle.
 
Enjoy,
Eiad Al-Aqqad
http://www.TSMGuru.com

4 Delbert Hoobler commented Permalink

Hello Eiad,
Thank you for the excellent feedback! Yes, we have heard that SQL Server database cloning is a desirable feature. It is under consideration. Thanks!
Del

5 jane smith commented Permalink

Wonderfully interesting blog post thanks for writing it
I just added your blog to my bookmarks and will check back often.
Car Donation | Desktop PC Computer

6 Tomislav Kralj commented Permalink

Hi,

 
where can I get more info on TS FlashCopy Manager for aix?
Currently we using EMC Replication Manager on emc storages for snaping oracle databases and mounting them on same or other hosts. We are in proces of migration to ds8800 and v7000 and FlashCopy. Is there any tutorials with basic how to and can do?
 
does FlashCopy suport following:
- online snap of a oracle database and mount on other host on other path
- snap of the live database and posybility to restore from snap
- snap of oracle dataguard database and mount on other host on other host
 
Regards
 

7 Tomislav Kralj commented Permalink

Hi,

 
where can I get more info on TS FlashCopy Manager for aix?
Currently we using EMC Replication Manager on emc storages for snaping oracle databases and mounting them on same or other hosts. We are in proces of migration to ds8800 and v7000 and FlashCopy. Is there any tutorials with basic how to and can do?
 
does FlashCopy suport following:
- online snap of a oracle database and mount on other host on other path
- snap of the live database and posybility to restore from snap
- snap of oracle dataguard database and mount on other host on other host
 
Regards
 

8 Delbert Hoobler commented Permalink

Tomislav,

 
A good starting point is the support page for IBM Tivoli Storage FlashCopy® Manager:
http://www-01.ibm.com/support/docview.wss?uid=swg24026421
 
On there, you will find a data sheet, product requirements and the User's Manual. The first chapters of the User's Manual will provide you a good overview what the product is capable of.
 
To answer your specific questions:
 
>> does FlashCopy suport following:
>> - online snap of a oracle database and mount on other host on other path
Yes. Online backups of Oracle databases are possible. They can be mounted to another machine and even cloned. However, Oracle support is for the Unix / Linux platforms only.
 
>> - snap of the live database and posybility to restore from snap
Yes. Restore from snapshot is supported (instant restore/flashback).
 
> - snap of oracle dataguard database and mount on other host on other host
This depends on the host that the backup is mounted to. If this host is not the dataguard standby it should work.

Add a Comment Add a Comment