Tagged Questions
2
votes
1answer
346 views
SQL Server 2008 R2 - Upgrade Default DB Instance (Express) to Developer Edition
I have just installed SQL Server 2008 R2 Developer edition (created a new instance for it: DEVEDITION). I previously had and the default instance (MSSQLSERVER) which was running SQL Server 2008 R2 ...
3
votes
1answer
100 views
Why SQL Server installs multiple services for AS and RS, but only one for IS?
When I install multiple SQL Server instances on a same computer, every instance gets its own SQL Server Service for Analysis Services and Reporting Services. But I get only one service for Integration ...
10
votes
3answers
530 views
What's the most effective way to duplicate an instance on SQL 2008?
We've got a simple database instance with just enough data in the databases to keep it useful, and we can use it for demonstration purposes, and I want to put a copy of it on my laptop so I can use it ...