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 Previous Backup on Logshipping Primary

Quick Question: If I want to restore an earlier database backup (rollback)
my log shipping primary - how do I ensure that I get my secondaries in sync?
Just re-create the maintenance plan? The database in question is very large,
and I'd like to be able to just do a point-in-time restore on the primary,
etc, without messing up my transaction log lineage.
Does anyone have any scripts handy?
TIA
J Roberts
Norfolk ITJohn
Backup Log file before restore full database
Disable Log Shipping
Restore the database and apply all log file/s with option at point of
time. Then enable Log Shipping and restore full and then log file backpus on
the secondary server
Actually I have not used maintenance paln fo doing Log Shipping , as I
always create scripts (stored proceduers etc..)
"John Roberts" <JohnRoberts@.discussions.microsoft.com> wrote in message
news:094ACA2D-1C92-47DE-B63C-7E7A4087FE7B@.microsoft.com...
> Quick Question: If I want to restore an earlier database backup
> (rollback)
> my log shipping primary - how do I ensure that I get my secondaries in
> sync?
> Just re-create the maintenance plan? The database in question is very
> large,
> and I'd like to be able to just do a point-in-time restore on the primary,
> etc, without messing up my transaction log lineage.
> Does anyone have any scripts handy?
> TIA
> J Roberts
> Norfolk IT|||That's what I thought. You'd think that MS would have considered rollbacks
in their implementation... Oh well. T-SQL it is. I think I'm going to use
SQL-DMO (vb.net) for this...
Thanks for your reply.
John
"Uri Dimant" wrote:
> John
> Backup Log file before restore full database
> Disable Log Shipping
> Restore the database and apply all log file/s with option at point of
> time. Then enable Log Shipping and restore full and then log file backpus on
> the secondary server
> Actually I have not used maintenance paln fo doing Log Shipping , as I
> always create scripts (stored proceduers etc..)
>
>
> "John Roberts" <JohnRoberts@.discussions.microsoft.com> wrote in message
> news:094ACA2D-1C92-47DE-B63C-7E7A4087FE7B@.microsoft.com...
> > Quick Question: If I want to restore an earlier database backup
> > (rollback)
> > my log shipping primary - how do I ensure that I get my secondaries in
> > sync?
> > Just re-create the maintenance plan? The database in question is very
> > large,
> > and I'd like to be able to just do a point-in-time restore on the primary,
> > etc, without messing up my transaction log lineage.
> >
> > Does anyone have any scripts handy?
> >
> > TIA
> >
> > J Roberts
> > Norfolk IT
>
>