Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recovering a deleted stored procedure!
- Thread starter Antzz
- Start date
mrdenny
Programmer
- May 27, 2002
- 11,595
Not really.
If your database is in full recovery mode, you can use a product like Lumigent's Log Explorer to see if you can roll back the DROP PROCEDURE transaction.
If your database is in Simple Recovery Mode and you have no backup it's gone.
Sorry.
Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)
My Blog
If your database is in full recovery mode, you can use a product like Lumigent's Log Explorer to see if you can roll back the DROP PROCEDURE transaction.
If your database is in Simple Recovery Mode and you have no backup it's gone.
Sorry.
Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)
My Blog
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question