Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Change database directory
Message
 
 
À
19/09/2008 13:30:16
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Installation
Versions des environnements
SQL Server:
SQL Server 2005
Divers
Thread ID:
01348788
Message ID:
01349038
Vues:
18
>>You can set/change default location for new databases in SSMS by going to SQL Server properties, Database Settings.
>>You can as well specify DB location when you create it. In SSMS, in New Database dialog on the General tab. In T-SQL, CREATE DATABASE in the ON clause.
>
>Thanks, this is good to know. Next time, I will watch for that at the creation time.

You can move it after it was created as well. I think the syntax should be in ALTER DATABASE command Help.
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