Backup a SQL Database

Need to take a manual backup of a SQL database

• OnPrem
• SSMS (Sql Server Management Studio)
• Database Backups

Instructional

You may take a manual backup of a SQL database within SSMS by:

1. Connect to the SQL instance (Named or Default) that contains your database, using the SA user or Tylerservice User
2. Right-click on the database you want to backup, then click Tasks then Back Up... 
3. On the General tab, The default selections under the Source section are usually acceptable
   1. Make sure Copy-Only backup is left unchecked
   2. Backup component should be Database
   3. Destination should back up to Disk
4. Remove any pre-existing backup file paths from the white field at the bottom
5. Click Add
   1. Browse to a desired destination location or use UNC pathing to name the backup and send it to a given location.  Make sure the backup includes .bak file extension at the end. 
6. On the Media Options tab:
   1. Select Back up to the existing media set
   2. Select Overwrite all existing backup sets
   3. Select Verify Backup when finished
7. Click OK on the bottom right of the window and the backup will begin. A message will appear to let you know when the backup is complete or if it has encountered any error. 

Contact Tyler Systems Management Support or log a case via the Online Support Client Portal for additional support. 

On Demand Backup For On-Premise Munis Clients