Post reply

Create New Instance SQL Server database Engine

  • August 8, 2011 at 5:23 am

    #149568

    Hello Friends,

    Please tell me how to create a new instance of sql server?

    by using command prompt..

    Thanks!!

  • August 8, 2011 at 5:27 am

    #1365100

    an new instance is a complete installation, so you would have to run or re-run the MSI and explicitly give the name of the new instance...\SQL2005 or \SQLEXPRESS are commone ones you might have seen.

    if you were doing this a large number of times, it's possible to create a config file that you pass to the msi with answers to all the prompts. I'm never done it, and would highly recommend just stepping through the half dozen or so screens manually anyway.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply