How to shrink the PlateSpin Protect, Migrate, and Forge databases

  • 7006458
  • 16-Jul-2010
  • 05-May-2016

Environment

PlateSpin Forge 
PlateSpin Protect 
PlateSpin Migrate 

Situation

PlateSpin Migrate and Protect are provided with SQL 2005 Express as a database back-end. This version of SQL has a limitation of 4GB per database file (.mdf).

This article outlines how to manually clean up and shrink the database file(s) if they grow too large.

These instructions can also be used to shrink the databases on remote SQL installations and on PlateSpin Forge 3.x.

Resolution

PlateSpin.DBCleanup.exe, the database cleanup tool, is located in \PlateSpin [Protect\Migrate] Server\bin. This tool cleans up the unnecessary entries within the database files, it can shrink the actual .mdf and .ldf files on the file system. The instructions below include steps to shrink the files after cleaning them up.

PlateSpin.DBCleanup.exe

/help                     - Show extended help

/info                     - See database usage information

/clean     - Purge Jobs

/shrink     - Shrinks the databases after cleanup

/truncatelog     - Truncates the transaction logs (/shrink option required)

/days     - Allows the user to specify the number of days to retain (/clean option required)


 

To clean up the database files:

1. Open a command prompt and navigate to \PlateSpin [Protect\Migrate] Server\bin.

2. Run PlateSpin.DBCleanup.exe /clean /days={Number of days to retain}

3. The command will execute and display the results in the command window.
 
The protection database will automatically be included in this if Forge or Protect are installed.

To shrink the database files:


1. Connect to SQL using SQL Studio Management Express

2. Expand databases.

3. Right-click ofx and select Tasks --> Shrink --> Database.

4. A confirmation window will appear, click OK.

5. Repeat steps 3 and 4 for the portabilitysuite database.

6. Check the database files (default location \PlateSpin [Protect\Migrate] Server\Database) to confirm the shrink was successful.







Feedback service temporarily unavailable. For content questions or problems, please contact Support.