Take the 2-minute tour ×
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.

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

This question came from our site for professional system and network administrators.

add comment

1 Answer 1

up vote 7 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
add comment

Your Answer

 
discard

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