November 8, 2007 at 2:00 pm
Hi Everyone,
I have MS SQL Server 2000 Standard Edition installed on the server.
I would like to create another instance which will be exact copy of the default one.
Can I install on the same partition? How?
Does Standard License allow us to install multiple instance?
Thanks,
Regards
November 8, 2007 at 11:29 pm
Well, quick answer is yes...
install a named instance of SQL 2000 on a server with an existing instance and define where you want files to be placed, whichever disk partition you choose.
Regarding maximum number of instances, or liscencing...
http://msdn2.microsoft.com/en-us/library/aa933149(SQL.80).aspx
also... check this page out... but haven't validated any statements
http://www.altoimaging.com/AltoWeb/Products/ContentMgmt/SQL_LicenseInfo/20Seat-SQLServer-License.htm
Todd Carrier
MCITP - Database Administrator (SQL 2008)
MCSE: Data Platform (SQL 2012)
November 8, 2007 at 11:31 pm
to make exact copy of default instance..
install named instance...
restore master db, other sytem dbs, followed by user dbs on name instance
Todd Carrier
MCITP - Database Administrator (SQL 2008)
MCSE: Data Platform (SQL 2012)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply