I have been stuck on this for the last week...
I cannot create a new database on our Sql server, I have recently taken over
management responsibilities on an existing SQL server (2000). Apparently at one
time, it had the Adventure Works CRM database on it that has since been removed.
I was trying to create a new database last week and I keep getting the following
Error 945: Database 'testDB' cannot be opened due to inaccessible files or
insufficient memory or disk space. See the SQL Server errorlog for details.
The CREATE DATABASE process is allocating 1.0 MB on disk 'testDB_Data'.
The CREATE DATABASE process is allocating 1.0 MB on disk 'testDB_Log'.
Device activation error. The physical name
'c:\MSSQL7\Data\Adventure_Works_Cycle_MSCRM_log.LDF' may be incorrect.
I know that Disk Space and Memory aren't the problem. Also, the other databases
on that instance perform very well and have had no problems growing over the
The only thing that shows up in the SQL server error log is a line item that
says "Starting up database 'testDB'. no error message there.
I have confirmed that we DO NOT have the data file and or log files for the Adv
Works database. I don't want to restore it, I just want to delete any orphaned
references that may be lingering.
It looks like replication was being used at one point too, not sure if this has
anything to do with it. Properties on the server say that Replication is not
enabled...but the "distribution" database still shows that it is being
replicated and cannot be detached.
Any ideas would be great, thanks,