Home Forums SQL Server 2005 SQL Server 2005 General Discussion create another instance but will be the same DB name on same server RE: create another instance but will be the same DB name on same server

  • July 25, 2013 at 11:53 am

    #1635857

    Thanks Elliott for quick response as i need to do it today.

    1) When i install sql 2005 on same server, i can leave the default instalaltion, right?

    2) We have only two drive c and D and on D drive we have data file and log file

    Is it my data file name having an issue if i specify the directory D:\?

    You can have 2 instances on the same IP with the same databases BUT the instance name will have to be different, your current setup is DBDEV, you can create an instance with any other valid name.

    ServerName\DBDEV

    ServerName\DBDEV2

    They are two entirely separate SQL servers so having the same Database name on each is just fine. They will be at different places on disk as well. Does this make sense