Create Forest Database

Languages:

[[::Create Forest Database|English]]  • [[::Create Forest Database/sv|svenska]]

A "Restore"-procedure, executed in SQL Server Management Studio to create a local forest database, is described here. A corresponding functionality is now available in PlanStart. In both cases the SQL Server software needs to be installed on the computer, while the built-in functionality seems to be compatible only with SQL Server 2005.

1. Start PlanStart
2. Select "Create Database Forest" from the "Tools" menu
3. Click the "Browse"-button and select the directory where the backup file is located, eg C:\TEMP\.
4. Select the backup file and click "Open". Note: Windows Vista may be sensitive to where the backup file is put, because SQL Server in Vista has restricted reading access. Anyhow, C:\temp\ should be OK.
5. Enter the server name under the "Server":
6. # If you have installed the free version, SQL Server 2005 Express, enter "localhost\SQLExpress"
7. # If you have the commercial version of SQL Server, enter "localhost" if you install the database locally, or the server name if you are installing on a remote server.
8. If you install locally, leave "Authentication" mode equal to "Windows authentication".
9. In "Database name", type a database name (without blanks)
10. Click the "Browse ..."-button next to "Location of data file", and specify a location where you want to save the database. See (4) above concerning problems with Vista.
11. Click on "Create Database" and wait until ready.