Hello,
I need help with the setup of my sql server express 2005 and more specifically, with the location of the database files. Normally, database files are located on the c: drive. In my situation, being in a high school environnement, I need to have the database files on the network drive ... lets call it g:\drive. The reason why it cannot be on c:\drive is because this drive is protected using DeepFreeze. Now, I was able to change the location of the new drive as I went into the properties window of the sql server instance but when I try to create this new database, sql gives me grief ;-|
I am from the group of people that thinks that to anything, there is a solution and am hoping that to this problem, there is hope of a solution.
Can anyone help?
Thank you
Yep there is Trace flag 1807 when you add that to your CREATE DATABASE statement it will be accepted, I found Microsoft documentation of the requirement and a link showing how easy it is to run DBCC TRACEON before executing your CREATE DATABASE statement. Hope this helps.
http://support.microsoft.com/default.aspx?scid=304261
http://www.yafla.com/dennisforbes/SAN-NAS-and-iSCSI-SQL-Server-/SAN-NAS-and-iSCSI-SQL-Server-.html
No comments:
Post a Comment