Essentials for Backing Up SQL Server Database
by Oscar Pineda, on Oct 17, 2014 11:30:53 AM
Databases contain a lot of critical data that is important to the ongoing operations of your business, which is why SQL server maintenance should be high on your list of priorities. The most important aspect of maintaining a SQL server, is backing up your databases.
Backing up SQL server databases doesn't have to be a daunting task. With NovaBACKUP Business Essentials from NovaStor, it couldn't be easier. Our latest backup usage stats reveal that over 40% of our customers run backup jobs that include some type of SQL database. This is explained by the number of SMB users who are currently using SQL based products such as Enterprise Resource Planning (ERP) and Customer Relationship Management (CRM) systems. These systems contain a wealth of data stored in tables, columns, variables, and fields often utilizing Microsoft SQL.
Here are some of the applications that often utilize Microsoft SQL, which may be important to include when backing up SQL Server:
- Microsoft Dynamics
Essentials for Backing Up SQL Server
Knowing that customers must protect important SQL data, NovaBACKUP Business Essentials offers some key benefits.
- API level SQL Backup and Restore functionality
- No need to stop service or shut down applications
- Support for Microsoft SQL 2014
- Fast and immediate support for new SQL releases/updates
- Automatic identification of SQL Server databases
- Supporting a physical or virtual machine SQL server
- No additional costs (for SQL plugin or functionality)
How to Backup a SQL Server Database
You may be wondering, "will backing up SQL server databases using NovaBACKUP be easy enough for me to do myself?" The answer is Yes. It's as simple as selecting the database you want to backup, selecting where to backup to and setting your backup job schedule.
Under the Backup tab you will the Microsoft SQL server plugin. On the right hand side, just select the database you want to back up. In the example, we are backing up the database called ManagementServer.
Next you will need to select the destination of your backup. In the lower left-hand side of the screen, you will see a button called Backup to. Simple click this button and navigate to the location you would like to save your backups to.
From here you can Estimate the size of your backup, or Schedule your backup jobs to run automatically based on your set schedule. It's really that easy.
How to Restore a SQL Server Database
Restoring a SQL server database with NovaBACKUP is just as easy. Just click on the Restore tab, find your SQL backup job, select your database and click restore.