Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Change database directory
Message
 
 
To
19/09/2008 13:30:16
General information
Forum:
Microsoft SQL Server
Category:
Installation
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01348788
Message ID:
01349038
Views:
17
>>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform