shafiq's picture
Mar 24, 2014
3422 views
Reputation: 5

can we move database from default location to other drives

is it possible to change default database location, that might prevent from window curruption and data loss. 

1 answers

JohnSCS's picture
JohnSCS
Mar 24, 2014
Reputation: 271

SQL Express - Yes as it is a networkable SQL Server. Setup a separate computer (with mirrored RAID or atleast some SQL Server backup tool) to run SQL Express for the network. Follow this guide.

Compact SQL - Yes in theory, not tested and not recommended. Any network issues/outages could corrupt database.

We have already answers to
1030 questions
E-Posta Facebook Twitter RSS Skype
Telefon (212) 252 0634