Building better technology
for the civil engineering industry

Building better technology
for the civil engineering industry

Search

Tel: +44 (0)118 945 3737

Tel: +44 (0)118 945 3737

VJTech Limited Mobile Logo Search

 Login  Register Tel: +44 (0)118 945 3737

 
     
Attaching and Detaching a Database

Attaching and Detaching a Database

Mar 11 2015

 

Attaching and Detaching a Database on Clisp Studio

Introduction

Clisp Studio allows for Databases to be attached and detached whenever necessary.

This Blog can be downloaded as a support document - SUP0078

Detaching a Database

Occasionally you may be required to detach a database in order to restore a database from a previous backup. To detach a database, open Clisp Studio, select the Files > Database Connection


Figure 1 - Files Menu

The Database Connection window will appear. Select the database you wish to detach.

Figure 2 - Select the Database

Once you have selected the database you want to detach, expand the Options drop down menu and select Detach this Database, see Figure 3.

Figure 3 - Detaching a Database

The Database will now be detached and no longer be visible in the database selection.

Attaching a Database

If a database is not available in the database selection menu, it can be reattached, providing you have created the database on the same PC.

Open the Database Connection window (see Figure 1).

Click on the Options drop down menu and select Attach an existing Database


Figure 4 - Database connection (attach an existing database)

 

A file explorer window will appear (see Figure 5).

Navigate to the location:

Computer > C: Drive > Program Files > Microsoft SQL Server > MSQL10_50.SQLEXPRESS (this may vary) > MSSQL > DATA

NOTE: Databases will be saved in .mdf format.

Select the database you want to open.

Figure 5 - Database location

The Database is now attached, click Select to open the database.

Figure 6 - Database Connections selecting a database

 

Identifying the Database that is open

To identify the database that is currently open, open the Test Explorer. (see Figure 7 below)

                                                                                       Figure 7 - Opening Test Explorer             

The Database that is currently open will be displayed at the bottom of the Test Explorer, see Figure 8.

Figure 8 - Test Explorer

 

Total: 0 Comment(s)

Latest Posts

On sample transducers - Sample preparation
4/1/2021 1:57 PM | Irina@vjtech.co.uk
Introduction to Direct Simple Shear (DSS) Testing
1/26/2021 9:45 AM | adrian@vjtech.co.uk
CLISP Studio Release 2.10.1.0
12/16/2020 9:52 AM | adrian@vjtech.co.uk
Clisp Studio 2.9.0.0 Release
10/8/2020 1:54 PM | vasileios@vjtech.co.uk
Introduction to Permeability Testing
9/11/2020 10:23 AM | Irina@vjtech.co.uk

Categories


Archives

2021 Apr 5 1
2021 Jan 114 1
2020 Dec 23 1
2020 Oct 86 1
2020 Sep 2233 1
2020 Jul 1279 2
2020 Apr 102 1
2020 Feb 60 1
2019 Nov 2311 1
2019 Oct 42 1
2019 Jul 89 1
2019 Jun 150 3
2019 May 4957 1
2018 Mar 19993 1
2017 Oct 52979 1
2017 Aug 493 1
2016 Sep 71 1
2016 Aug 96 1
2016 Jul 7 1
2016 May 29 1
2016 Apr 69 1
2016 Mar 35 1
2016 Feb 158 3
2016 Jan 120 1
2015 Dec 35 1
2015 Nov 140 1
2015 May 291 1
2015 Mar 953 4
2015 Feb 777 1
2014 Nov 2557 8
2014 May 514 6
2014 Apr 507 7
2014 Mar 1408 12
2013 Dec 82 1

Tags