how to delete or drop database when I missing physical data

Asked Sep 05 '21 at 10:37

Active Sep 05 '21 at 10:37

Viewed 633 times

I have database with name music I can Not work on database

I can not drop my database ,because I Get this Error (dbcc checkdb)

The operating system returned error 21(The device is not ready.) to SQL Server during a read at offset 0x000000277e2000 in file 'Edb-back\music.mdf'. Additional messages in the SQL Server error log and operating system error log may provide more detail

I Can not do any thing likely (restore , delete , rename ,single user mode ,...) I want delete from my SQL server

What should I do?

asked Sep 05 '21 at 10:37

mohamadreza dehghan

Did you try tsql command like "drop database db_name" – Learning_DBAdmin Sep 05 '21 at 11:15
yes i did but i get this error : to SQL Server during a read at offset 0x000000277e2000 – mohamadreza dehghan Sep 05 '21 at 11:38
What do you mean missing physical data?...do the .MDF / .LDF files no longer exist, but it's still showing in the list of databases? – J.D. Sep 05 '21 at 13:23
I would start trying to hunt down the files on disk, if they exist. My guess is that they do, and SQL server try to access those file which fails based on some physical issue. If the files don't exist in the first place, then methink that the DROP will just remove the database meta-data from SQL Server. – Tibor Karaszi Sep 05 '21 at 13:53
I Lost MDF file – mohamadreza dehghan Sep 05 '21 at 18:27
change type my mdf file to MDF but it should be SQL server primary data file – mohamadreza dehghan Sep 05 '21 at 18:56
Do you see the file location in sys.master_files? What is the status of DB? Did you try detach? – Kris Sep 05 '21 at 21:38
yes I see in sys.master_files but I can not Detach database and The database name is still in sql how can i drop database name or delete ? Whatever I do, I get this error – mohamadreza dehghan Sep 06 '21 at 03:49
See The operating system returned error 21 as it might be related to your problem. Is the database on server or desktop? Is the disk a local disk or a share on the network? – Ronaldo Sep 08 '21 at 11:52
I restart my machine and every thing be ok – mohamadreza dehghan Sep 13 '21 at 11:02

how to delete or drop database when I missing physical data

0 Answers0