Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What is the best way to create a back-up of an MS-SQL database?

April 26, 2017back-up best create database ms-sql

0

Posted

What is the best way to create a back-up of an MS-SQL database?

1 Answer

0

Posted

The best way to back-up an MS-SQL database is to create a zip file fo the .mdf file for the database. This is only possible if you selected the Auto Close option when you created the database. Otherwise, you can create an ACCPAC dump file (this will not work if your database contains third-party products – i.e. UniDevCo Modules). An alternative would be to copy the file using a tape back-up system.