Data Backup and Recovery

SQL, best practice for volumes, luns, etc.

HendersonD

I  have had a SQL 2005 server for some time and am just about to bring  online a SQL 2008 R2 server. Eventually I will be migrating all of my  databases from the old to the  new and getting rid of the 2005 server.

We have a Netapp FAS3020 that is housing the luns for my SQL  2005 server. Within the next week I will be using Snapdrive to carve out  LUNs for use on the new  SQL server. This brings up a few questions:

1.   - The  new server will be running Microsoft Windows Server 2008 R2 with SQL  2008 R2 installed on it. In the past I carved out 100GB volumes with  snap reserve set at 0%. The  resulting LUN ends up being 50GB or half the size of the volume. Has  best practice here changed at all?

2.   - Right  now the GA release of Snapdrive is 6.1.1 with two First Customer  Shipments, 6.2 and 6.3. Given the operating system and version of SQL,  which version of Snapdrive should  I install?

3.  - Likewise there is a GA release of Snapmanager for SQL (5.0R1) and a First Customer Shipment of 5.1. Which one should I install?

Our  FAS3020 is running OnTap 7.3.2. The current GD release is 7.3.3 and GA  release is 7.3.4. I do not know if it is necessary to update OnTap for  this endeavor.

1 REPLY 1

dnewtontmw

The release notes (or tech support) is probably the best place to look for this info.

For what it's worth... we're running SnapDrive 6.2 and SnapMgr SQL 5.0, on a Win 2008 R2 x64 server with SQL Server 2008 SP1.

I can't say we've been thrilled about the stability of this setup.  We get random issues (typically timeouts attempting to mount up a cloned db) once every 6-8 weeks.

Announcements
Register for Insight 2021 Digital

INSIGHT 2021 Digital: Meet the Specialists 2

On October 20-22, gear up for a fully digital, totally immersive virtual experience with a downright legendary lineup of world-renowned specialists. Tune in for visionary conversations, solution deep dives, technical sessions and more.

NetApp on Discord Image

We're on Discord, are you?

Live Chat, Watch Parties, and More!

Explore Banner

Meet Explore, NetApp’s digital sales platform

Engage digitally throughout the sales process, from product discovery to configuration, and handle all your post-purchase needs.

NetApp Insights to Action
I2A Banner
Public