Changes

== Configuration All content and configuration data of SQL database ==[{{UBIK}} is managed in a [Filehttp:UI_MSSQL//www.png|thumb|alt=Alt text|Connect to MS microsoft.com/en-us/sqlserver/default.aspx Microsoft SQL Management Studio]] [[File:UI_RestoreDB.png|thumb|alt=Alt text|Restore database]]* Microsoft SQL Server (2008 R2or newer). Once the SQL server engines is installed successfully, an administrator can set up a new {{UBIK}} database simple using the available release database.

# Copy the file ''UBIK[[File:UI_SettingUpUBIKDatabase_01.RELEASE.bak'' to the local drivepng|thumb|alt=Microsoft SQL Server Management Studio|Microsoft SQL Server Management Studio]]== Setting up {{UBIK}} database ==# Start the application MS ''Microsoft SQL Server Management Studio '' and connect to the database server# Navigate to "''Databases" '' and add a new right click on ''Databases''&rarr; select ''New database...''# Choose "Right click on the newly created database and choose ''Tasks / &rarr; Restore / &rarr; 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" flagDatabase.PNG| 440px|border]]# Switch to the options-slider and check "''Overwriting actual data"'' (if necessary)# Finish the process by clicking the "{{key press|OK"}}

{{Attention|Use maintenance plans for periodic backup of your own and the system databases!}} == Requirements ===== Database user ===The database user configured in {{UBIK}} Studio used to connect to the database needs* to have the role ''sys.admin'' assigned* to be marked as ''Database owner'' (dbo) of the according {{UBIK}} database === Windows firewall ===For a non-local SQL server make sure that the SQL server port (default: 1433) is unlocked by the Windows firewall Inbound and Exbound rules. == See also ==* [[FAQ:Installation_and_Configuration#Network|FAQ: Installation and Configuration / Network]] [[Category:How-To|Install UBIK StudioDatabase]][[Category:ConfigurationInstalling|Install UBIK Database]]