There is a lively discussion about SMVI and backing up VMs with iSCSI Luns and the use of Snapmanager products. I have a similare question now that Snapmanager for SQL can take snapshots where the SQL databases and logs are stored on NFS shares. I have:
- SQL 2008 64 bit, Snapdrive 6.3, and Snapmanager for SQL 5.1. The SQL Server has a C: drive where of course Windows and SQL are installed and this is all stored on an NFS data share. Instead of using iSCSI luns to store the SQL databases and logs, I just added for more drives to my SQL server, each from 4 separate NFS shares:
E: User databases
U: System databases
- Virtual Center runs on it own server and has VSC 2.0.1 installed
Snapmanager for SQL is working fine to backup the system and user databases. My question is how do I backup the SQL server (C: drive)? I have two choices:
1. Make an SMVI backup job that includes the SQL server. DO NOT include the 4 separate NFS datastores noted above, only include the NFS share that houses the C: drive. DO NOT check the checkbox to make a VMWare consistency snapshot first
2. The same as number 1 above, but this time check the box to make a VMWare consistency snapshot first
So far I am using choice 1. Should I be using choice 2 instead? If I am taking a VMWare snapshot of the C: drive, NOT the drives that contain the actual SQL databases, will I will run into problems? My old SQL server setup used iSCSI luns and the only choice was to NOT take a VMWare snapshot.
I tried to take a VMWare snapshot of my SQL 2008 Server before taking the filer snapshot and could not get it to work. It kept timing out. I know that this will happen with iSCSI luns attached but I guess it also happens if the SQL databases and logs are stores on NFS shares
Yes, I am using all three of these components and my SQL server is running fine. Snapmanager for SQL is working fine and I am getting backups of my System and User databases. The problem comes when I attempt to backup the SQL server itself, in essence the C drive. I have two backup jobs setup using Backup and Recovery in VSC 2.0.1. One job take a VMWare snapshot before the filer snapshot and one does not. I have my Exchange Server in the job without the VMWare snapshot since it has iSCSI luns via Microsoft's iSCSI initiator. I have my old SQL server in this same job since it also has iSCSI luns.
I put my new SQL server in the job that does take a VMWare snapshot first. I am only including the datastore that contains the SQL server (C: drive) and not the datastores that contains my SQL database and log file. When this job runs and attempts to take the VMWare snapshot of this SQL server it times out and never does the snapshot.
My SQL database backup just fine. What is not backing up properly is the C drive of the SQL server where Windows is isntalled along with SQL server itself. This I am backing up using SMVI (which is built into vsc 2.0.1). When I try taking a VMWare Snapshot (VMWare Consistency checkbox checked) of the SQL server (C: drive) it times out.