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.