Hi, I do not have much experience in creating databases and maintaining them. I want to create a Database and keep its data and log file on networked location. My command looks like:
RESTORE DATABASE MyDB FROM DISK='\\Machine1\MyDB.bak'
MOVE 'MyDB_Data' TO '\\Machine1\Data\MyDB_Data
MOVE 'MyDB_Log' TO '\\Machine1\Log\MyDB_Log.L
now when I do this, i get error:
The file "\\\Machine1\Data\MyDB_Dat
a.MDF'" is on a network path that is not supported for database files.
I tried to look this up and found one article http://support.microsoft.com/kb/304261
and tried to OFF the trace flag 1807 [Actually it was never ON in my system] but still gets the error.
My Ques are:
1. Can we create DB like the way I am trying?
2. Or can we make an extra harddisk attached to machine as a NAS device?
Your help is greatly apprciated.