How to Back Up Database Files Directly (Microsoft SQL Server)

The procedure for directly backing up your database files involves making sure the database file is unlocked and accessible to your normal tape back-up program so that the back-up program can back up the database (.Mdf) file, the transaction log (.Ldf) file, as well as the other Archibus project files.

You typically use this kind of procedure if you are the only user on your Archibus database. In this case, your database files are likely to be in your regular Archibus project folder.

1. Close the project database, if the project is open.

• This ensures that the database server process does not have a lock on the database file, as this would prevent the back-up program from accessing that file. It also ensures that the SQL Server truncates the transaction log.

2. Stop the database server using Microsoft SQL Service Manager. To do this:

• Invoke Programs/Microsoft SQL Server/Service Manager.
• In the Service Manager window, click the "Stop" button.

3. Back up all files in the projects folder. There are a few methods:

• You can use your regular tape back-up procedures. An automated tape backup of the projects folder backs up all data as long as the project is closed.
• Copy the files to a CD-ROM or to a Zip drive.
• You can restore these files, if needed, using the Windows Restore command.

4. Restart the database server using Microsoft SQL Service Manager. To do this:

• Invoke Programs/Microsoft SQL Server/Service Manager.
• In the Service Manager window, click the "Start" button.