How to Change the Default Path for New Databases

Typing CREATE DATABASE MyDB gets the job done, but it puts the files in whatever location has been set as the default - which means you should make sure the default is set to a good place, or specify them as part of the CREATE. We'll show you how to adjust the setting (and we've got a video coming up that shows you how to change it from code too!).

Andy Warren is a software trainer focusing on SQL Server, a member of the PASS Board of Directors, and a principal in this site - SQLShare.com.

Hunter on 3/16/2010

cc

ramesh on 3/16/2010

nice to show wierd behaviour of defaulog log folder settings even we simply changes Data folder settings

ramesh on 3/16/2010

nice to show wierd behaviour of defaulog log folder settings even we simply changes Data folder settings

mqhpk4 on 3/16/2010

Good step by step explaination

sapna on 3/16/2010

nice explanantion

Michelle Poolet on 3/16/2010

Did the speaker mention that this is SQL Server 2008? I'm looking at my 2005 installation and the screens are set up differently...

Nahid on 3/16/2010

I like it :)

Ron Newlin on 3/16/2010

CONCISE

Christian Bahnsen on 3/16/2010

Thanks. Another of your great lessons poking around in nooks and crannies I'd probably never even think about.

Munna Bhai on 3/16/2010

This another great tip from the pros. Once again thanks for sharing this video.

Kevin on 3/16/2010

Excellent video, Andy, with good examples and explanation. Thanks.

karthik on 3/22/2010

Nice Video...

Balaji on 4/7/2010

it is good

waruna thilanka on 4/8/2010

thanks you. provide this service.