Post reply

Data files left after drop database - can I delete

  • January 17, 2013 at 8:59 am

    #287811

    SQL 2008r2

    Tried to do an restore that was unsuccessful, giving the message

    Msg 3183, Level 16, State 2, Server MYSERVER, Line 2

    RESTORE detected an error on page (0:0) in database "MyDB" as read from the backup set.

    Msg 3013, Level 16, State 1, Server MYSERVER, Line 2

    RESTORE DATABASE is terminating abnormally.

    But this left the database ‘restoring’ in SSMS, so dropped database using SQL. This successfully removed it from the databases in SSMS. The problem I now have is that the database files (.mdf, .ndf and .LDF are still on the disc. (C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA).

    Can I just delete these files with no adverse affects on the server?

  • January 17, 2013 at 9:46 am

    #1578391

    If you have successfully restored the DB and everything is up and running (i.e. the DB is ONLINE) there's no harm in deleting the old DB files. If either of them is still in use you will get en error attempting to delete it anyway...

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply