Post reply

SQL SERVER INSTANCE

  • August 31, 2009 at 4:08 am

    #225554

    Hi friends,

    Here are some doubts regarding the Instances in SQL Server.

    1) Is there any effect to the processor (or) existing application performnce if a new instance was created on a machine.

    2) I am having a scenerio as follows: There are two servers like DEV and PRODUCTION. I need to move a DB from DEV to PROD , for this i am going to create a another instance on the PROD server. Suppose if my DB name on DEV is same as one of the DB present on the PROD, is it causes any conflict at the time of restoring a DB on PROD.

    Thakns in advance,

    Venu Gopal.K
    Software Engineer
    INDIA

  • August 31, 2009 at 4:19 am

    #1046777

    Hello Venu

    for the second answer when you restoring the db in PROD you can change the name of the db in the combo that appear in the restore window.

    For the first answer i don't know.

  • August 31, 2009 at 4:26 am

    #1046783

    Thank you for your kind answer,

    What i really need is, Is there any option of creating the two dabases having the same name but of different Instances?

    Venu Gopal.K
    Software Engineer
    INDIA

  • August 31, 2009 at 6:24 am

    #1046819

    hi

    the question u are asking is this

    creating a new mdf/ldf pair which is detached from the server after its created.

    then for that answer is yes

  • August 31, 2009 at 6:27 am

    #1046824

    If it is

    Please chek the information u required in this article

    http://social.msdn.microsoft.com/forums/en-US/sqlexpress/thread/1747b70d-5cd5-48cc-a25e-a334ec7f755e/

    Regards

    sat

  • August 31, 2009 at 6:44 am

    #1046833

    1) The only effect is that the processor is shared among the instances.

    2. Yes, the instances are serarate. They both have a master db, and they can both have a sales db as well.

Viewing 6 posts - 1 through 5 (of 5 total)

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