Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
NT.getit
Starting Member
2 Posts |
 Posted - 2011-05-03 : 12:58:25
|
| Hi,I have overwritten by mistake the database file and don't have backups for it. I wish to drop it so I could re-install the application to create a new DB for it, but I cannot perform anything on it (rename, drop) as it doesn't exist. I only see it in SSMS.Please help....Thank you.NT.getit |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-05-03 : 13:01:37
|
| Have you refreshed the database list?Try restoring a small database over the top of it then dropping it.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
NT.getit
Starting Member
2 Posts |
Posted - 2011-05-03 : 13:38:23
|
| I did try to refresh the list, but to no avail..Luckily, the sysadmin found an old backup so I was able to restore it on top of the 'non-existing' DB. Even more luckily, this DB data is not that important (as you already figured out..haha) so it wasn't such a big deal. But, I would really love to know what one can do if there's a need to perform something like that. |
|
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-05-03 : 14:19:38
|
| Find any database backup and restore it over the database - when I was doing this sort of thing I kept an empty database backup for this purpose, not as common as it used to be though.Stop the server, copy a database data and log files to the filenames for this database and try restarting.Look at the log and see if it gives you any hint.Try putting the database into emergency modeReinstall the o/s and sql server and restore everything from backups. You shouldn't have to go this far but you should always be prepared for it.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2011-05-04 : 16:10:27
|
| How you overwritten database file? |
|
|
|
|
|
|
Cannot drop a db - doesn't exist in sys.databases