September 24, 2006 at 1:26 am
It seems SQL Server 2005 can store data in both C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data and C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Data. But what's the difference between the 2 folders? I accidentally found identically named mdf files in the two folders and got confused. Thanks.
September 25, 2006 at 6:40 am
When SQL 2k5 is installed, it uses the folders of MSSQL.1, MSSQL.2 (.3, .4...etc) for different service and instances. In a normal installation, if you chosen to install every service, you'd see C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\ for the default instance of SQL Server serive, C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\ for Analysis Service, and C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Service\ for SSRS. If you later install another SQL Server instance, you'd see C:\Program Files\Microsoft SQL Server\MSSQL.4\MSSQL\, which has same folder structure with the default instance. Looks you have installed the second SQL Server instance without installing SSAS and SSRS. Check you database property you'll find which instance your database had been created to.
Regards,
Jin
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply