I have a question... I've changed the script to use C:\ for both files as follows:
Create Database Mytestdb
on
( name ='Mytest_1', Filename= 'C:\MyTEST.mp3', size = 2000 KB
)log on(
name ='MyTest_2', Filename= 'C:\MYTEST.doc', size= 512 kb)
and get the following error:
Msg 5123, Level 16, State 1, Line 1
CREATE FILE encountered operating system error 5(Access is denied.) while attempting to open or create the physical file 'C:\MyTEST.mp3'.
Msg 1802, Level 16, State 4, Line 1
CREATE DATABASE failed. Some file names listed could not be created. Check related errors.
I am administrator of my machine and the DB is installed locally and I'm sysadmin....
When I change the files to C:\temp\filenames... (with temp folder being existant)... it works!!! :ermm:
Can someone explain if this behavior is normal?? I'm suspecting that it's some type of setting on my account... :doze: