Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Why do they have MSSQL and MSSQL.1 and MSSQL2?
Message
From
21/06/2006 15:39:53
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01130603
Message ID:
01130608
Views:
10
They are the different instances of SQL Server. You either have multiple instances running or have installed, uninstalled, then reinstalled.

>I noticed that on my PC where I have SQL Server 2000 there are folders MSSQL and MSSQL.1. On the PC with SQL Server 2005 there are folders MSSQL.1 and MSSQL.2. All of these folders have DATA folder.
>
>What is the significance of having these different folders? I am moving a database from SQL 2000 to 2005. Does it matter if I put it in MSSQL.1 or MSSQL.2?
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform