Skppani (6/2/2013)
I can place it in the same machine where my production server is available but as a different instance..?
Do you want the testing to impact your production server's performance? Do you want deployment errors to possibly break your production database? If yes, then sure put them on the same server.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability