On my production server I was in SQL2005 Mngt Studio and doing a query on a table. FOr some reason the table disappeared and cannot find it in my database. I guess I somehow deleted it accidently. What is the simplest way to get back the table itself and its contents without restoring the whole Production DB? I have a backup of the DB (name.BAk).
i dont think you can restore just one table from a db backup. easiest way is to restore the backup as a differently named database on the same server then copy the table from the new db back to the original db using SELECT INTO, INSERT, etc
But the table does not even exist in the original database. I don't see it - its gone. DOn't I need to re-create the table structure in the original db first?
oh i thought your db backup had the table. the only way i can think of is to retrieve it from the transaction logs and restore the db at a specific point in time before the table was deleted, assuming you are backing up the logs. i'm off to bed now so good luck.
