Backup SQL server data to IDrive® Cloud

<!DOCTYPE html> <html lang="en"> <head> <link rel="canonical" href="https://www.idrive.com/online-backup-sql-server/mssql_backup"/> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/> <meta name="viewport" content="width=device-width, initial-scale=1"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <title>Backup SQL server data to IDrive® Cloud</title> <meta name="description" content="Backup your SQL server data with IDrive cloud storage. " /> <meta name="keywords" content="Backup SQL, IDrive SQL Backup, IDrive cloud backup, IDrive SQL cloud backup" /> <link rel="icon" href="https://static.idriveonlinebackup.com/include/images/favicon.ico" sizes="16x16" /> <link rel="shortcut icon" href="https://static.idriveonlinebackup.com/include/images/favicon.ico" type="image/x-icon" /> <link type="text/css" rel="stylesheet" media="screen" href="https://static.idriveonlinebackup.com/include/css/static-common-server-v2.css?v=2.4.5"> <link href="https://fonts.googleapis.com/css?family=Open+Sans:400,600" rel="stylesheet">    <style> h3 {display: block;width: 100%;padding-bottom: 10px;} </style> <script async src="https://www.googletagmanager.com/gtag/js?id=G-WMXM22QXPN"></script> <script> window.dataLayer = window.dataLayer || []; function gtag(){dataLayer.push(arguments);} gtag('js', new Date()); gtag('config', 'G-WMXM22QXPN'); </script> </head> <body class="inner blue_theme faq_page server-cloud-backup"> <header> <div class="wrapper"> <a href="/" class="mobile_logo_cont"></a> <div class="innerContainer"> <div class="headermenu mmenu"></div> <div class="topheader"> <ul> <li><a href="/idrive/login/loginForm" class="signin_sec">Sign in</a></li> <li><a href="/idrive/signupServer" class="signup_sec">Sign up</a></li> </ul> </div> </div> </div> </header> <section class="main_nav"> <div class="wrapper"> <nav> <ul> <li><a href="/index.html" class="logo"> Online Backup - IDrive</a></li> <li><a href="/online-backup-features" class="features-link">Features</a></li> <li><a href="/online-backup-download" class="download-link">Download</a></li> <li><a href="/pricing" class="pricing-link">Pricing</a></li> </ul> </nav> </div> </section> <main id="sb-site" class="menu_deactive"> <section class="sql-banner-wrap"> <div class="wrapper"> <h1>Server Cloud Backup</h1> </div> </section> <section class="body com-server-bkup sql-backup"> <div class="wrapper"> <div class="inner_wraper"> <section class="term_header"> <div class="clear"></div> <div class="server-nav-menu"><span></span><span></span><span></span></div> <h2>Backup Microsoft SQL Server</h2> <div class="clear"></div> </section> <section class="leftnav_terms"> <div class="server-menu"> <h4><a class="act" href="/server-cloud-backup">Server Cloud Backup</a></h4> <h4><a class="act" href="../online-backup-sql-server/">MS SQL Server</a></h4> <ul> <li><a href="../online-backup-sql-server/mssql_backup" class="act">Backup</a></li> <li><a href="../online-backup-sql-server/mssql_restore">Restore</a></li> <li><a href="../online-backup-sql-server/sql_server_auth">Authentication</a></li> </ul> <h4><a href="../online-backup-exchange-server/">On-premise MS Exchange Server</a></h4> <ul> <li><a href="../online-backup-exchange-server/exchange_backup">Backup</a></li> <li><a href="../online-backup-exchange-server/exchange_restore">Restore</a></li> <li><a href="../online-backup-exchange-server/exchange_brick">Brick Level Mailbox - Backup</a></li> <li><a href="../online-backup-exchange-server/exchange_brick_restore">Brick Level Mailbox - Restore</a></li> </ul> <h4><a href="../online-backup-sharepoint/">On-premise MS SharePoint Server</a></h4> <ul> <li><a href="../online-backup-sharepoint/sharepoint_backup">Backup</a></li> <li><a href="../online-backup-sharepoint/sharepoint_restore" >Restore</a></li> </ul> <h4><a href="../online-backup-oracle-server/">Oracle Server</a></h4> <ul> <li><a href="../online-backup-oracle-server/oracle_backup">Backup</a></li> <li><a href="../online-backup-oracle-server/oracle_restore">Restore</a></li> </ul> <h4><a href="../online-backup-system-state/">System State</a></h4> <ul> <li><a href="../online-backup-system-state/system-state-backup">Backup</a></li> <li><a href="../online-backup-system-state/system-state-restore">Restore</a></li> </ul> <h4><a href="../online-backup-hyper-v/">Hyper-V</a></h4> <ul> <li><a href="../online-backup-hyper-v/hyper_backup">Backup</a></li> <li><a href="../online-backup-hyper-v/hyper_restore">Restore</a></li> </ul> <h4><a href="../online-backup-vmware/">VMware</a></h4> <ul> <li><a href="../online-backup-vmware/vmware_backup">Backup</a></li> <li><a href="../online-backup-vmware/vmware_restore">Restore</a></li> </ul> <h4><a href="/online-backup-linux">Linux Server Backup</a></h4> </div> </section> <section class=" content_terms"> <div class="terms_header"> <div class="terms_header_right"> <div class="box2"> <div class="dbc-breadcrumb"> <a class="home" href="/" title="IDrive.com" alt="IDrive.com">Home</a> <a href="/online-backup-features" title="Features" alt="Features">Features</a> <a href="/server-cloud-backup" title="Server Cloud Backup" alt="Server Cloud Backup">Server Cloud Backup</a> <a href="/online-backup-sql-server/" title="MS SQL Server" alt="MS SQL Server">MS SQL Server</a> <a href="mssql_backup" title="Backup" alt="Backup">Backup</a> </div> <h2 class="page_title">Differential and incremental backup of your Microsoft SQL Server</h2> </div> </div> <div class="clear"> </div> </div> <div class="faq_terms"> <div class="faq_wrapper "> <p class="txtcont">Securely backup your company's running databases along with options to schedule backups, receive notifications and view log reports </p> <h3 class="heading_content">To perform differential backup, </h3> <a name="diffBkp" id="diffBkp"></a> <ol> <li>Sign in to the IDrive<sup>®</sup> application and click 'Server Backup'. A slider menu will appear.</li> <li>Click 'MS SQL'. The MS SQL connection screen appears. By default, 'MS SQL backup' is selected.</li> <div class="center"><img src="https://static.idriveonlinebackup.com/source/images/ib_sql_advanced_backup_exch_1531.png"></div> <li>Provide the relevant authentication information when prompted. IDrive<sup>®</sup> provides two modes of MS SQL server authentication. You can connect to your database using: <div class="center"><img src="https://static.idriveonlinebackup.com/source/images/ib_sql_login_exch31.png"></div> <p><strong>Windows Authentication Mode:</strong> When you connect through a Windows user account, MS SQL server validates the account name and password using the Windows principal token in the operating system. This means that your identity is confirmed by Windows. SQL server does not ask for the password and does not perform the identity validation. Windows Authentication is the default authentication mode and is more secure than SQL Server Authentication.</p> <p><strong>SQL Server Authentication Mode:</strong> When using SQL Server Authentication, logins are created in SQL server that are not based on Windows user accounts. Both the username and password are created by using SQL server and stored in SQL server. While connecting using SQL Server Authentication, you must provide your credentials (login and password) every time. When using SQL Server Authentication, you should set strong passwords for all SQL server accounts.</p> </li> <p><strong>Note:</strong> If you attempt to connect to an instance of MS SQL server by providing a blank login name, the SQL server uses the Windows Authentication. Additionally, if you connect to an instance of SQL server configured for Windows Authentication Mode using a specific login, the login is ignored, and the Windows authentication is used.</p> <li> Click 'Connect to MS SQL'.</li> <li>Select 'Online Backup', or 'Local Backup', or 'IDrive Express™ Backup'. <p><b>Note:</b> On selecting 'Online Backup', the data will be stored on the IDrive cloud whereas on selecting 'Local Backup' or 'IDrive Express™ Backup' the data will be stored in the local drive.</p> </li> <li>Select the database(s) from the list which appears and specify MS SQL backup temporary path for local backup. <p><strong>Note:</strong> Once the local backup is initiated, '.ServerBackup' folder is auto-created.</p></li> <li>Click 'Schedule Now'.</li> <div class="center"><img src="https://static.idriveonlinebackup.com/source/images/select-schedule-now300431.png"></div> <li>The 'Scheduler' screen appears, from where you can schedule the backup for any future day and time or perform an immediate backup of the selected databases. <div class="center"><img src="https://static.idriveonlinebackup.com/source/images/ib_sql_schedule_backup_exch31.png"></div> </li> <li> Click 'Save Changes'.</li> </ol> <p class="disclaimer"><b>Note:</b> IDrive<sup>®</sup> for Windows allows you to schedule the MS SQL server backup for different instances. For easy identification of the MS SQL server backup set, the name of the backup set will be 'IDSQLServerBkset' followed by the instance name scheduled for backup. Example: If the instance name is 'MJOHN\INSTMJOHN' then the name of the backup job is 'IDSQLServerBkset' (MJOHN##INSTMJOHN)'.</p> <h3 style="margin-top:20px" class="heading_content">To perform incremental backup, </h3> <a name="incBkp" id="incBkp"></a> <ol> <li>Sign in to the IDrive<sup>®</sup> application and click Server Backup. </li> <li>Click 'MS SQL'. The MS SQL connection screen appears. By default, 'MS SQL backup' is selected.</li> <div class="center"><img src="https://static.idriveonlinebackup.com/source/images/ib_sql_advanced_backup_exch_1531.png"></div> <li>Provide the relevant authentication information when prompted. IDrive<sup>®</sup> provides two modes of MS SQL server authentication. Click 'Connect to MS SQL'. <div class="center"><img src="https://static.idriveonlinebackup.com/source/images/ib_sql_login_exch31.png"></div> </li> <li>Select 'Online Backup', or 'Local Backup', or 'IDrive Express™ Backup'. <p><b>Note:</b> On selecting 'Online Backup', the data will be stored on the IDrive cloud whereas on selecting 'Local Backup' or 'IDrive Express™ Backup' the data will be stored in the local drive.</p></li> <li>Select the database(s) from the list which appears and select the 'Incremental' option. <p><strong>Note:</strong> To perform the incremental backup, database should be in a <a href="https://www.idrive.com/idrive-for-mssql-faq#changeDB">full/bulk-logged recovery model</a>.</p> </li> <li> Specify the local backup location and click 'Schedule Now'. <div class="center"><img src="https://static.idriveonlinebackup.com/source/images/ib_sql_server_restoreui_exch31.png"></div> </li> </li> <li> In the 'Scheduler' that appears, schedule the backup for any future day and time or perform an immediate backup of the selected databases. <div class="center"><img src="https://static.idriveonlinebackup.com/source/images/ib_sql_schedule_backup_exch31.png"></div> </li> <li>Click 'Save Changes'.</li> </ol> <br> <div class="textbrdr">View the steps to <a href="mssql_restore">restore the MS SQL Server</a>.</div> </div> </div>  </section> </div>  </div> </section>  <section class="server-signup-con"> <div class="wrapper"> <h5>Protect your organization's data with secure online server backups</h5> <br> <a href="/idrive/signupServer"><span class="btn">SIGN UP NOW!</span></a> </div> </section> </main> <section class="supportContent fluid-support"> <div class="supportMob"> <a href="/support"> <p class="smart_tel_num">1-818-485-4333</p> </a> </div> </section> <footer> <div class="footerMain"> <div class="wrapper"> <ul> <li> <h4 class="IDlogo"><a href="/">My IDrive</a></h4> </li> <li><a href="/idrive/signupServer">Sign Up</a></li> <li><a href="/online-backup-features">Features</a></li> <li><a href="/online-backup-download">Download</a></li> <li><a href="/pricing">Pricing Plans</a></li> <li><a href="/online-backup-security">Security</a></li> <li><a href="/online-backup-education">Educational Offer</a></li> <li><a href="https://blog.idrive.com/">Blog</a></li> <li><a href="/idrive-vs-competition">IDrive vs Competition</a></li> <li> <ul class="subcategory"> <li> <h4><a href="/nas-backup" class="h4Link">NAS Backup</a></h4> </li> <li><a href="/synology-backup">Synology Backup</a></li> <li><a href="/qnap-backup">QNAP Backup</a></li> <li><a href="/netgear-backup">Netgear Backup</a></li> <li><a href="/asustor-backup">Asustor Backup</a></li> </ul> </li> </ul> <ul> <li> <h4>Products</h4> </li> <li><a href="/iphone-ipad-android-backup/">iPhone, iPad, Android Backup</a></li> <li><a href="/online-backup-linux">Linux Backup</a></li> <li><a href="/bare-metal-recovery/">IDrive BMR</a></li> <li><a href="/image-backup">Disk Clone</a></li> <li> <ul class="widFul"> <li> <h4><a href="/server-cloud-backup" class="h4Link">Server Cloud Backup</a></h4> </li> <li><a href="/online-backup-sql-server/" target="_self">SQL Server</a></li> <li><a href="/online-backup-exchange-server/" target="_self">On-premise MS Exchange Server</a></li> <li><a href="/online-backup-sharepoint/" target="_self">On-premise MS SharePoint Server</a></li> <li><a href="/online-backup-oracle-server/" target="_self">Oracle Server</a></li> <li><a href="/online-backup-system-state/" target="_self">System State</a></li> <li><a href="/online-backup-hyper-v/" target="_self">Hyper-V</a></li> <li><a href="/online-backup-vmware/" target="_self">VMware</a></li> </ul> </li> </ul> <ul class="featureList"> <li> <h4>Features</h4> </li> <li> <a href="/multiple-device-online-backup">Multiple Device Online Backup</a></li> <li> <a href="/small-business">Small Businesses</a></li> <li><a href="/dashboard">Manage Computers via Web</a></li> <li><a href="/snapshots">Snapshots</a></li> <li><a href="/true-archiving">True Archiving</a></li> <li> <ul class="subcategory"> <li> <h4>Services</h4> </li> <li><a href="/reseller/">Resellers</a></li> <li><a href="/idrive-express">IDrive Express</a></li> <li><a href="/online-backup-compliance">Business Compliance</a></li> </ul> </li> </ul> <ul class="helpList"> <li> <h4>Resources</h4> </li> <li><a href="/support">Support</a></li> <li><a href="/idrive-for-mssql-faq">FAQs</a></li> <li><a href="/videos">Video Tutorials</a></li> <li><a href="/online-backup-company">Corporate</a></li> <li><a href="/ventures">IDrive Ventures</a></li> <li><a href="/online-backup-news">Press Releases</a></li> <li><a href="/online-backup-reviews">Reviews</a></li> <li><a href="/terms-and-conditions">Legal</a></li> </ul> </div> </div> <div class="copyright"> <div class="wrapper"> <p>© IDrive Inc.</p> <div class="socialIcons"> <a href="https://www.facebook.com/IDriveBackup" class="facebook" rel="noreferer, ,noopener" target="_blank"> <img src="https://static.idriveonlinebackup.com/source/images/spacer.gif" alt="Facebook"></a> <a href="https://twitter.com/IDriveBackup" class="twitter" rel="noreferer, ,noopener" target="_blank"> <img src="https://static.idriveonlinebackup.com/source/images/spacer.gif" alt="Twitter"> </a> <a href="http://www.linkedin.com/company/1498880" class="linkedin" rel="noreferer, ,noopener" target="_blank"> <img src="https://static.idriveonlinebackup.com/source/images/spacer.gif" alt="LinkedIn"> </a> </div> </div> </div> </footer> </div> </section>  <script type="text/javascript" src="https://static.idriveonlinebackup.com/source/scripts/inner-script-server.js?v=2.0.1"></script>  <script type="text/javascript"> window.__lc_criteo = window.__lc_criteo || {}; $(document).ready(function(){ setTimeout(function(){ var lc_criteo = document.createElement('script'); lc_criteo.type = 'text/javascript'; lc_criteo.async = true; lc_criteo.src = ('https:' == document.location.protocol ? 'https://' : 'http://') + 'static.criteo.net/js/ld/ld.js'; var c_source = document.getElementsByTagName('script')[0]; c_source.parentNode.insertBefore(lc_criteo, c_source); window.criteo_q = window.criteo_q || []; window.criteo_q.push( { event: "setAccount", account: 21742}, { event: "setSiteType", type: /iPad/.test(navigator.userAgent)?"t":/Mobile|iP(hone|od)|Android|BlackBerry|IEMobile|Silk/.test(navigator.userAgent)?"m" :"d"}, { event: "viewHome"}); },1000); }); </script> </body> </html>

CINXE.COM

Backup SQL server data to IDrive® Cloud