Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jaugwar
Starting Member
6 Posts |
 Posted - 2011-08-27 : 23:27:51
|
| 1. What are VB Nuggets, SQL Nuggets and Web Nuggets?2. Why and When do we use SQL Server 2005 Prod, test and dev instanceand how do we create instance?jackson |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2011-08-28 : 02:41:54
|
| An SQL Server instance is a complete SQL server and you can install multiple instances on a server . An SQL Server instance has its own copy of the server files, databases and security credentialsOnly 1 default instance is possible on a serverThe idea of maintaining - Dev,Test , Prod environments is to develop, test and have a Production copy. To install a SQL Server instance - check SQL Server Book online - Jack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
jaugwar
Starting Member
6 Posts |
Posted - 2011-08-28 : 11:59:40
|
| Thank you Jackjackson |
|
|
|
|
|
|
New to SQL Server 2005