Shrink Datebase
Hi,
is there any Option to shink the System Database on our SQL-Server
The database has an size over 1 GB and a search from the Reprint Console fails often with timeouts.....
Regards, Dirk
-
Shotaro Ito
★ BarTender Hero ★
Hi,
BarTender system database's maintenance wizard doesn't shrink database - as shrink of database may cause serious performance drop.
Since it is SQL server, you can install SQL server Management Studio and manage the database - backup, shrink etc.
the latest BarTender 10.1 SR4 supports SQL Server 2014 - Free version of SQL Server 2014 allows max database size of 10GB.
Microsoft SQL Server 2014 Expresshttp://msdn.microsoft.com/en-us/evalcenter/dn434042.aspx
Shrink a Database
0 -
Hi,
thank you for your Response. That is not exactly what i mean. I search a solution to throw older entrys out from the Database.
Delete all entry older than x Months......
Regards, Dirk
0 -
You can do this by:
- Starting BarTender.
- Accessing the "Administer > Log Setup" Menu.
- Choosing the "Database Log" tab and clicking on "Setup..."
- Selecting the "Maintenance" tab and clicking on "Maintenance Options".
- Configure the BT System Database maintenance as desired.
0
Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.
Kommentare
3 Kommentare