Quick and Easy way to make SQL Server Backups move faster

How to make SQL Server Backups move faster

Introduction

In this article we will be looking at a Quick and Easy way to make SQL Server Backups move faster. Backing up your database helps you to recover your data in the event of a catastrophic disaster. There are various ways of backing up your SQL Server database, but in this article, we will be focusing on a method that I use that will help to make your backups move faster. Below are steps taken to backup databases via the command line and there is also a gif below demonstrating this.

Steps Taken

  1. Open your management studio and identify the database you want to backup.
  2. Right-click the database and got to: Tasks >Back up…
  3. Enter the appropriate parameters/configurations
  4. At the top of the window select the arrow beside the script button and select Script Action to Clipboard (Ctrl+Shift+C)
  5. Go to your start menu and open command Line tool (CMD)
  6. Once in the command-line tool, type sqlcmd to access the database
  7. Right-click and paste the copied command onto the command line.
  8. The backup will start running immediately after pasting the command on the command line (Ensure there is a GO command after the backup script.

How To GIF

Quick and Easy way to make SQL Server Backups move faster
Quick and Easy way to make SQL Server Backups move faster