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...
*********************
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.LD F' 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
last week.

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,

Cy Huckaba
Austin, TX

Do you have permissions onto that area of Disk on the server?

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Cy Huckaba" <russellh (AT) t-3 (DOT) com> wrote