Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 changing the default location of a new database

Author  Topic 

lmendoza
Starting Member

12 Posts

Posted - 2001-08-09 : 11:59:48
How can I change the location of where a database should be stored (meaning, instead of C:\MSSql7\Data it should be on D:\MSSql7\Data)?

I think that it has something to do with changing the model database, but since it won't let me change the location of the file, I don't know how to do it.

TIA
leo

   

- Advertisement -