Jump to content

Build 9493 Database Management


support
 Share

Recommended Posts

When you upgrade to build 9493, this version support Unicode characters, which can make your database grow by a large amount.  Best practice is to shrink the database and log files after you upgrade to free up space.  You should also check you have plenty of disk space on your database server prior to upgrading, as your database may grow to be 300% – 400% in size. An example of this is if your database is 500mb in size, it’s possible this can grow to 2gig and it will consume that much disk space on your database server.  

 

Prior to upgrading also ensure you have not capped the Autogrowth for your Passwordstate database as it's unpredictable how much it will need to grow during the upgrade process.  To find out if your growth of your database has been capped, and also what drive your database is located on, see screenshot below:

 

 2022-05-04_8-01-38.png

Shrinking the database can be done in one of two ways:

 

Option 1:

Open SQL Management Studio Tools and connect to your database server using an account that full access to your Passwordstate database, and run the following SQL Code:

 

DBCC SHRINKDATABASE (Passwordstate)

 

You should see some results similar to the screenshot below, and this means it’s executed well:

2022-04-23_8-17-19.png

 

 

Option 2:

You can shrink the database and the log files using the UI of SQL Management Studio Tools.  Please see section 15 of this guide if you’d like to follow this option:  https://www.clickstudios.com.au/downloads/version9/Installation_Instructions.pdf

 

Regards,

Support

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...