Install database

Languages:

[[::Install database|English]]  • [[::Install database/sv|svenska]]

Create new or demo database

PlanStart version 1.0.3 and later lets you create a database automatically.

Install existing database

You can install an existing database either locally on localhost or on a central server (like server1.mycompany.com). It is assumed that you have installed or have access to SQL Server.

Prerequisite: A backup file (. Bak) from an existing database. Use the "Restore" function i SQL Server Management Studio to install the database:

1. Open Management Studio. Enter the server name (localhost, localhost\SQLExpress, or the server name).
2. Right click on "Databases", select "New Database ..." and enter a name for the new database (no blanks or spaces)
3. Right-click the new database, select "Tasks" > "Restore" > "Database ...".
4. As the source, select "From device" and "..."-button. Click "Add", and locate the backup-file.
5. Check "Restore" for both files (including log-file if it exists)
6. In "Options", select "Overwrite ..." and change the "Restore as ..." to valid paths (folders must exist on your computer if you install locally, and on the server if you install on a remote server.

Alternative: Install an .mdf file via the "Attach"-option in SQL Server Management Studio.

This alternative is available if you have an -mdf-file instead of a backup (.bak) file.

1. Open Management Studio. Enter the server name (localhost, localhost\SQLExpress, or the server name).
2. Right click on "Databases", select "New Database ..." and enter a name for the new database (no blanks or spaces)
3. Right click on "Databases" and select "Attach".
4. Click "Add" and select the .ndf file.
5. In the "Database details', check and if necessary edit the file path to valid ones.