Restore the Stored Procedure - No backup

Hi all
I hv wrongly updated some stored proecedures in my database. I dont have
backup and i didnt put begin trans. Is it possible to rollback or anyother
option (restore the database in the stage before one hour like that).
Regards
B. Sundar
You might get some help from a tool which reads the tran log from lumigent
( log explorer, www.lumigent.com)
But otherwise no other way... Of course, you should put all of your code
( including SPs, etc ) in change control, but that doesn't help you now...
sorry
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Sundar" <Sundar@.discussions.microsoft.com> wrote in message
news:DEB3A28F-2EF9-4547-B342-B836A26CFBF0@.microsoft.com...
> Hi all
> I hv wrongly updated some stored proecedures in my database. I dont have
> backup and i didnt put begin trans. Is it possible to rollback or anyother
> option (restore the database in the stage before one hour like that).
> Regards
> B. Sundar
sql

Restore the Stored Procedure - No backup

Hi all
I hv wrongly updated some stored proecedures in my database. I dont have
backup and i didnt put begin trans. Is it possible to rollback or anyother
option (restore the database in the stage before one hour like that).
Regards
B. SundarYou might get some help from a tool which reads the tran log from lumigent
( log explorer, www.lumigent.com)
But otherwise no other way... Of course, you should put all of your code
( including SPs, etc ) in change control, but that doesn't help you now...
sorry
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Sundar" <Sundar@.discussions.microsoft.com> wrote in message
news:DEB3A28F-2EF9-4547-B342-B836A26CFBF0@.microsoft.com...
> Hi all
> I hv wrongly updated some stored proecedures in my database. I dont have
> backup and i didnt put begin trans. Is it possible to rollback or anyother
> option (restore the database in the stage before one hour like that).
> Regards
> B. Sundar

Restore the Stored Procedure - No backup

Hi all
I hv wrongly updated some stored proecedures in my database. I dont have
backup and i didnt put begin trans. Is it possible to rollback or anyother
option (restore the database in the stage before one hour like that).
Regards
B. SundarYou might get some help from a tool which reads the tran log from lumigent
( log explorer, www.lumigent.com)
But otherwise no other way... Of course, you should put all of your code
( including SPs, etc ) in change control, but that doesn't help you now...
sorry
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Sundar" <Sundar@.discussions.microsoft.com> wrote in message
news:DEB3A28F-2EF9-4547-B342-B836A26CFBF0@.microsoft.com...
> Hi all
> I hv wrongly updated some stored proecedures in my database. I dont have
> backup and i didnt put begin trans. Is it possible to rollback or anyother
> option (restore the database in the stage before one hour like that).
> Regards
> B. Sundar

restore replicated databases

I can't restore trans replicated databases because I get message that they
are in use - do I need to stop agents to get exclusive access - then restore
- then restart agents?
Thanks
yes, stop Sql Server agent, run sp_who2 to identify and kill spids that are
continuing to use the db and then retry your restore.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"DrBob" <DrBob@.discussions.microsoft.com> wrote in message
news:F2DC7A4C-D2DB-493B-BBDB-6BBBF95306CE@.microsoft.com...
> I can't restore trans replicated databases because I get message that they
> are in use - do I need to stop agents to get exclusive access - then
restore
> - then restart agents?
> Thanks
|||Thanks
"Hilary Cotter" wrote:

> yes, stop Sql Server agent, run sp_who2 to identify and kill spids that are
> continuing to use the db and then retry your restore.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "DrBob" <DrBob@.discussions.microsoft.com> wrote in message
> news:F2DC7A4C-D2DB-493B-BBDB-6BBBF95306CE@.microsoft.com...
> restore
>
>