ÿþ <html> </head> <title>BackupAssist  SQL Server Backup, SQL database full and transaction log backup, near continuous data protection</title> <meta name="description" content="Simple and affordable backup software for Windows servers. Easy to manage with email reminders, scheduling wizards and preconfigured rotation schemes." /> <link href="../stylesheets/default.css" rel="stylesheet" type="text/css" /> <script type="text/javascript" src="../js/jquery.js"></script> <script type="text/javascript" src="../js/jquery.lightbox-0.5.js"></script> <script type="text/javascript"> var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www."); document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E")); </script> <script type="text/javascript"> try { var pageTracker = _gat._getTracker("UA-15361906-2"); pageTracker._trackPageview(); } catch(err) {}</script> <link href="../stylesheets/jquery.lightbox-0.5.css" rel="stylesheet" type="text/css" /> <script type="text/javascript"> $(function() { $('a.lb1').lightBox(); $('a.lb2').lightBox(); $('a.lb3').lightBox(); $('a.lb4').lightBox(); $('a.lb5').lightBox(); $('a.lb6').lightBox(); }); </script> </head> <body> <div class="all"> <div class="header"> <SCRIPT src="../js/preload.js" type="text/javascript"></SCRIPT> <div style="height:55px;"> <div class="message">Simple, Reliable, Affordable <br /><strong>BACKUP SOFTWARE</strong></div> <div class="logo"><a href="../index.aspx"><img src="../images/logos/ba-darkbg.png" alt="BackupAssist Home" /></a></div> </div> <DIV class="main_menu" > <TABLE class="main_menu"> <TR> <TD id="tour" class="current"><A href="index.html">Product Tour</A></TD> <TD id="download" ><A href="download2.aspx">Download</A></TD> <TD id="purchase" ><A href="../purchasing/purchase.aspx">Purchase</A></TD> <TD ><A href="../education/index.html">Documentation</A></TD> <TD ><A href="../support/index.html">Support</A></TD> <TD ><A href="../BackupAssist/faq.html">FAQ</A></TD> <TD ><A href="../reseller/index.aspx">Reseller</A></TD> <!--<TD ><A href="../blog/index.html">Blog</A></TD>--> <TD style="border-right: none;" ><a href="../about/index.html">About</a></td> </TR> </TABLE> </DIV> </div> <div class="nav_bar"> <div class="nav_text"> <a href="../index.aspx">BackupAssist Home</a> &gt; <a href="index-2.html">Product Tour</a> &gt; SQL Backup and Restoration</div><div class="search_bar"> <form action="http://www.backupassist.com/search/search.php"> <!--Search support: <input name="keywords" /> <input type="submit" value="Go" />--> </form> </div> </div> <div class="main"> <h1>SQL Backup and Restoration</h1> <div class="smallTOC"> <ul class="contentslist"> <li><strong>Licensing</strong><br> BackupAssist SQL Server Add-on</li> <li><strong>Supported SQL Servers</strong><br> SQL Server 2000, 2005, 2008 <span>(all variants)</span></li> <li><strong>Method</strong><br> SQL backup in standard .bak format. </li> <li><strong>Resources</strong><br></li> <li><img src="../images/icons/acrobat_icon2.png" alt="Brochure" width="16" height="16" align="absmiddle"> <a href="../downloads/brochures/sqlBrochure-Web-Lowres.pdf" target="_blank">Brochure</a></li> <li><img src="../images/icons/acrobat_icon2.png" alt="White paper" width="16" height="16" align="absmiddle"> <a href="../downloads/whitepapers/SQL_WP.pdf" target="_blank">White paper</a></li></ul></div> <p>BackupAssist&rsquo;s SQL Backup Engine allows you to backup SQL Servers with a choice of either <strong>daily</strong> backups or <strong>near-continuous</strong> backups (every 15 minutes), and backing up <strong>specific databases</strong> or <strong>complete servers</strong>.</p> <p>And with a Restore Wizard that makes database recovery simple, BackupAssist is a great way of protecting your databases and the applications that sit on top of SQL Server.</p> <div class="highlights"> <div class="header">Highlights</div> <div class="list"> <ul class="ticks"> <li>Backup any number of local or remote (networked) SQL Servers from one machine (using only one add-on license)</li> <li>Choose between daily backups or near-continuous data protection</li> <li>Capture a "live snapshot" of your databases, so the SQL Server can be running during the backup</li> <li>Perform Transation-log backups of your SQL databases for specific point-in-time restoration of databases</li> <li>Restore an entire SQL server or individual databases using the built-in SQL Restore utility</li> </div> </div> <h2>Select the SQL Servers to backup</h2> <div class="tourscreenshot"> <a target="_blank" href="../images/tour/screenshots/sql_selection.png" class="lb1"> <img src="../images/tour/screenshots/sql_selection_small.png" alt="Selecting SQL Servers" border="0"><div>Select the SQL Servers and Databases to backup</div></a> </div> <p>Simply point-and-click to select the SQL Servers, instances and databases to backup. </p> <div class="tourscreenshot" style="margin-top: 0px;"> <a target="_blank" href="../images/tour/screenshots/sql_basic.png" class="lb2"> <img src="../images/tour/screenshots/sql_basic_small.png" alt="Basic protection" border="0"> <div>Basic protection - backup one per day</div></a> </div> <h2>Basic protection - daily backups</h2> <p>Backup on a daily basis at a specified time. </p> <div class="tourscreenshot"> <a target="_blank" href="../images/tour/screenshots/sql_transactional.png" class="lb3"> <img src="../images/tour/screenshots/sql_transactional_small.png" alt="Near-continuous protection" border="0"><div>Near-continuous protection - backup every 5, 10, or 15 minutes</div></a> </div> <h2>Superior protection - 15-minute incremental backups</h2> <p>Achieve near-continuous protection for SQL Server (without the high costs of clustering or replication): </p> <ol> <li>Before the work day begins, perform a full backup of all databases</li> <li>During the work day, backup your databases at 15 minute intervals (transaction log backup)</li> </ol> <div class="tourscreenshot"> <a target="_blank" href="../images/tour/screenshots/sql_retention.png" class="lb4"> <img src="../images/tour/screenshots/sql_retention_small.png" alt="Backup history" border="0"><div>Keeping a backup history to enable different restore points</div></a> </div> <h2>Choose how many backups to keep</h2> <p>Keeping multiple backups is highly recommended, as it: </p> <ol> <li>Gives you multiple restore points </li> <li> Means that if one backup becomes corrupt, you have an alternative to restore from </li> </ol> <h2>Resources</h2> <ul class="contentslist" style="margin-top: 25px;"> <li><img src="../images/icons/acrobat_icon2.png" alt="Brochure" width="16" height="16" align="absmiddle"> <a href="../downloads/brochures/sqlBrochure-Web-Lowres.pdf" target="_blank">Brochure</a></li> <li><img src="../images/icons/acrobat_icon2.png" alt="Fact Sheet" width="16" height="16" align="absmiddle"> <a href="../downloads/whitepapers/SQL_WP.pdf" target="_blank">White paper</a></li> </ul> </div> <div class="navigation"> <!--<table class="button_menu"> <tr> <td><a href="/BackupAssist/"><img src="/images/buttons/tourButton.png" alt="BackupAssist Product Tour" /></a></td> </tr> <tr> <td><a href="/BackupAssist/download.php"><img src="/images/buttons/evalButton.png" alt="Evaluate BackupAssist" /></a></td> </tr> <tr> <td><a href="/BackupAssist/purchase.php"><img src="/images/buttons/purchaseButton.png" alt="Purchase BackupAssist" /></a></td> </tr> <tr> <td><a href="/BackupAssistV5/beta/v5_1Beta_Announcement.php" id="beta"><img src="/images/buttons/5_1_Beta.png" alt="BackupAssist Beta 5.1" /></a></td> </tr> </table>--> <!--<table class="button_menu"> <tr> <td><a href="/BackupAssistv5/DriveImaging.html"><img src="/images/buttons/server08.png" alt="Server 2008 Drive Imaging" /></a></td> </tr> --> <!--<tr> <td> <a href="/BackupAssistV5/beta/v5Beta_Announcement.html"><img src="/images/buttons/v5betabutton.png" alt="BackupAssist v5 Beta" /></a> </td> </tr> </table>--> <!-- Insert Special or New Items Here --> <table class="sub_menu"> <tr> <th colspan="2">Product Tour</th> </tr> <tr> <td colspan="2"><A id="sub_menu_backupassist_overview" href="index.html" >Overview</A></td> </tr> <tr> <td colspan="2"><A id="sub_menu_backupassist_imaging" href="tour_Imaging.html" >Imaging - Server 2008</A></td> </tr> <tr> <td colspan="2"><A id="sub_menu_backupassist_ntbackup" href="tour_NTBackup.html" >NTBackup</A></td> </tr> <tr> <td colspan="2"><A id="sub_menu_backupassist_filereplication" href="tour_FileReplication.html" >File Replication</A> </td> </tr> <tr> <td colspan="2"><A id="sub_menu_backupassist_rsync" href="tour_Rsync.html" >Rsync Internet Backup</A></td> </tr> <tr> <td colspan="2"><A id="sub_menu_backupassist_exchange" href="tour_Exchange.html" >Exchange Backup</A></td> </tr> <tr> <td colspan="2"><A id="sub_menu_backupassist_sql" href="tour_SQL.html" class="current" >SQL Backup</A></td> </tr> <!--<tr> <td colspan="2"><A id="sub_menu_backupassist_monitoring" href="tour_Monitoring.html" >Centralized Monitoring</A> </td> </tr>--> </table> <!--DOWNLOAD RIGHT--> <div style="clear: both; padding-top: 10px;"> <a href="download2.aspx"><img src="../images/buttons/downloadButtonTourSm.png" alt="Download BackupAssist Trial" /></a> </div> <!--<table class="sub_menu"> <tr> <th>LINKS</th> </tr> <tr> <td><A id="sub_menu_backupassist_downloads" href="/BackupAssist/download.php" >Downloads</A></td> </tr> <tr> <td><A id="sub_menu_backupassist_purchase" href="/BackupAssist/purchase.php" >Pricing / purchase</A></td> </tr> <tr> <td><A id="sub_menu_backupassist_faq" href="/BackupAssist/faq.html" >FAQ</A></td> </tr> <tr> <td><A id="sub_menu_backupassist_testimonials" href="/BackupAssist/testimonials.html" >Testimonials</A></td> </tr> <tr> <td><A id="sub_menu_backupassist_history" href="/BackupAssist/history.html" >Version history</A></td> </tr> <tr> <td><A id="sub_menu_backupassist_upgrade" href="/upgrade/upgradev4tov5.html" >Upgrading - v4 to v5</A></td> </tr> <tr> <td><A id="sub_menu_backupassist_upgrade" href="/upgrade/upgradev3tov5.html" >Upgrading - v3 to v5</A></td> </tr> </table>--> </div> <div class="prev_next"> <!-- Set the urls --> <!-- Set the prev url --> <!-- Set the next url --> <table id="prev_next_centre" cellpadding="0" cellspacing="0"> <tr> <td width="33%"> <a href="tour_Exchange.html" class="nextprevlink"><img src="../images/tour/previous_button.png" width="24" height="24" align="middle" alt="Previous" /></a>&nbsp;<a href="tour_Exchange.html" class="nextprevlink">Previous</a> </td> <td width="34%" align="center"> <a href="download2.aspx"><img src="../images/buttons/downloadButtonTour.png" alt="Download BackupAssist Trial" /></a> </td> <td width="33%" align="right"> <a href="tour_Monitoring.html" class="nextprevlink">Next</a>&nbsp;<a href="tour_Monitoring.html" class="nextprevlink"><img src="../images/tour/next_button.png" width="24" height="24" align="middle" style="padding-top: 6px;" alt="Next"/></a> </td> </tr> </table> </div> <div class="footer"> <p><!--&copy; Copyright 2002-8 BackupAssist Backup Software<br />--> <!--<a href="testimonials.html">CUSTOMER TESTIMONIAL</a> | <a href="../resources/index.html">RESOURCES</a> | <a href="../about/index.html">ABOUT</a> | <a href="../privacy.html">Privacy Policy</a> | <a href="../Disclaimer.html">Disclaimer</a></p> --> <a href="testimonials.html">CUSTOMER TESTIMONIAL</a> | <a href="../resources/index.html">RESOURCES</a> | <a href="../about/index.html">ABOUT</a> | <a href="../privacy.html">Privacy Policy</a> | <a href="../Disclaimer.html">Disclaimer</a></p> </div> </div> <script type="text/javascript"> var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www."); document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E")); </script> <script src="../js/ga_keyword2.js" type="text/javascript"></script> <script type="text/javascript"> var pageTracker = _gat._getTracker("UA-244061-1"); pageTracker._initData(); pageTracker._trackPageview(); </script> </body> <!-- Mirrored from www.backupassist.com/BackupAssist/tour_SQL.html by HTTrack Website Copier/3.x [XR&CO'2008], Fri, 07 Aug 2009 07:41:49 GMT --> <!-- Added by HTTrack --><meta http-equiv="content-type" content="text/html;charset=ISO-8859-1"><!-- /Added by HTTrack --> </html>