July 26, 2007 at 10:40 am
Hi,
We are looking on EMC TimeFinder/Clone and Replication Manager as a replacement for SQL Server backups. It, promiss to replicate DB files directly on SAN/DMX allowing DB and point of time recovery for databases.
Are anybody have experience on using this technology as a backup/restore solution.
It sounds scary for DBA, but could be great solution if it will work for SQL Servers.
Thanks
August 2, 2007 at 1:57 pm
We been using it for the past 5 years. It works perfect. It is just like mirroring of your drives. Occasionnaly the process fails due to network issue etc but it works fine. We do have a backup job using veritas to backup to tape as well as a secondary backup set.
August 3, 2007 at 2:16 am
From what I understand, the Replication Manager has a VDI/VSS interface to allow for consistent hot backup of the SQL DBs. When a corruption occurs to the DB, the entire volumes (typically in GB/TB capacity) or logs rollback can be restored within minutes. Admin has the option to bring online the DB upon the completion of a restore. Quite easy to use and the wizard based GUI really helps the DBA get our jobs done.
August 3, 2007 at 4:17 pm
Many weekends of 'fun' ....
One caveat:
At my previous job, with SS2K/nightly LiteSpeed Diffs/EMC TimeFinder, we found that it produced mismatched LSN for DIffs, which couldn't be used for DR and for Restore in other Environments using Full & Diff. However Restore of Full backup and Tran Logs would work, but you dont want to restore multi TB database on Friday with Tran Logs only. I went thru that 4 years ago and it was fun!
in SS2005, I believe that issue with Diff backup was resolved.
August 3, 2007 at 4:25 pm
DBA and LAN personel were involved in that, while LAN got adequate training, we, DBA` were not.
We were using that for replacing of Log Shipping, but the problem was: if LS would fail in the middle of the night - I know how to fix it. With SnapClones -you dont want to mess with that when it was configured by LAN guys. Bottom line. Get good training.
But for backups I would use LiteSpeed.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy