J
jremmc
We are going to get a new 64-bit W2K8-SQL 2008 server. We want to move our
MOPS/WSS databases to that server from 32-bit W2K3-SQL 2000 SP4. We have a
two-tier farm with a single web/app server. What would be a good method to
move the databases and configure MOPS to point to the new SQL server? We want
to move the configuration databases as well as the content databases; can
that be done?
We can turn the MOPS server physically off during the entire database move
process. To move the databases, we have Backup Exec's SQL Agent so we can do
a backup/redirected restore then sp_attach, and we can also shut down the SQL
services for a flat file copy then sp_attach. My concern is the process to
point MOPS to the new SQL server. How, at what point do we do that, and with
what tool (Central Admin? psconfig command?) while ensuring no unsync with
config databases.
Also, what about Analysis Services? We have SQL Analysis Services 2000 and
followed that TechNet article for installing and getting AS to work with
MOPS. I found the SQL 2008 TechNet article (and note/blog about using the
December 2008 Feature Pack for SQL 2005 instead of the February 2007
version). Should we uninstall the SQL 2000 components first from the MOPS
server before installing the SQL 2005/SQL 2008 components?
Any help appreciated.
Thanks,
jremmc
MOPS/WSS databases to that server from 32-bit W2K3-SQL 2000 SP4. We have a
two-tier farm with a single web/app server. What would be a good method to
move the databases and configure MOPS to point to the new SQL server? We want
to move the configuration databases as well as the content databases; can
that be done?
We can turn the MOPS server physically off during the entire database move
process. To move the databases, we have Backup Exec's SQL Agent so we can do
a backup/redirected restore then sp_attach, and we can also shut down the SQL
services for a flat file copy then sp_attach. My concern is the process to
point MOPS to the new SQL server. How, at what point do we do that, and with
what tool (Central Admin? psconfig command?) while ensuring no unsync with
config databases.
Also, what about Analysis Services? We have SQL Analysis Services 2000 and
followed that TechNet article for installing and getting AS to work with
MOPS. I found the SQL 2008 TechNet article (and note/blog about using the
December 2008 Feature Pack for SQL 2005 instead of the February 2007
version). Should we uninstall the SQL 2000 components first from the MOPS
server before installing the SQL 2005/SQL 2008 components?
Any help appreciated.
Thanks,
jremmc