deleting Vault store from SQL
Hi,
i want to delete 1 vault store from EV VAC.
after delete operation it says that deletion marked,it is ok normal prosedure but there is too small data in there 2 weeks passed and still in same point.
Also there are many errors in event logs,in every seconds it generetes manty erorr.EV services are down for this reason.
13360 and 6796 errors.
how can i delete this vault store from sql?
delete partition entry and vault store?(data is still using maybe sql angry to delete this data?)
----------------------------------------------------------------------
11/11/2011,4:19:17 PM,Enterprise Vault ,Error,Storage Archive ,13360,N/A,ASPVAULT,"An error was detected while accessing the Vault Database 'EVvs' (Internal reference: .\ADODataAccess.cpp (CADODataAccess::ExecuteSQLCommand) [lines {1392,1394,1409,1427}] built Oct 6 11:22:46 2010):
Could not find stored procedure 'uspi_Saveset'.
SQL Command:
uspi_Saveset
Native Error: 00002812
11/11/2011,4:19:17 PM,Enterprise Vault ,Error,Storage Archive ,6796,N/A,EVPVAULT,"A COM exception has been raised.
Comments
Hi K.G,What kind of Vault
Hi K.G,
What kind of Vault Store is it that you are trying to delete? i.e. Exchange mailbox, Public Folder or FSA etc.? Do you have any active archives stored on this vault store?
What kind of storage is the vault store partition stored on? Is Ev service the DBOwner of that Vault Store database?
hi,
there are 5 users in this vault store and all of the disabled state.
exchange mbx store.
normal san device is storage ,there is no resterection on deletion.
i would suggest you dtrace
i would suggest you dtrace storagedelete and restart the storage service to hopefully give some visibility into what's going on. you can post the logs here as an attachment for us to review.
Andy Becker | Authorized Symantec Consultant | Trace3 | Symantec National Partner | www.trace3.com
Enable dtrace as AndrewB
Enable dtrace as AndrewB suggested and also enable SQL Server Profiler trace and attach that too.
same lines occured many times
in dtrace there are many same errors;
Retention time?
Hi KG,
regardless of the errors.
It's possible that the Users has still archives in the system incl. archived elements which couldn't delete before the retention period is over.
PMCS.helpLine Software Gruppe
www.pmcs.de
Twitter: https://twitter.com/PMCS_EV
are you sure you set the
are you sure you set the dtrace to storagedelete?
Andy Becker | Authorized Symantec Consultant | Trace3 | Symantec National Partner | www.trace3.com
So USPI_Saveset is a stored
So USPI_Saveset is a stored procedure that performs inserts and so this SP is not called as part of deleting an archive. What would be called is USPD_Saveset.
So probably you are getting errors in uspi_saveset as this is trying to add savesets to another archive but cannot for whatever reason. This maybe down to blocking in SQL or something along those lines.
I would take a look and see if you have any blocking occuring on your SQL.
Did you have any archives residing in the Vault Store before you tried deleting the vault store or did you have an Empty VS and you are just trying to delete that?
EV Backline Technical Support Engineer APJ Region
Based on your Dtrace It loos
Based on your Dtrace It loos like you may have deleted the database called 'EVVS' - is that correct? If so that would explain why the USPI_Saveset stored procedure is missing. Is there an exchange archving task for those mailboxes that existed in the deleted vault store? If so then stop the task as it may still be trying to archive items into that VS.
A Stored Procedure called DeleteVaultStore exists under the Directory Database / Programmability section. This SP will show you the tables that record the various settings that relate to a Vault Store.
Would you like to reply?
Login or Register to post your comment.