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 12:53 pm

    #1635878

    poratips (7/25/2013)

    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:\?

    I know that SQL 2008 and above knows about other installs on the server, I THINK SQL 2005 does as well, it should make you chose a different instance name which will cause it to install in a different path. This is all good. Under NO circumstances use the same path for user databases between the two instances. Each instance should use different paths. The instances can share the same drive, but keep in mind they will fight each other for disk resources.

    CEWII