Using pre-installed SQL Server Express and specify database location
We are using BT 2022 R8 and have SQL Server Express 2022 installed on the same server. Now I noticed, that even though the default user database directory in SQL Server is set to a folder on the D: drive, the Datastore database for BarTender is still installed on the C: drive. Therefore I have to do an extra step and move the database files to the intended D drive before I can resume the configuration.
The available documents about silent installation of BarTender do not mention an option to specify the database location.
Is there a way to do this right? Can I create an empty Datastore DB first, before installing BarTender and let it just create the tables and other components?
Any advice is much appreciated!
Cheers, Harry
-
Peter Thane
★ BarTender Hero ★
I believe unless you are using BarTender Enterprise the System Database needs to be a local install. You would need to use the Administration Console settings to adjust the config of this and link to a remote System Database
0 -
Harald Rauch
★ BarTender Hero ★
Hi Peter Thane and thanks for your reply,
We use Enterprise but we keep everything local to ensure continued production in case of a WAN failure.
My question was, why the default location of the database files in SQL Server is not respected when creating the Datastore database. The file path is probably hard-coded in the database-create script. And the scripts they provide to create your own database in "C:\Program Files\Seagull\BarTender 2022\Database" don't seem to match the implicit database setup either.
Nevermind, i'll run the standard installation and then move the database files manually to the D drive, so our system admins are happy.0 -
Hari Daddham
★ BarTender Hero ★
Hi Peter/Harald,
Please guide us on the manual copy of the database files to another Drive (Other than OS Drive).
0 -
Harald Rauch
★ BarTender Hero ★
Hi Hari Daddham
this is a standard action for a database administrator and you can find many articles about it on the internet.
For instance this one https://www.mssqltips.com/sqlservertip/6689/sql-server-move-database-files/ which I used to create my script.
Best wishes,
Harry Rauch
0 -
Peter Thane
★ BarTender Hero ★
It would probably be best if you just googled how to move an SQL database to a new location to be honest.
Once you have done that you would then need to open Administration Console and the System Database option and reconfigure where it is now saved, although as mentioned above only the Enterprise edition can interact with a remote System Database this needs to be local for all other editions
0
Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.
Kommentare
5 Kommentare