recovering the dropped table - SQL Server Forums

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.

All Forums

General SQL Server Forums

New to SQL Server Administration

recovering the dropped table

Author

Topic

jagdish nepal
Starting Member

1 Post

Posted - 2011-01-07 : 06:09:09

How can I recover the dropped table in ms sql 2005. The thing is I have no backup at all.

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-01-07 : 07:15:30

No backup = no recovery. If you have absolutely no backup of this database (and if not why not?) then there's pretty much no options for recovering deleted data.

--
Gail Shaw
SQL Server MVP

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2011-01-07 : 08:35:26

Are you sure there is no backup? Try this query:

  SELECT 
	database_name,
    physical_device_name,
	backup_start_date
  FROM msdb.dbo.backupset a
    INNER JOIN msdb.dbo.backupmediafamily b
      ON a.media_set_id = b.media_set_id
  ORDER BY a.backup_start_date DESC

If you find records here for the database in question a backup has been made at some point. If you find something at all, obtaining the file is also a challenge...

- Lumbago

My blog (yes, I have a blog now! just not that much content yet)
-> www.thefirstsql.com

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources