February 11, 2006 at 1:06 am
When i try to careate new databse i am getting an error message something like....
Error 945 : Database 'cc' cannot be opened due to inaccessible files or insufficient memory or disk space
See SQL Server Error log for details
The CREARE DATABASE process is allocating 1.00 MB on disk 'cc_data'
The CREARE DATABASE process is allocating 1.00 MB on disk 'cc_log'
Device activation error. The physical file name '\\Comp1\it\_log.LDF' may be incorrect.
i never give the following path or file name anywhere .... i dont know from where it is coming...... '\\Comp1\it\_log.LDF' !!!!!!!!!!!!
Thanks
Roji
February 12, 2006 at 8:48 pm
1. CREATE command wrong
2. check for available disk space on the drives mentioned
3. are you creating the database remotely? like over a SAN?
4. the path is a default one, ask your DBA about it
HTH
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply