We are having issues with our snapmanager for sharepoint backups, and the issue seems to be on the sql server. The sql server is a virtual machine and we use nfs, so the vmdk files of the VM are seen on snapdrive. The snapshots which are created by snapmanager for sql, are not being displayed on snapdrive on the sql server, if i expand on the volumes where the vmdk's are. If i go to the filer, i can see the list of snapshots on that volume. I can only see snapshots on snapdrive which i created via snapdrive, not any snapshots which are created on the filer. Any reason why this is. I think this is impacting the snapmanager for sharepoint backups.
I have checked access and accounts on the filer and it all seems fine. It was working before and could see all snapshots in snapdrive but not now.
You must keep in mind some restrictions for creating Snapshot copies.
• You can keep a maximum of 255 Snapshot copies with Data ONTAP. After the number of Snapshot copies has reached the limit, the Snapshot Create operation fails, and you must delete some of the old Snapshot copies before you can create any more.
• SnapDrive does not support Snapshot copies that are created from the storage system console, because such a practice can lead to inconsistencies within the NTFS file system. Therefore, use
only SnapDrive to create Snapshot copies of LUNs.
• You cannot create a Snapshot copy of a LUN connected to a Snapshot copy.
• SnapDrive automatically turns off the Snapshot copy schedule on a storage system volume that stores LUNs, so that the storage system does not create automatic Snapshot copies.
Note: Any Snapshot copies inadvertently made at the storage system console, or through System Manager or FilerView are dimmed (unavailable) in the SnapDrive MMC plug-in and are not usable by SnapDrive.
Is there any particular reason why you need to see these snapshots from SnapDrive?
I have another sql server with the same versions, and they are able to see the snapshots created by snapmanager for sql, but this specific server i cannot see, but only snapshots created via snapdrive. I think its the reason why my backups and restores via snapmanager for sharepoint are not working correctly.
I tried creating a snapshot on the cli, and still wasnt able to see the snapshots via snapdrive.
I had a similar issue, with a similar setup. What ended up working for me was to change the backup naming convention from Use Generic (_recent) to use Unique (time stamp). I believe it has something to do with trying to take SQL snapshots in a VM running SQL where the Datastore is NFS. If I move this machine to a VMDK data store then I have no issues.