Back up a SQL database

Back up a SQL Server database

Backing up a SQL server database requires that you have the proper rights to log in to SQL server through SQL Management Studio. You will also require the proper rights on the database to perform the backup. It is recommended that your login have db_owner role membership for the ThoughtFarmer database.

Back up the ThoughtFarmer database to disk

  1. Open SQL Management Studio.
  2. Connect to the SQL server instance where the ThoughtFarmer database is.
  3. Click on the server name to expand the tree in the Object Explorer.
  4. Open the Databases folder and right click on the ThoughtFarmer database.
  5. Choose Tasks > Back up...
  6. In the Backup type list box select "Full".
  7. In the Destination section select Back up to: Disk
  8. Choose a new backup location by selecting the default, clicking Remove and then clicking Add.
  9. Choose a new location and file name. Be sure that the specified location has sufficient space to store the backup.
  10. Click OK to begin the backup.

Note: The above process will select a new location for the backup to separate a pre-upgrade backup from your regular maintenance plan backups. You can still use the default backup, if preferred, by not changing anything in steps 7-9 above.