Connect an existing window sharepoint services to SQL 2000

[sparky11]

Hello,

I have window sharepoint services and SQL 2000 database installed in different machine. How can I move that database into the same machine with WSS?

Thank you very much for your help.

Dong

 

[Thomas2000]

Hello,

I would do it like this (might be a better way)

1. Install SQL2000 on the machine with WSS.
2. Make a full/complete backup of existing SQl databases
3. Restore the databases onto the WSS machine.
4. Go to SharePoint Central Administration and change the location of Default Configuration Databse and Default Content database.

Just make sure that you leave the "old" database server untouched until you are sure that your sites work properly with your new SQL database.

However having the WSS and SQL on the same machine is not a solution I would recommend since it will have a large impact on the performance of the server. SQL can become very memory intese and also WSS takes some amount of memory depending on how many virtual servers and sites you have on it.

Regards,
Thomas

 

[sparky11]

Hello Thomas,

WSS is very new to me, we just installed WSS last week.
Currently WSS and SQL are in the different machine but on WSS has 200GB and SQL only has 12GB. Do you think it is better if I move SQL into WSS?

Thanks much
Dong