Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Scroll export button
scopecurrent
template-idc90a677c-6f58-46bd-ba09-bffcf789e689
captionExport this article to PDF
quick-starttrue
add-onScroll PDF Exporter

Detailed guide to perform a SQL Server Database Backup

Step-by-step guide


Scroll content block
  • Log in to your SQL Server, and Run the SQL Server Management Studio.

...


Scroll content block
  • Connect to the SQL Server with the proper credentials.

...


Scroll content block
  • Locate the IDSync database (it's usually called IDSync or IDSyncDB, but the name may change depending on your naming conventions).
  • Right-click on the database >> Tasks >> Backup

...


Scroll content block
  • Check the backup settings (such as Backup type = Full or the destination location), and then click OK.

...


Scroll content block

Note that the 'Destination' field holds the actual path were the backup-file will be located.

Image Removed

...


Scroll content block
  • Monitor the progress, and wait for the 'Success' window message to show up.

Image Removed

Image Removed


Scroll content block

Please note that the resulting file name is based on the database name, so, for purposes of control and troubleshooting, it's probably a good idea to rename it (maybe adding the company's name and the date the file was created).

...

...

        

...



Info

You can also find more information on Microsoft's documentation :

https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/backup-overview-sql-server?view=sql-server-2017

https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/create-a-full-database-backup-sql-server?view=sql-server-2017

...