Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Configuring where to store the database
Message
 
 
À
13/03/2008 12:31:25
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Divers
Thread ID:
01301660
Message ID:
01301798
Vues:
14
>>You can set Server default DB locations thrue SSMS in the Server properties, Database Settings page. For particular new database created in SSMS you can specify location in the New Database dialog, General page. The CREATE DATABASE statement has FILENAME clause for that.
>
>Thanks, and if the database is already created, would there be a setting to move it?

Check ALTER DATABASE command and also MOVE option.

This is from the top of my head.
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform