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

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.

 

 

 

 

Become a SolidWorks Expert

If you want to become more efficient with SolidWorks then learn SolidWorks live over the web with Javelin. Classes include Drawings, Surfacing, Sheet Metal, Simulation, plus GD&T.

Leave a Reply

Your email address will not be published. Required fields are marked *