Create Forest Database
Jump to navigation
Jump to search
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.
- Start PlanStart
- Select "Create Database Forest" from the "Tools" menu
- Click the "Browse"-button and select the directory where the backup file is located, eg C:\TEMP\.
- 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.
- Enter the server name under the "Server":
- # If you have installed the free version, SQL Server 2005 Express, enter "localhost\SQLExpress"
- # 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.
- If you install locally, leave "Authentication" mode equal to "Windows authentication".
- In "Database name", type a database name (without blanks)
- 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.
- Click on "Create Database" and wait until ready.