Tuesday 15 June 2010

sql server 2014 - SSMS drop failed for database "Unable to open physical file" -


Tried to find it with any other part

I now leave the database on disk I'm trying to, but SSMS still looks in Object Explorer in 2014

How can I clear them? Object Explorer?

Do I need to manually remove them from sys.master_files?

The exception was:

  'aspen-blawblaw-20141027015559' for the database (Microsoft.SqlServer.Smo) ------------------------------ For help, click: http: // go. Microsoft? Com / fwlink ProdName = Microsoft + SQL Server + & amp; ProdVer = 12.0.2000.8 + ((SQL14_RTM) 0.140220-1752) & amp; EvtSrc = Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText & amp; EvtID = Drop + Database & amp; LinkId = 20476 ------------------------------ Program location: Microsoft.SqlServer.Management.Smo.SqlSmoObject.DropImpl () Microsoft.SqlServer.Management.Smo.Database.Drop () Microsoft.SqlServer.Management.SqlManagerUI.DropObjects.DoDropObject (Microsoft SQF Objective Rev. Index) SQL.Management.SqlManagerUI.DropObjects.DropAll Objects (Boolean StopOnerr) === == =============================== Exception occurred when executing a transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ Program location: Microsoft.SqlServer.Management.Common.ServerConnection Microsoft.SqlServer.Management.Smon.SecverConnection.ExecuteNonQuery (StringCollectionSqlCommands, ExecutionTypes ExecutionType) on Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery (StringCollection Queries) on Microsoft.SqlServer.Management on NonCleach (string sqlCommand, execution type execution Type) .mo.SqlSmoObject.ExecuteNonQuery (string compliant queries on Microsoft, Boolean included DDDCTX) on Microsoft. SQL Server. Management. SMO SQLOMObact DopimPail Worker (UN & OUR) on Microsoft SQL Server. Management. SEO SQL SMObact.DropIMPL () ====== ==================================== Physical file Unable to open "C: \ Projects \ BlawBlaw \ BlawBlaw \ App_Data \ aspnet-BlawBlaw-201141027015559.mdf". Operating System Error 3: "3 (System can not find the specified path.)". File Activation Failure Physical File Name "C: \ Projects \ BlueBlowBoEp_ Data \ aspnet-BlawBlaw-20141027015559_log.ldf" may be incorrect. (.Net SqlClient Data Provider) ------------------------------ For help, click: http: // go. Microsoft com / fwlink? ProdName = Microsoft% 20 SQL% 20 server and producer = 11.00.3000 and vvtsrc = mssualson and avtid = 5120 and link id = 20476 --------------------- --------- Server name: (LocalDB) \ v11.0 Error number: 5120 Seriousness: 16 State: 101 Line number: 2 ---------------- ------------- Program location: Microsoft.Sq  <

This helps me.

  1. Open a new query
  2. Copy the name of the DB (F2)
  3. Run this command: Drop Database [C: Test. MDF]
    - When the "test" name is DB
  4. execute
  5. After refreshing, the DB string is not shown under the database < / Li>

No comments:

Post a Comment