Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

Where can I set the folder to store a database in when I create a new Database in the Microsoft SQL 2008 Server?

share|improve this question

migrated from serverfault.com Dec 29 '11 at 14:37

1 Answer

up vote 5 down vote accepted

Via the GUI, right click the main server node:

enter image description here

Programmatically, it is stored in the registry. You can see this here: http://blogs.technet.com/b/sqlman/archive/2009/07/20/tsql-script-determining-default-database-file-log-path.aspx

However, you'd typically specify paths, names, sizes etc in your CREATE DATABASE

share|improve this answer
+1 for method 2 in the link. – brian Dec 30 '11 at 3:24

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.