Generally speaking, consolidation refers to the process of combining multiple things to make a single, more  effective unit. In an IT context, you can consolidate several types of things, including physical servers, SQL Server instances, storage, and locations.

This Consolidation Guide is the first in a series of documents that will provide concepts, procedures, and hard performance data that will help you successfully consolidate your Microsoft® SQL Server® 2000 and SQL Server 2005 databases from multiple machines onto a single SQL Server 2008 server system. In this Guide, we use the Dell™ PowerEdge™ 2950 as a target server.

Already a Bitpipe member? Login here

Download this White Paper!

• Corporate E-mail Address:

  You forgot to provide an Email Address.

  This email address doesn’t appear to be valid.

  Please provide a Corporate E-mail Address.

  This email address is already registered. Please login.

• First Name:

  You forgot to provide your first name.

• Last Name:

  You forgot to provide your last name.

• Company Name:

  You forgot to provide a company name.

• Job Title:

  You forgot to provide a job title.

• Seniority: C-Level / Executive Team EVP / SVP / VP / AVP Director Manager Architect Analyst Staff

  You forgot to select your seniority.

• Job Function:

  You forgot to select your job function.

• # of employees: Select number of employees... 100,000+ 50,000 to 99,999 25,000 to 49,999 10,000 to 24,999 5,000 to 9,999 1,000 to 4,999 500 to 999 250 to 499 100 to 249 50 to 99 1 to 49

  You did not select the number of employees at your company.

• Industry: Select... Agriculture/Forestry Architecture and Engineering Automotive Aviation & Aerospace Biotechnology Business services Civic & Social Organization Construction Consumer Goods & Services Education Electrical/Electronic Manufacturing Financial/Banking Government & Public Policy Healthcare/Health services Insurance Legal services Manufacturing/Industrial Oil/Gas/Mining/Other natural resources Outsourcing/Offshoring Pharmaceuticals Photography Publishing/Broadcast/Media Real Estate Recreation/Entertainment Research and Consulting Retail Technology Transportation/Distribution Travel/Hospitality Utilities Veterinary Wholesale Wireless

  You did not select which industry you are in.

• You did not select which industry you are in.

• Address 1:

  You did not provide a full local address.

• Address 2:
• City/Town:

  You did not provide a full local address.

• Country: Select... Afghanistan Aland Islands Albania Algeria American Samoa Andorra Angola Anguilla Antarctica Antigua and Barbuda Argentina Armenia Aruba Ashmore and Cartier Islands Australia Austria Azerbaijan Bahamas Bahrain Bangladesh Barbados Belarus Belgium Belize Benin Bermuda Bhutan Bolivia Bosnia and Herzegovina Botswana Bouvet Island Brazil British Indian Ocean Territory Brunei Darussalam Bulgaria Burkina Faso Burundi Cambodia Cameroon Canada Cape Verde Cayman Islands Central African Republic Chad Chile China Christmas Island Clipperton Island Cocos (Keeling) Islands Colombia Comoros Congo Congo, The Democratic Republic of the Cook Islands Coral Sea Islands Costa Rica Cote D'Ivoire Croatia Cuba Cyprus Czech Republic Denmark Djibouti Dominica Dominican Republic Ecuador Egypt El Salvador Equatorial Guinea Eritrea Estonia Ethiopia Falkland Islands (Malvinas) Faroe Islands Fiji Finland France French Guyana French Polynesia French Southern and Antarctic Lands Gabon Gambia Gaza Strip Georgia Germany Ghana Gibraltar Greece Greenland Grenada Guadeloupe Guam Guatemala Guernsey Guinea Guinea-Bassau Guyana Haiti Heard and McDonald Islands Holy See (Vatican City State) Honduras Hong Kong Hungary Iceland India Indonesia Iran Iraq Ireland Isle of Man Israel Italy Jamaica Jan Mayen Japan Jersey Jordan Kazakhstan Kenya Kiribati Korea, North Korea, South Kuwait Kyrgyzstan Laos Latvia Lebanon Lesotho Liberia Libya Liechtenstein Lithuania Luxembourg Macau Macedonia, The Former Yugoslav Republic of Madagascar Malawi Malaysia Maldives Mali Malta Marshall Islands Martinique Mauritania Mauritius Mayotte Mexico Micronesia, Federated States of Moldova Monaco Mongolia Montenegro Montserrat Morocco Mozambique Myanmar Namibia Nauru Nepal Netherlands Netherlands Antilles New Caledonia New Zealand Nicaragua Niger Nigeria Niue Norfolk Island Northern Mariana Islands Norway Oman Pakistan Palau Panama Papua New Guinea Paraguay Peru Philippines Pitcairn Islands Poland Portugal Puerto Rico Qatar Reunion Romania Russia Rwanda Saint Barthlemy Saint Helena Saint Kitts and Nevis Saint Lucia Saint Martin Saint Vincent and the Grenadines Samoa San Marino Sao Tome and Principe Saudi Arabia Senegal Serbia Seychelles Sierra Leone Singapore Slovakia Slovenia Solomon Islands Somalia South Africa South Georgia and the Souths and Wich Islands Spain Sri Lanka St. Pierre and Miquelon Sudan Suriname Svalbard and JanMayen Islands Swaziland Sweden Switzerland Syria Taiwan Tajikistan Tanzania Thailand Timor-Leste Togo Tokelau Tonga Trinidad and Tobago Tunisia Turkey Turkmenistan Turks and Caicos Islands Tuvalu Uganda Ukraine United Arab Emirates United Kingdom United States United States Minor Outlying Islands Uruguay Uzbekistan Vanuatu Venezuela Vietnam Virgin Islands (British) Virgin Islands (U.S.) Wallis and Futuna Islands West Bank Western Sahara Yemen Zambia Zimbabwe

  You did not select the country you are from.

• State/Province:

  You did not provide a full local address.

• Zip/Postal Code:

  You did not provide a full local address.

• Phone:

  You forgot to provide a phone number.

  This phone number format is not recognized. Please check the country and number.

• • I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.

  Please check the box if you want to proceed.

• • I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.

  Please check the box if you want to proceed.

By submitting my Email address I confirm that I have read and accepted the Terms of Use and Declaration of Consent.