Wayne Humphrey's blog

1. Stop all Enterprise Vault services besides the Vault Admin and Directory
2. Detach the databases from within SQL.
3. Copy the databases to the new SQL Server.
4. Attach the databases from within SQL on the new SQL server.

Leslie & I very early morning with no one else in site.  Peter made her get up early 8 AM and its now 9:15 and since then we have not seen one person, they all still sleeping :(

P.S. Peter why does Leslie have to work so early?

So here is a SQL script to work out the hourly archiving rate, for the past 24 hours .

You will need to define all the Vault Stores in this query.

To combibe all the SISParts and stuff you can use the following hta script to use the ECM APT to do :

Save it as get_item.hta

• Mailbox Name
• Exchange Server
• Number of Items (Mailbox) 
• Number of (Archive)
• Mailbox Size (MB) 
• Archive Size (MB)
• Total Size (MB) 
• Archive Created

This SQL Script will get all List of all Archives and dispaly the following:

• Mailbox Name
• Exchange Server
• Number of Items (Mailbox) 
• Number of (Archive)
• Mailbox Size (MB) 
• Archive Size (MB)
• Total Size (MB) 
• Archive Created
• Archive Updated

The Archiving State translates as follows:

0 = Not Enabled
1 = Enabled
2 = Disabled
3 = Re-Link

To view the Archiving State you can use the following:

Lots of times I refer back to the EV manuals to see whether something that I “discover” is actually documented.  I have a copy locally on my machine in the office of many of the manuals, from many of the different versions.  I had often wondered about an externalised version of them, and whether they were easy to find.

With the power of Google, I found :

I always get asked about MSMQ, here is a short note on things to look at if you have MSMQ issue's, even if you don't have issues you can always benefit from tweaking MSMQ and enhance Enterprise Vault’s performance.

Microsoft Message Queuing (MSMQ)