![]() SnapDrive software integrates with Windows Volume Manager so that storage systems can serve as virtual storage devices for application data in a Windows Server environment. This can be a lot faster with snapshot technology.įurther reading on how Snap manager works. SnapDrive provides the underlying layer of support for SnapManager by making storage available to a Windows Server host. Also consider scenario's where you need to refresh copies of acceptance and test. However, especially when you have large databases, using storage based snapshots can be very benificial in regards to backup and restore times. So for existing SQL Servers that migrate to Netapp or for server where you want to use Snap manager as a backup strategy this might be an extra hurdle to take. Additionally you'll need an extra lun for snapinfo. You need seperate LUNS for your system databases, your temdb, your user db data files and your user db log files. Snap manager does have certain demands with the disk layout. Since Snap manager interacts with SQL Server to coordinate an transactional consistent backup. But with this solution you are able to create backups in the correct way. It's not a free Netapp option, so you need additional licenses. However, Netapp offers Snap manager for SQL Server "Just" making a snapshot of volume on your Netapp can not be considered the correct way of making a backup of SQL server databases. So, is it really true, that we can replace database backups, transaction log backups and any other backups using those products and technology and still stay able to respond to point in time recovery requests for our databases? But if so, I fear that any of those snapshots are pretty useless as soon we have lost our source database, right? I do not really know much about database snapshots and (because) did not really use it so far, and I do not know if this netapp snapshot is the same snapshot/technology that sql supports. So the one person that still is very sceptic about this and not yet able to be a part of all those excited and euphoric celebrations is - me. Unfortunately I was not involved in product selection process or any meetings or demos. In the process of getting some new magic and high speed SAN devices I was told by those crazy magic-SAN-things-administrating IT people that it will be obsolete to perform ANY Sql-Server Backups in future, as soon we start using this netapp snapmanager snapshot magic.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |