Post reply

Multiple instances

  • October 1, 2015 at 8:41 am

    #303575

    Hi, great forum first of all, i've been reading stuff here for awhile.

    I will say i'm not a DBA, which is the reason for my question. I know we can install multiple instances of SQL 2008r2 on the same box, but will doing so also create separate temp files? We need a certain collation, which happens to be different from the default one now, I've tried searching M$ for that but wasn't successful.

    thanks in advance,

  • October 1, 2015 at 8:46 am

    #1830801

    Yes you can install multiple instances of SQL Server on the same machine, those would be named instances. And yes each one will need its own database and log files including the tempdb files.

  • October 1, 2015 at 8:49 am

    #1830803

    That's what I thought thanks!

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

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