The Exclaimer Community

SYMPTOMS

You would like to move the Archiver's database files to a new location or a new server.

RESOLUTION

These instructions carry true for MSSQL 2000 and MSSQL 2005 including Express. For further information on using the detach and attach feature of SQL, please refer to the following Microsoft KB article:

http://support.microsoft.com/kb/224071

The database set is referenced as "Exclaimer Email Archive" with database names of "Exclaimer Email Archive1" and "Exclaimer Email ArchiveConfig" for the purpose of these steps.

1. Open the Services console on the server where the Archiver is installed. Locate and stop the Exclaimer Email Archiver Service.
2. Open SQL Management Studio (or Enterprise manager for 2000), expand "Databases" and right click on the "Exclaimer Email Archive1" database and select "All tasks" followed by "Detach" This will take the database out of the database engine
3. Locate the database files (by default this location will be C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data in MSSQL 2005) and move the following files to the new location:
   
   
   • Exclaimer Email Archive1.MDF
   • Exclaimer Email ArchiveConfig.MDF
   • Exclaimer Email Archive1.LDF
   • Exclaimer Email ArchiveConfig.LDF

   Please note that if you have the roll over set you will have more numbered databases (For example Archive2, Archive3 etc). Please ensure you detach and move all the databases for the Exclaimer Email Archiver.
   
   

4. In the SQL Management Studio (or Enterprise manager for 2000) Browse to the "Database" folder and then right click and select "Attach"
5. In the dialogue box select the database files from the new location.
   
   IMPORTANT - You must change the database owner in order for the Archiver to write to the reattached database. Please follow the steps below.
   
6. In MSSQL 2000 at the bottom there is a drop down box for the owner, please select Exclaimer Archiver Service (or the account that the archiver service is running under).
7. For MSSQL 2005 and Express attach the database, right click on the database and select properties. Then from the properties window click on "Files" from the "Select a page" menu, then in the right window click the browse button and select the Exclaimer Archiver Service (or the account that the archiver service is running under).
8. Open the Services console on the server where the Archiver is installed. Locate and start the Exclaimer Email Archiver Service.

APPLIES TO

All versions of Exclaimer Email Archiver

---

Joshua Clarke
Exclaimer Support