How Recover Drop or Deleted DBobject in SSMS

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

SQL Server 2008 Forums

Transact-SQL (2008)

How Recover Drop or Deleted DBobject in SSMS

Author

Topic

kond.mohan
Posting Yak Master

213 Posts

Posted - 2014-01-10 : 08:04:44

Hi,

instead of DBOOLDBACKUP Restoring
is there A way to recover deleted or dropped Database object in Sql server 2008.
thaks in Advance.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2014-01-10 : 08:12:25

it depends on objects. In case of procedures etc you can retrieve them either from cache
or using fn_dblog
see
http://raresql.com/2012/12/04/sql-server-recover-the-dropped-objects-view-stored-procedure-function-trigger/
http://rbalajiprasad.blogspot.in/2012/04/to-recover-deleted-objects-in-sql.html

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources