Difference between revisions of "Install database"

From Heureka Wiki
Jump to navigation Jump to search
 
(2 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
{{Languages}}
 
{{Languages}}
  
 +
See http://heurekaslu.org/help/en/index.html?skapa_databas.htm
 +
 +
 +
<!--
 
==Create new or demo database==
 
==Create new or demo database==
 
PlanStart version 1.0.3 and later lets you [[Create Forest Database | create a database]] automatically.
 
PlanStart version 1.0.3 and later lets you [[Create Forest Database | create a database]] automatically.
Line 9: Line 13:
  
 
'''Prerequisite''': A backup file (. Bak) from an existing database.
 
'''Prerequisite''': A backup file (. Bak) from an existing database.
Use "Restore" function i SQL Server Management Studio to install the database:
+
Use the "Restore" function i SQL Server Management Studio to install the database:
 
# Open Management Studio. Enter the server name (localhost, localhost\SQLExpress, or the server name).
 
# Open Management Studio. Enter the server name (localhost, localhost\SQLExpress, or the server name).
 
# Right click on "Databases", select "New Database ..." and enter a name for the new database (no blanks or spaces)
 
# Right click on "Databases", select "New Database ..." and enter a name for the new database (no blanks or spaces)
Line 17: Line 21:
 
# 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.
 
# 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:''' Installing an .mdf file via the "Attach"-option in SQL Server Management Studio ==
+
'''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.
 
This alternative is available if you have an -mdf-file instead of a backup (.bak) file.
 
# Open Management Studio. Enter the server name (localhost, localhost\SQLExpress, or the server name).
 
# Open Management Studio. Enter the server name (localhost, localhost\SQLExpress, or the server name).
Line 29: Line 34:
 
[[Category:Install]]
 
[[Category:Install]]
 
[[Category:Database]]
 
[[Category:Database]]
 +
 +
-->

Latest revision as of 13:36, 17 November 2014

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