Given than once SQL Server 2005 is installed, SQL Server Studio has tobe used instead of Enterprise manager, can both SQL 2000 and 2005 beused on the same machine, be it development or production? (The secondone to be installed probably would be a named instance.)
Any experiance of doing this or a pointer to a Microsoft recommendation would be appreciated.
The SQL Server 2005 Books Online (downloaded version) has a section onWorkingwith Multiple Versions of SQL Server which indicates that SQL 2005 canbe installed as a named instance alongside SQL Server 7 and/or SQLServer 2000.
Some feedback from where this has been done would be very much appreciated.
|||From various training material for SQL 2005, it would seem that it ispreferable to have at least 512 Mb of RAM above that required by theoperating system. Whilst it will install (with protest) on a machinewith a total of 256 Mb RAM, a minimum realistic amount of memory forits host server would be 1 Gb of RAM.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment