Installing application on one drive but keep databases on other? 1

[serializer]

Is it possible to control where the data files are stored?

 

[gmmastros]

Yes. You can change the folder or even the drive (if you have multiple drives in the server computer). You cannot have the database files stored on another server though. The reason for this is that the SQL Server service kicks in when the server is shutdown so that it can cleanly close the database files (to avoid corruption). When the database files are on another server, the network could go down or the server with the database files could go down. Both of these things could cause major problems for your database.

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[serializer]

Thanks, do you know where to change the drive/folder?

 

[gmmastros]

This microsoft article does a good job of explaining the steps involved.

http://msdn.microsoft.com/en-us/library/ms345483.aspx

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[serializer]

Great - thanks!