All content and configuration data of {{UBIK}} is managed in a [http://www.microsoft.com/deen-deus/serversqlserver/default.aspx Microsoft SQL] database (2008 R2 or newer). Once the SQL server engines is installed successfully, an administrator can set up a new {{UBIK}} database simple using the available release database.
[[File:UI_SettingUpUBIKDatabase_01.png|thumb|alt=Microsoft SQL Server Management Studio|Microsoft SQL Server Management Studio]]
== Setting up {{UBIK}} database ==
# Start the ''Microsoft SQL Server Management Studio'' and connect to the database server
# Navigate to ''Databases'' and add a new right click on ''Databases''→ select ''New database...''# Choose Right click on the newly created database and choose ''Tasks → Restore → Database'' from the context menu
## Choose the newly created database in the setting ''In database''
## Choose the copied backup file in ''From media''
## Check ''Restore'' of the according backup set<br/> [[File:Restore Database.PNG| 440px|border]]
# Switch to the options-slider and check ''Overwriting actual data'' (if necessary)
# Finish the process by clicking {{key press|OK}}
{{HintAttention|'''Use maintenance plans for periodic backup of your own and the system databases!'''}}
== Requirements ==
=== Windows firewall ===
Make For a non-local SQL server make sure that the SQL server port, (default : 1433, ) is unlocked on by the Windows firewallInbound and Exbound rules. == See also ==* [[FAQ:Installation_and_Configuration#Network|FAQ: Installation and Configuration / Network]]
[[Category:How-To|Install UBIK Database]][[Category:Installing|Install UBIK Database]]