Re: deletion mistake
From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 11/13/04
- Previous message: Hari Prasad: "Re: deletion mistake"
- In reply to: Manlio: "deletion mistake"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Fri, 12 Nov 2004 21:45:02 -0600
Hi,
Use POINT_IN_TIME restore strategy to recover the tables.
POINT_IN_TIME restore will work only if your Recovery mode is FULL for that
database. If it is FULL then:-
1. Take a backup transaction log in current database
2. Create a new database
3. Restore with full backup file with NORECOVERY (Use below command)
RESTORE database new_dbname from disk='file' with NORECOVERY,
MOve 'logical_mdf' to 'physical_mdf',
MOve 'logical_ldf' to 'physical_ldf'
4. Restore the transaction log backup taken in step-1 with RECOVERY and
STOPAT option
RESTORE log new_dbname from disk='tran_backup_file' with RECOVERY, STOPAT
= ''May 24, 2004 03:44 AM'
-- Thanks Hari SQL Server MVP "Manlio" <Manlio@discussions.microsoft.com> wrote in message news:598DABF2-5B83-4679-95A7-D86882BFD2F9@microsoft.com... > Hello i deleted by mistake 2 tables of my SQL Server database. Is there a > way > to recover them? > > Thanks > > Manlio
- Previous message: Hari Prasad: "Re: deletion mistake"
- In reply to: Manlio: "deletion mistake"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
