SqlShare.com Logo
 
Skip Navigation Links
Home
Video List
Classes
About Us
Login / Register
Subscribe RSS Feed 

Confio Ignite

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!).

Duration:
4 mins 2 secs
Skill Level:
100
Rating:
4.52 out of 5
Publish Date:
March 11, 2010
How to Change the Default Path for New Databases Watch Video Now  Watch it later!
Bookmark and Share
 
1=Poor, 3=Good, 5=Excellent

About the Author

Image of Andy Warren
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.

References



Comments
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.



Must Be Logged In
 

How Do I Become a Video Author? |  Newsletter History

Copyright © Fourdeuce, Inc., 2005-2009. All Rights Reserved | Privacy Policy | Terms & Conditions