NovaStor Logo

Looking for Enterprise Backup? Visit NovaStor.com

NovaBACKUP-blog

NovaBACKUP Blog

Stay up-to-date on all things backup and more!

 

Essentials for Backing Up SQL Server Database

by Oscar Pineda, on Oct 17, 2014 11:30:53 AM

SQL Server Database BackupDatabases 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:

  • Sage
  • vTiger
  • Casengo
  • Microsoft Dynamics
  • SAP
  • PeopleSoft
  • Siebel

SQL-server-db

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.

Backup SQL Server Database

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.

Resotre SQL Server Database

 

Categories:ApplicationsTips and Tricks

NovaBACKUP Blog

The NovaBACKUP blog is focused on providing insight on data protection that is relevant to the SMB market and to managed service providers. 

Visit NovaStor blog for enterprise posts
Sales-support-icon
Talk to a Backup Expert
Our support engineers are here to assist you.

Request 30-Minute Consultation »

training-icon
Request a Trial
Get a free trial of our software in your environment.

Request a free trial »

Newsletter Signup