Thursday, July 28, 2016

Backups for Windchill Quality Solutions 10.2+

I had a failed hard drive recently and with it a corrupted back up. It turns out that Relex / WQS files are not easily saved like a simple .file or .proj it turns out you need to make a backup of your SQL database that was created for Relex. You need to make sure when you installed SQL Server EXPRESS you also installed the management studio tools. If you didn't download the SQL Server Management Studio (SSMS). Sign in with the sa account, or if you forget you might be able to with windows credentials. Expand the Databases heading. Right-click on the database to be migrated and choose Tasks > Back Up. On the Back Up Database window make sure the Backup Type is set to Full. Lastly make sure to actually set a file name / location in by clicking [Add...] intuitively they don't have an automatic name for the .bak setup, so without it you can't actually create the backup. I'd recommend committing this .bak file somewhere safe because without it a migration to a new system is a horrible process.

Once again I'd still like to make note that PTC has excellent support.

No comments:

Post a Comment