Restore SharePoint production content database to test environment

The other day we updated our system test environment based upon SharePoint 2007 with data from production for one of our customers.

The system test was already installed and we wanted to update to a more recent version. There are many different ways to do it if you ask around some more cumbersome than others. The following list is the simple steps that we took to get it up and running with new production data in system tes environment.

1. Backup database in production and copy backup file to system test
2. In system test envirionment go into "Central Administration > Application Management > Content Databases > Manage Content Database Settings" check remove and save
3. Shut down sharepoint services
4. Restore database with replace checkbox filled in SQL Server Management Studio
5. Start sharepoint services
6. In Central administration add content db
7. Change site collection owner in the central administration for the wanted site collection.
8. Make a new content crawl in SSP site to enable search

Thats all :)

Happy config