Monday, March 26, 2012

Installing SQLServer2005 but Preserve Current SQLServer2000

I have a default installation of SQLServer2000 on a host running
Win2003. I want to install SQLServer2005 on the same machine, but
preserve the original SQLServer2000 installation. How do I do this --
install into new directory? new directory and named instance? just
new named instance? What stumbling blocks could I run into?red_valsen@.yahoo.com wrote:

Quote:

Originally Posted by

I have a default installation of SQLServer2000 on a host running
Win2003. I want to install SQLServer2005 on the same machine, but
preserve the original SQLServer2000 installation. How do I do this --
install into new directory? new directory and named instance? just
new named instance? What stumbling blocks could I run into?


I believe new directory and named instance is necessary and sufficient.|||2005 will work side-by-side with 2000 as a named instance. Just note
that there is no Microsoft tool to migrate a database back to 2000.

You will want to set a different data/backups folder - e.g. \mssql2005.

* * * * * * * * * * * * * * * * * * * * * *

red_valsen@.yahoo.com wrote:

Quote:

Originally Posted by

I have a default installation of SQLServer2000 on a host running
Win2003. I want to install SQLServer2005 on the same machine, but
preserve the original SQLServer2000 installation. How do I do this --
install into new directory? new directory and named instance? just
new named instance? What stumbling blocks could I run into?

No comments:

Post a Comment