Difference between revisions of "Create Forest Database"

From Heureka Wiki
Jump to navigation Jump to search
 
(11 intermediate revisions by 2 users not shown)
Line 1: Line 1:
−
A "Restore"-procedure, executed in SQL Server Management Studio to create a local forest database, is described [[Install_SQL_Server_Express|here]]. A corresponding functionality is now available in PlanStart. In both cases the SQL Server software needs to be [[Install SQL Server | installed]] on the computer, while the built-in functionality seems to be compatible only with SQL Server 2005.
+
{{Languages}}
  
−
# 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.
 
  
 +
See http://heurekaslu.org/help/en/index.html?skapa_databas.htm
 +
 +
<!--
 +
 +
See also [[Install Existing Database]]
 +
 +
# Start StandWise, PlanWise or RegWise.
 +
# Select "Create Forest Database" from the "Data Management" menu
 +
# Enter the server name under "Server":
 +
## If you have the free version, SQL Server 2005 Express, enter "LOCALHOST\SQLEXPRESS" if you are about to install the database locally
 +
## If you have the commercial version of SQL Server, enter "LOCALHOST" if you are about to install the database locally
 +
## If you are about to install the database on a remote server, enter the remote server name
 +
# If you install locally, leave "Authentication" mode equal to "Windows Authentication"
 +
# In "Database name", enter a database name (without blanks)
 +
# Check "Include demo data" if you want to create a database with some demonstration data. Leave it unchecked to create an empty database
 +
# Click the "Create Database"-button and await success
 +
 +
''NB: The folder where the forest database is locally stored (e.g., C:\PROGRAM\MICROSOFT SQL SERVER\MSSQL10.MSSQLSERVER\MSSQL\DATA) can not be in "Compression mode". Right-click the DATA folder, select "Properties" and "Advanced settings..." and make sure "Compress content..." is unchecked.''
 +
 +
[[Category:Reference Manual]]
 
[[Category:Software]]
 
[[Category:Software]]
 
[[Category:Install]]
 
[[Category:Install]]
 
[[Category:Database]]
 
[[Category:Database]]
 +
 +
-->

Latest revision as of 12:36, 17 November 2014

Languages Languages: 

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


See http://heurekaslu.org/help/en/index.html?skapa_databas.htm


Retrieved from "https://www.heurekaslu.se/w/index.php?title=Create_Forest_Database&oldid=7243"