MOSS 2007:
Hi,
We have a small sharepoint farm in our company with an Application and a dtabase server running SQL Server 2000.
We are planning to migrate the database to a different server running SQL 2005. I have gone through many forums and blogs and it has become very confusing. Some of them say, we have to run the Configuration wizard and to create a new server farm altogether.
Some says, the SSPs have to be backed up and resotred differently.
Has anybody faced the same situation and moved the databases (contnent, configuration, SSP) from SQL 2000 to SQL 2005 this way? Are these steps documented anywhere in MSDN or any other site?
Thanks,
Nayana