Jan 28 2008 8:00AM GMT
Posted by: mrdenny
SQL,
Installation,
SQL Server 2005,
SQL Server 2000
You can install SQL 2000 and SQL 2005 on the same machine. I always recommend that they be installed in this order to try and get everything working as best as possible.
- Install SQL 2000
- Install SQL 2005
- Install SQL 2000 SP4 (Or the latest service pack)
- Install SQL 2005 SP2 (Or the latest service pack)
Denny
Dec 3 2007 8:00AM GMT
Posted by: mrdenny
Beta,
CLR,
Installation,
SQL Server 2008
We’ll I’ve finely gotten around to installing the SQL 2008 November CTP. While walking through the installer I have seen some excellent changes. Not only is the option to change the paths of the data files no longer hidden, there are more than just two options. There are at least 7 paths that you get to specify while installing. The first one is the Shared component directory. This appears to be the base path where all your binarys will be based off of.
Next you get the Instance root directory. This is where the system database files will be based off of, so make sure that you don’t point this to the C drive is you want the system databases on another drive.
A couple of screens later you get to set 6 install paths. The first is the data root directory. This changes the base path for all the others options. The others are the User database folder, user log database folder, tempdb data folder, tempdb log folder, and the backup directory.
This amount of flexability in the installer is a first, and it’s a welcome change. Look for more posts, tips and articles about SQL Server 2008 in the comming weeks and months up till the release.
Denny