Hi

When creating a new db in Server Management Studio how can I choose the path
of the new db to F:\MyPath instead of the default?

Thanks

Regards

The default directory for new databases is configured when installing
SQL Server. If you want to change it later, you can right click on the
server / Properties / Database Settings and change the Database
default locations.

Razvan

Hello John,

The new databases will be created based on the default directory set [ Right
click above the server name in SSMS -- Choose properties -- Database
settings and see the deualt directory.
If you a differnt folder during  a new database creation then:-

1. Right click above the database in SSMS-- New Database
2. Give the new database NAME
3.Go to the file list below in the same window of New database
4. Move the cursor to the right to see the PATH option
5. There you browse and select the path u want the new database
6. Click OK.

This will create the database in the drive and directory you need.

Thanks
Hari

Show quoteHide quote

SQL 2005 Management Studio
How can I print my SQL Server agent jobs?
Query to split Firstname Lastname into 2 fields
Profiler: SQL:StmtRecompile - EvenSubClass definitions?
sp_trace_setfilter does not work