Ask the Community
Groups
What are the options and guidelines for backing up SQL, Exchange? - Connect IT Community | Kaseya
<main> <article class="userContent"> <p><strong>Question:</strong></p> <p> What are the options and guidelines for backing up SQL, Exchange, and/or AD-based data with BUDR?</p> <p> </p> <p> </p> <p><strong>Answer:</strong></p> <p> </p> <p>There are two options for backing up SQL, Exchange, and AD data as noted below:</p> <p>Option 1 - Pre/Post Script Procedures</p> <p>First, you can use pre/post scripts, as defined & supplied in these KB articles and links:</p> <p>Exchange & SQL – <a rel="nofollow" href="/home/leaving?allowTrusted=1&target=https%3A%2F%2Fkaseya.zendesk.com%2Fentries%2F33908328-Perform-a-backup-of-SQL-MS-Exchange-using-BUDR-Pre-Post-Procedures">http://community.kaseya.com/kb/w/wiki/perform-a-backup-of-ms-exchange-using-budr-pre-post-procedures.aspx</a></p> <p>Active Directory - <a rel="nofollow" href="/home/leaving?allowTrusted=1&target=https%3A%2F%2Fkaseya.zendesk.com%2Fentries%2F33882897-Ensure-a-good-backup-of-an-Active-Directory-domain-controller">http://community.kaseya.com/kb/w/wiki/ensure-a-good-backup-of-an-active-directory-domain-controller.aspx</a></p> <p>A set of Pre/Post script samples are found here:</p> <p><a href="/home/leaving?allowTrusted=1&target=http%3A%2F%2Fdl.kaseya.com%2Fsupport%2Fbudr%2Fscripts%2FPrePostScripts.zip">http://dl.kaseya.com/support/budr/scripts/PrePostScripts.zip</a></p> <p>This help file describes this as well:</p> <p><a href="/home/leaving?allowTrusted=1&target=http%3A%2F%2Fhelp.kaseya.com%2FWebHelp%2Fen-US%2Fbudr%2F3010000%2Findex.htm%3Ftoc.htm%3F2144.htm">http://help.kaseya.com/WebHelp/en-US/budr/3010000/index.htm?toc.htm?2144.htm</a></p> <p>This option is the most reliable option, as it reduces the complexity of the backup. However, as these KB Articles above note, temporarily stopping services related to the data being backed up is necessary. If some small downtime is allowed, Kaseya recommends that you use this route.</p> <p>Option 2 - VSS</p> <p>If downtime is not possible in your environment, then you can use the VSS option to backup live SQL, Exchange, and AD data. This is option is available to be selected in the Backup > Backup > Schedule Volumes page. This help file describes this as well under the "Verify VSS" section:</p> <p><a href="/home/leaving?allowTrusted=1&target=http%3A%2F%2Fhelp.kaseya.com%2FWebHelp%2Fen-US%2Fbudr%2F3010000%2Findex.htm%3Ftoc.htm%3F1197.htm">http://help.kaseya.com/WebHelp/en-US/budr/3010000/index.htm?toc.htm?1197.htm</a></p> <p>Other applications on the server can interfere with VSS, so Kaseya recommends that there are no other backup products installed and that any Antivirus product installed is the latest version available and is fully patched.</p> <p>Likewise, the operating system and SQL / Exchange should have all available patches applied, as there have been numerous VSS patches to Windows, SQL, and Exchange.</p> <p> </p> <p> </p> <p><strong>Applies To:</strong></p> <p>BUDR - Backup, K2</p> </article> </main>