Hi all,
Up to now I've always set up SQL cluster with LUNs on drive letters and I've used a single stand alone SQL instance on the "passive" node of the cluster as verification server.
Sincerely this is my first experience of SMSQL on a MS cluster using mount point and an external verification server. The scenario so is a SQL cluster using mount point instead of drive letters and an external verification server. We have the DB files on a LUN mounted as S:\DB01, the logs on another LUN mounted as S:\LOG01 and GLINKA0 as external verification server. Here follows the log.
The backup is successfully done but when the verification starts something goes wrong: the snapshotted LUNs for DB and LOG are successfully mounted on Z: and Y: but SMSQL on verification does not find the db files a/o the log files looking for it on S:\DB01 (that is the path of the mount point!)...
I hope this has nothing to do with capital or lowercase usage of paths J (we've S:\DB01 and S:\db01 on log...).
From the verification server I can see the LUN mounted, I can browse them while are mounted and I can see the 'not found' files...
Any idea?
Thank you in advance,
[09:28:45.992] *** VERIFY DATABASE AFTER BACKUP
[09:28:45.992] Collecting verification information...
[09:28:45.992] Getting database backup information from SnapInfo file...
[09:28:45.992] Initializing SnapManager server on remote machine [GLINKA0]...
[09:28:46.602] Mounting Snapshot [sqlsnap__amen01__recent] for Virtual Disk S:\DB01\ of Computer amen01
[09:29:15.180] This Snapshot is mounted as the drive [Z:].
[09:29:15.180] Mount Snapshot succeeded.
[09:29:15.180] Mounting Snapshot [sqlsnap__amen01__recent] for Virtual Disk S:\LOG01\ of Computer amen01
[09:30:08.664] This Snapshot is mounted as the drive [Y:].
[09:30:08.664] Mount Snapshot succeeded.
[09:30:08.664] Cannot find the data file in the mounted drive:
[09:30:08.664] S:\db01\ale2.mdf
[09:30:08.664] Dismounting Virtual Disk Z of SnapShot [sqlsnap__amen01__recent]...
[09:30:25.429] Dismount Snapshot succeeded.
[09:30:25.429] Dismounting Virtual Disk Y of SnapShot [sqlsnap__amen01__recent]...
[09:30:31.476] Dismount Snapshot succeeded.
[09:30:31.492] Unable to locate the database data file on the mounted disk drive.
[09:30:31.492] Database verification information was not updated.
[09:30:31.507] There is an error during database verification.
[09:30:31.507]
[09:30:31.507] **** FULL DATABASE BACKUP RESULT SUMMARY #1 ****
[09:30:31.507] Backup Time: 11-06-2008_09.28.12
[09:30:31.507] Backup Group [#1]:
[09:30:31.507] #1 : [amen01\amen01 - ale2] : Failed with error code 0xc0040814.
[09:30:31.507] #1 : [amen01\amen01 - ale2] Error : Backup OK, but DBCC Skipped.
[09:30:31.507] #2 : [amen01\amen01 - ale3] : Failed with error code 0xc0040814.
[09:30:31.507] #2 : [amen01\amen01 - ale3] Error : Backup OK, but DBCC Skipped.
[09:30:31.507] #3 : [amen01\amen01 - db4] : Failed with error code 0xc0040814.
[09:30:31.507] #3 : [amen01\amen01 - db4] Error : Backup OK, but DBCC Skipped.
[09:30:31.507]
[09:30:31.507] *** SNAPMANAGER BACKUP JOB ENDED AT: [11-06-2008 09.30.31]
[09:30:31.507] Unable to locate the database data file on the mounted disk drive.