Hi,
We're just setting up a new SQL server with a SMSQL backup job and we're seeing the following DBCC errors. The SM SQL job has been re-installed and the job setup again as per other servers (ie its the first time we've seen the error). There is also an initiator error but we're not sure why thats listed as an issue - it through the initiator and that IP that the SAN lun's are connected in the first place -
[09:22:04.916] *** VERIFY DATABASE AFTER BACKUP
09:22:04.916] Collecting verification information... [09:22:04.916] Getting database backup information from SnapInfo file... [09:22:04.916] Running verification from local server.... [09:22:04.931] Mounting Snapshot [sqlsnap__server-sql1__recent] for Virtual Disk F of Computer server-sql1 [09:22:05.322] WARNING: Unable to get default mount point directory [09:22:05.322] Snapshot will be mounted on subdirectory [MPDisk001] [09:22:05.681] [SnapDrive Error]: There are no initiators connected to the filer "10.1.46.1".
(SnapDrive Error Code: 0xc00402e6)
[09:22:05.697] Error Code: 0xc00408f0 There are no initiators connected to the filer from verification server. Please check SnapManager report and Event logs for details.
Any ideas ?
Thanks in advance, Raj.
Hi
Is it possible to delete a limited set of files from all snapshots without having to delete every snapshot in which those files appear? If the official line is, "No", is there an unapproved way of doing this?
Thanks
Francois
Hi
Is it possible to delete a limited set of files from all snapshots without having to delete every snapshot in which those files appear? If the official line is, "No", is there an unapproved way of doing this?
The only way I can think to do it is this:
1) create a new volume
2) copy over the snapshots of the old volume to the new volume one at a time with ndmpcopy. Start with a full copy of the oldest snapshot and then do incremental copies from second oldest to newest of the remaining snapshots.
3) after copying each snapshot, remove the unwanted file from the new volume and create a snapshot on the new volume.
When you are done the new volume will have (essentially) the same set of snapshots, but with the unwanted file deleted.
Probably not worth the trouble.
Steve Losen scl@virginia.edu phone: 434-924-0640
University of Virginia ITC Unix Support
Sincerely...why? :-)
-----Messaggio originale----- Da: owner-toasters@mathworks.com [mailto:owner-toasters@mathworks.com] Per conto di Francois Joubert Inviato: giovedì 26 giugno 2008 17.01 A: NetApp Toasters List Oggetto: Deleting files from snapshots
Hi
Is it possible to delete a limited set of files from all snapshots without having to delete every snapshot in which those files appear? If the official line is, "No", is there an unapproved way of doing this?
Thanks
Francois
Do you use tape backups? Would the software vendor require you to remove it from there too? If not, the same could reasonably be said for snapshots as they are part of your backup. You could recover the software from tape as well, correct?
-- Adam Fox adamfox@netapp.com
-----Original Message----- From: Francois Joubert [mailto:francois.joubert@imagination.com] Sent: Friday, June 27, 2008 4:28 AM To: Milazzo Giacomo Cc: NetApp Toasters List Subject: Re: R: Deleting files from snapshots
Hi
Nothing sinister - we cancelled some software contract and we need to delete all copies of it. Unfortunately, a copy has been stored on one of
the filers.
Francois
Milazzo Giacomo wrote:
Sincerely...why? :-)
Never mind...saw your response on that. :) But I suppose the vendor should have some policy around not easily deletable backups as SOME of their customers may still be using tape.
-- Adam Fox adamfox@netapp.com
-----Original Message----- From: Fox, Adam Sent: Friday, June 27, 2008 11:18 AM To: francois.joubert@imagination.com; Milazzo Giacomo Cc: NetApp Toasters List Subject: RE: R: Deleting files from snapshots
Do you use tape backups? Would the software vendor require you to remove it from there too? If not, the same could reasonably be said for snapshots as they are part of your backup. You could recover the software from tape as well, correct?
-- Adam Fox adamfox@netapp.com
-----Original Message----- From: Francois Joubert [mailto:francois.joubert@imagination.com] Sent: Friday, June 27, 2008 4:28 AM To: Milazzo Giacomo Cc: NetApp Toasters List Subject: Re: R: Deleting files from snapshots
Hi
Nothing sinister - we cancelled some software contract and we need to delete all copies of it. Unfortunately, a copy has been stored on one of
the filers.
Francois
Milazzo Giacomo wrote:
Sincerely...why? :-)
-
Fox, Adam -
Francois Joubert -
Milazzo Giacomo -
Raj Patel -
Stephen C. Losen