EPDM – Performing a Back-up using SQL Server Management Studio

Article by Joe Medeiros, CSWE, last updated on May 17, 2016

A back-up can be created using Collect Support Information and this method is the easiest, but it may be faster and more convenient to create a back-up directly from SQL Server Management Studio.

From Windows Start, launch Microsoft SQL Server Management Studio.

Start SQL Studio

 

Enter all of the required information and press Connect.

SQL Connect

 

Find vault database to be backed up, under the Databases folder, then right-click on the database and select Back-up from Tasks

Back-up

 

In the Source section, ensure that the correct database is selected and chose the Back type. A full back-up is recommended. Provide a Name for the back-up. Optionally a description can be added.  The Add and Remove buttons can be used to add or remove back-up locations.

back-up options

 

Please refer to my blog article EPDM – Are you backing you critical data… for best practices regarding back-ups.

 

 

 

 

Related Posts

Related content by tag:

Joe Medeiros, CSWE

Joe Medeiros is a SOLIDWORKS and PDM Certified Expert. He has been helping SOLIDWORKS users with training, mentoring and implementations since 1998. He combines industry experience with a thorough understanding of SOLIDWORKS products to assist customers in being successful. He shares his experience and expertise through blogs; one of which has been incorporated into the SOLIDWORKS Essentials training manual.

Want to learn SOLIDWORKS?

Take a training course from our team of Certified SOLIDWORKS Experts