Detaching and attaching databases

When a database is used by SQL database server, it is locked: you are not able to even view into it, nor make a copy of it. This is due to data protection reasons. Detach operation will break the link between the database server and data files, while attach will rebuild this link again.

Detaching database files

You can detach a database from the database server, and this way it will stop using it. Now you can make an exact copy of the database, or delete the database files, if these become unnecessary.

1. To detach a database from the server, click Database Server icon at the left, then select Detach a database file task from the right.

2. A detach wizard appears. Enter 'sa' database administrator name and your password to local database server, then click Next.

Note: Default database server password is Hlpwd2023 for the HyperLab 2023 product line (after an upgrade, you may also try Hlpwd 2013..2022, orhlpwd2002..2009).

3. A database selection page appears now.

Select the database you want to detach, then click Next.

Click Finish to close the wizard.

Attaching database files

If you have a previously saved data file – log file pair, you can attach them to your local database server.

To attach a database to the SQL database server, click Database Server icon at the left, then select Attach a database file task from the right.

A database attach wizard appears.

Enter 'sa' database administrator name and your password to local database server.

Note: Default database server password is 'Hlpwd2023' for HyperLab 2023 product line (after an upgrade, you may also try Hlpwd2013..2022, orhlpwd2002..2009).

When you are ready, click Next.

A database file selection page appears now. When you successfully selected the MDF file, the wizard will automatically fill up the LOG file name field as well as the descriptive database name.

Change the LOG file name if it does not match your real file name. You can also modify the descriptive database name.

When you are ready, click Next. The database attach process starts now.

When a regular folder is used first, an error message may pop up about that the SQL Server has no right to access to the specified directory.

In this case you should add Full access right to the predefined NETWORK SERVICE user over the folder and its content, and do the attach by HyperLab after started with Administrator user rights.

If the access rights on the folder and on the files are OK, the database attach process starts now.

Click Finish to close the wizard.

Do not forget to register the freshly attached database to HyperLab, so it will appear in HyperLab Databases list.