Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #1272

deleting an invalid database

Show all headers | View raw

Somehow I got into this situation.  Looking from the OS, I can see two
files, MyDB_Data.MDF, and MyDB_Log.LDF.  This database does not appear
in the SSMS object explorer.  My first thought is, "Attach the
database, then delete it."  But when I try to attach the database, and
I pick the file MyDB_Data.MDF, the "Attach Database" window, claims
the log file is on a non-existent drive.

First question, "Why does it say that?"  Is the log file path and name
stored in the database?

Of course, when I attach the database, I remove this log file.  But I
still get an error when I try to attach it, something about the
database being corrupt, and I assume this is because it is trying to
create a new log file in the same path, ie, the non-existent drive.

Second, and most important question, "Is it okay to just delete the
MDF and LDF at the level of the OS and forget about it?"  I'm certain
I have no need for the data, because the name is a typical "sandbox"
name.

Back to comp.databases.ms-sqlserver | Previous | Next — Next in thread | Find similar

Thread

deleting an invalid database Dom <dolivastro@gmail.com> - 2012-09-11 10:42 -0700
  Re: deleting an invalid database Erland Sommarskog <esquel@sommarskog.se> - 2012-09-11 23:19 +0200

csiph-web