Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Why do they have MSSQL and MSSQL.1 and MSSQL2?
Message
De
21/06/2006 18:57:42
Chris Bohling
Myers and Stauffer LC
Shawnee, Kansas, États-Unis
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Versions des environnements
SQL Server:
SQL Server 2005
Divers
Thread ID:
01130603
Message ID:
01130648
Vues:
14
>>They are the different instances of SQL Server. You either have multiple instances running or have installed, uninstalled, then reinstalled.

Additionally, SQL Server 2005 creates MSQL.n directories for Reporting Services, OLAP, etc.

>I am sticking my SQL Server 2000 database into the MSSQL.1.

You can put the database files into any directory on a drive that is local to the machine hosting SQL Server. Also, default locations for database and log files can be set on the Database Settings page of the Server Properties form. On my local machine, I store most user database and log files in E:\SQLData, just to make them easier to find.

Chris
Christopher Bohling, Consultant
http://www.ChristopherBohling.com
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform