You must Sign In to post a response.
Category: SQL Server
#294775
hi,
If it's in FULL recovery model, you can use the RESTORE LOG with the STOPAT clause and specify the time before the drop table command occurred.Otherwise, restore a backup of your database on a different instance or using a different name, script out the table creation and do a DTS package to import the records back. I am assuming you have no key issues here as you were able to drop the table successfully
reference:
http://cursos.atica.um.es/DBA10g1/anexos/RMAN/Nota_223543.1_RMAN_RECUPERAR%20TABLAS.pdf
If it's in FULL recovery model, you can use the RESTORE LOG with the STOPAT clause and specify the time before the drop table command occurred.Otherwise, restore a backup of your database on a different instance or using a different name, script out the table creation and do a DTS package to import the records back. I am assuming you have no key issues here as you were able to drop the table successfully
reference:
http://cursos.atica.um.es/DBA10g1/anexos/RMAN/Nota_223543.1_RMAN_RECUPERAR%20TABLAS.pdf
#294778
Hi,
if you used this way
BEGIN TRANSACTION
drop table a
rollback
then you rollback otherwise not,
vipul,
http://dongavipul.blogspot.com
Thanks & Regards
Patel Vipul
if you used this way
BEGIN TRANSACTION
drop table a
rollback
then you rollback otherwise not,
vipul,
http://dongavipul.blogspot.com
Thanks & Regards
Patel Vipul
#294800
Rollback the transactions
Surely you will get the dropped table.
Surely you will get the dropped table.
#295728
http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1219179,00.html
try this link
try this link
#296961
here i am deleting one table how to recovery a table and
how to rollback transaction ??
delete from table
how to rollback transaction ??
delete from table
Return to Return to Discussion Forum