We have a custom console application (using Sharepoint API) for SharePoint 2007, which adds users and updates user profile properties for users.
As part of the release we want to take a backup of the user profile store to restore if required.
We have a very large farm (approx. 1TB databases, 10000 users).
Do we only need to backup the default SSP database and restore if it fails?
A lot of MS information recommends doing SharePoint backups by backing up databases. Does this apply to the SSP database too?