{"id":320,"date":"2009-06-26T00:24:25","date_gmt":"2009-06-26T00:24:25","guid":{"rendered":"http:\/\/blog.cyberwizzard.nl\/?p=320"},"modified":"2016-03-20T15:40:30","modified_gmt":"2016-03-20T14:40:30","slug":"restoring-exchange-20032008-using-bacula","status":"publish","type":"post","link":"https:\/\/blog.cyberwizzard.nl\/?p=320","title":{"rendered":"Restoring Exchange 2003\/2008 using Bacula"},"content":{"rendered":"

Because the instructions in the Bacula documentation left me hanging on how to actually restore the Exchange data from a backup, I am writing this little summary after extracting all information from the mailing lists.<\/p>\n

In my case, I have one server called ‘axmail-fd’ running Exchange 2003 and another server called ‘axemail-fd’ running Exchange 2003 SP2. The following steps are needed to restore into the Recovery Storage Group on the new server in order to migrate the mail from the old to the new server.<\/p>\n

To prepare, please create the Recovery Storage Group on the target Exchange server. Create the database name you want to recover, for example “Mailbox Store (AXMAIL)”, which will generate a “Mailbox Store (AXMAIL).edb” in the Recovery Storage Group folder. Clear out any log files or other remnants of previous restores as Exchange tends to get confused if data from multiple databases are in there.<\/p>\n

Start bconsole, select the restore mode and select the Exchange backup to restore:<\/p>\n

*<\/span>restore\nFirst you select<\/span> one or more<\/span> JobIds that contain files to be restored. \nYou will be presented several methods of specifying the JobIds. Then \nyou will be allowed to select<\/span> which<\/span> files from those JobIds are to be restored.\nTo select<\/span> the JobIds, you have the following choices:     \n1<\/span>: List last<\/span> 20<\/span> Jobs run                             \n2<\/span>: List Jobs where a given File is saved             \n3<\/span>: Enter list of comma separated JobIds to select<\/span>    \n4<\/span>: Enter SQL list command<\/span>                            \n5<\/span>: Select the most recent backup for<\/span> a client        \n6<\/span>: Select backup for<\/span> a client before a specified time<\/span>     \n7<\/span>: Enter a list of files to restore                       \n8<\/span>: Enter a list of files to restore before a specified time<\/span>     \n9<\/span>: Find the JobIds of the most recent backup for<\/span> a client      \n10<\/span>: Find the JobIds for<\/span> a backup for<\/span> a client before a specified time<\/span>    \n11<\/span>: Enter a list of directories to restore for<\/span> found JobIds              \n12<\/span>: Cancel                                                           \nSelect item:  (<\/span>1<\/span>-12<\/span>)<\/span>: 5<\/span>                                                 \n Defined Clients:                                                              \n...     \n4<\/span>: axmail-fd     \n...    \n10<\/span>: axemail-fd\nSelect the Client (<\/span>1<\/span>-10<\/span>)<\/span>: 4<\/span>\n\nThe defined FileSet resources are:\n1<\/span>: AXMAIL Full Data Set\n2<\/span>: Exchange\nSelect FileSet resource (<\/span>1<\/span>-2<\/span>)<\/span>: 2<\/span>\n+-------+-------+----------+---------------+---------------------+-------------------------------+\n|<\/span> JobId |<\/span> Level |<\/span> JobFiles |<\/span> JobBytes      |<\/span> StartTime           |<\/span> VolumeName                    |<\/span>\n+-------+-------+----------+---------------+---------------------+-------------------------------+\n|<\/span>    90<\/span> |<\/span> F     |<\/span>       13<\/span> |<\/span> 5<\/span>,313<\/span>,968<\/span>,371<\/span> |<\/span> 2009<\/span>-06-24<\/span> 15<\/span>:36<\/span>:10<\/span> |<\/span> Deventer_Exchange_Backup_0013 |<\/span>\n|<\/span>    90<\/span> |<\/span> F     |<\/span>       13<\/span> |<\/span> 5<\/span>,313<\/span>,968<\/span>,371<\/span> |<\/span> 2009<\/span>-06-24<\/span> 15<\/span>:36<\/span>:10<\/span> |<\/span> Deventer_Exchange_Backup_0014 |<\/span>\n|<\/span>    91<\/span> |<\/span> I     |<\/span>        5<\/span> |<\/span>     2<\/span>,671<\/span>,174<\/span> |<\/span> 2009<\/span>-06-24<\/span> 17<\/span>:28<\/span>:25<\/span> |<\/span> Deventer_Exchange_Backup_0014 |<\/span>\n|<\/span>    92<\/span> |<\/span> I     |<\/span>        5<\/span> |<\/span>       233<\/span>,882<\/span> |<\/span> 2009<\/span>-06-24<\/span> 18<\/span>:00:01 |<\/span> Deventer_Exchange_Backup_0014 |<\/span>\n|<\/span>   118<\/span> |<\/span> I     |<\/span>       17<\/span> |<\/span>    40<\/span>,099,025 |<\/span> 2009<\/span>-06-25<\/span> 18<\/span>:00:02 |<\/span> Deventer_Exchange_Backup_0014 |<\/span>\n+-------+-------+----------+---------------+---------------------+-------------------------------+\n\nYou have selected the following JobIds: 90<\/span>,91<\/span>,92<\/span>,118<\/span>\nBuilding directory tree<\/span> for<\/span> JobId(<\/span>s)<\/span> 90<\/span>,91<\/span>,92<\/span>,118<\/span> ...\n24<\/span> files inserted into the tree.<\/pre>\n
Now we want to select the entire First Storage Group to restore, except for the Public Folders store.<\/p>\n
Note: If you have the mailbox store defined, perhaps the restoration will work. An old mailing list conversation in 2008 stated that it was only possible to restore one database at a time – hence we now unmark the Public Folder.<\/p>\n
You are now entering file<\/span> selection mode where you add (<\/span>mark)<\/span> and\nremove (<\/span>unmark)<\/span> files to be restored. No files are initially added, unless\nyou used the "all"<\/span> keyword on the command<\/span> line.                           \nEnter "done"<\/span> to leave this mode.                                          \ncwd is: \/<\/span>$ mark *<\/span>                                       \n29<\/span> files marked.                               \n$ cd<\/span> "@EXCHANGE\/Microsoft Information Store\/First Storage Group"<\/span>\ncwd is: \/@<\/span>EXCHANGE\/<\/span>Microsoft Information Store\/<\/span>First Storage Group\/<\/span>\n$ unmark Public*<\/span>                                                   \n4<\/span> files unmarked.                                                  \n$ lsmark                                                           \n*<\/span>C:\\Program Files\\Exchsrvr\\mdbdata\\E0002FC5.log                    \n*<\/span>C:\\Program Files\\Exchsrvr\\mdbdata\\E0002FC6.log                    \n*<\/span>C:\\Program Files\\Exchsrvr\\mdbdata\\E0002FC7.log                    \n*<\/span>C:\\Program Files\\Exchsrvr\\mdbdata\\E0002FC8.log                    \n*<\/span>C:\\Program Files\\Exchsrvr\\mdbdata\\E0002FC9.log                    \n*<\/span>C:\\Program Files\\Exchsrvr\\mdbdata\\E0002FCA.log                    \n*<\/span>C:\\Program Files\\Exchsrvr\\mdbdata\\E0002FCB.log                    \n*<\/span>C:\\Program Files\\Exchsrvr\\mdbdata\\E0002FCC.log                    \n*<\/span>C:\\Program Files\\Exchsrvr\\mdbdata\\E0002FCD.log                    \n*<\/span>C:\\Program Files\\Exchsrvr\\mdbdata\\E0002FCE.log                    \n*<\/span>C:\\Program Files\\Exchsrvr\\mdbdata\\E0002FCF.log                    \n*<\/span>C:\\Program Files\\Exchsrvr\\mdbdata\\E0002FD0.log                    \n*<\/span>C:\\Program Files\\Exchsrvr\\mdbdata\\E0002FD1.log                    \n*<\/span>C:\\Program Files\\Exchsrvr\\mdbdata\\E0002FD2.log                    \n*<\/span>C:\\Program Files\\Exchsrvr\\mdbdata\\E0002FD3.log                    \n*<\/span>C:\\Program Files\\Exchsrvr\\mdbdata\\E0002FD4.log                    \n*<\/span>C:\\Program Files\\Exchsrvr\\mdbdata\\E0002FD5.log                    \n*<\/span>C:\\Program Files\\Exchsrvr\\mdbdata\\E0002FD6.log                    \n*<\/span>Mailbox Store (<\/span>AXMAIL)<\/span>\/<\/span>                                           \n*<\/span>C:\\Program Files\\Exchsrvr\\mdbdata\\priv1.edb                       \n*<\/span>C:\\Program Files\\Exchsrvr\\mdbdata\\priv1.stm                       \n*<\/span>DatabaseBackupInfo                                                \n$ done<\/span>\n\nBootstrap records written to \/<\/span>var\/<\/span>bacula\/<\/span>axnet-dir.restore.23.bsr  \nThe job will require the following   \nVolume(<\/span>s)<\/span>                 Storage(<\/span>s)<\/span>                SD Device(<\/span>s)<\/span>\n===========================================================================\nDeventer_Exchange_Backup_ File                      FileStorage\n\n25<\/span> files selected to be restored.\n\nRun Restore job\nJobName:         RestoreFiles\nBootstrap:       \/<\/span>var\/<\/span>bacula\/<\/span>axnet-dir.restore.23.bsr\nWhere:           \/<\/span>tmp\/<\/span>bacula-restores\nReplace:         always\nFileSet:         Empty FileSet\nBackup Client:   axmail-fd\nRestore Client:  axmail-fd\nStorage:         File\nWhen:            2009<\/span>-06-26<\/span> 00:44<\/span>:50<\/span>\nCatalog:         MyCatalog\nPriority:        10<\/span>\nPlugin Options:  *<\/span>None*<\/span><\/pre>\n
We now need to change the target to the new server and clear out the Where setting:<\/p>\n
OK to run? (<\/span>yes\/<\/span>mod\/<\/span>no)<\/span>: m\nParameters to modify:    \n1<\/span>: Level    \n2<\/span>: Storage    \n3<\/span>: Job    \n4<\/span>: FileSet    \n5<\/span>: Restore Client    \n6<\/span>: When    \n7<\/span>: Priority    \n8<\/span>: Bootstrap    \n9<\/span>: Where   \n10<\/span>: File Relocation   \n11<\/span>: Replace   \n12<\/span>: JobId   \n13<\/span>: Plugin Options\nSelect parameter to modify (<\/span>1<\/span>-13<\/span>)<\/span>: 5<\/span>                \n\nThe defined Client resources are:    \n1<\/span>: bartje-fd    \n2<\/span>: nakor-fd    \n3<\/span>: hermione-fd\n4<\/span>: snape-fd\n5<\/span>: hagrid-fd\n6<\/span>: axnet-fd\n7<\/span>: axweb-fd\n8<\/span>: axmail-fd\n9<\/span>: axexact-fd\n10<\/span>: axklant-fd\n11<\/span>: axemail-fd\nSelect Client (<\/span>File daemon)<\/span> resource (<\/span>1<\/span>-11<\/span>)<\/span>: 11<\/span>\n\nRun Restore job\nJobName:         RestoreFiles\nBootstrap:       \/<\/span>var\/<\/span>bacula\/<\/span>axnet-dir.restore.23.bsr\nWhere:           \/<\/span>tmp\/<\/span>bacula-restores\nReplace:         always\nFileSet:         Empty FileSet\nBackup Client:   axmail-fd\nRestore Client:  axemail-fd\nStorage:         File\nWhen:            2009<\/span>-06-26<\/span> 00:44<\/span>:50<\/span>\nCatalog:         MyCatalog\nPriority:        10<\/span>\nPlugin Options:  *<\/span>None*<\/span>\nOK to run? (<\/span>yes\/<\/span>mod\/<\/span>no)<\/span>: m\n\nParameters to modify:    \n1<\/span>: Level    \n2<\/span>: Storage    \n3<\/span>: Job    \n4<\/span>: FileSet    \n5<\/span>: Restore Client    \n6<\/span>: When    \n7<\/span>: Priority    \n8<\/span>: Bootstrap    \n9<\/span>: Where   \n10<\/span>: File Relocation   \n11<\/span>: Replace   \n12<\/span>: JobId   \n13<\/span>: Plugin Options\nSelect parameter to modify (<\/span>1<\/span>-13<\/span>)<\/span>: 9<\/span>\nPlease enter path prefix for<\/span> restore (<\/span>\/<\/span> for<\/span> none)<\/span>: \/<\/span>\n\nRun Restore job\nJobName:         RestoreFiles\nBootstrap:       \/<\/span>var\/<\/span>bacula\/<\/span>axnet-dir.restore.23.bsr\nWhere:\nReplace:         always\nFileSet:         Empty FileSet\nBackup Client:   axmail-fd\nRestore Client:  axemail-fd\nStorage:         File\nWhen:            2009<\/span>-06-26<\/span> 00:44<\/span>:50<\/span>\nCatalog:         MyCatalog\nPriority:        10<\/span>\nPlugin Options:  *<\/span>None*<\/span>\nOK to run? (<\/span>yes\/<\/span>mod\/<\/span>no)<\/span>: y\n\nJob queued. JobId<\/span>=132<\/span>\nYou have messages.<\/pre>\n
Notice how we did not use any renaming on the database paths: if Exchange 2003 has a Recovery Storage Group defined, that group will receive any restores, making manual adjustment of the paths unneeded.<\/p>\n
Troubleshooting ∞<\/a><\/h2>\n
Error 0x7fe1f42 ∞<\/a><\/h3>\n
If you get this error: “Error: HrESERestoreAddDatabase failed with error 0xc7fe1f42 – Database not found. Check that the Database you are trying to restore actually exists in the Storage Group you are restoring to”. You have not created the database in the Exchange manager in the Recovery Storage Group. Make sure you created the database in the manager and check the name.<\/p>\n
Error 0xc7ff1004 ∞<\/a><\/h3>\n
I ran into this message after figuring out how to restore the data: “Error: HrESERestoreComplete failed with error 0xc7ff1004 – Unknown error”. The error is given by the FD after the data has been restored and the FD crashed after that.<\/p>\n
You can run the eseutil.exe against the .edb file to check the state (use eseutil \/mh filename.edb<\/code>) and you will probably see the state as “Dirty Shutdown”.<\/p>\n
The cause is a problem during the backup and is making the restore fail. If you have all the log files (E00xxxx.log in ‘restore’ in the Recovery Storage Group folder) you can use the eseutil \/cc restore<\/code> command to replay the log files and fix the database.<\/p>\n
After replaying the logs, the database should mount fine and all the mail should be there.<\/p>\n","protected":false},"excerpt":{"rendered":"
Because the instructions in the Bacula documentation left me hanging on how to actually restore the Exchange data from a backup, I am writing this little summary after extracting all information from the mailing lists. In my case, I have one server called ‘axmail-fd’ running Exchange 2003 and another server called ‘axemail-fd’ running Exchange 2003 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[368,369],"class_list":["post-320","post","type-post","status-publish","format-standard","hentry","category-linux-gentoolinux","tag-bacula","tag-exchange"],"views":1422,"_links":{"self":[{"href":"https:\/\/blog.cyberwizzard.nl\/index.php?rest_route=\/wp\/v2\/posts\/320","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.cyberwizzard.nl\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.cyberwizzard.nl\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.cyberwizzard.nl\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.cyberwizzard.nl\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=320"}],"version-history":[{"count":3,"href":"https:\/\/blog.cyberwizzard.nl\/index.php?rest_route=\/wp\/v2\/posts\/320\/revisions"}],"predecessor-version":[{"id":579,"href":"https:\/\/blog.cyberwizzard.nl\/index.php?rest_route=\/wp\/v2\/posts\/320\/revisions\/579"}],"wp:attachment":[{"href":"https:\/\/blog.cyberwizzard.nl\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=320"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.cyberwizzard.nl\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=320"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.cyberwizzard.nl\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=320"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}