Transaction log backup  
Author Message
fredrikgunne





PostPosted: Tue Sep 05 09:00:39 CDT 2006 Top

SQL Server >> Transaction log backup

Hi

i am testing my backup script. Could someone please tell me how to test
transactional log backup restore

thanks
v

SQL Server297  
 
 
Tracy





PostPosted: Tue Sep 05 09:00:39 CDT 2006 Top

SQL Server >> Transaction log backup
> Hi
>
> i am testing my backup script. Could someone please tell me how to test
> transactional log backup restore
>
> thanks
> v

Restore the full backup WITH NORECOVERY, then restore the first
transaction log backup, WITH RECOVERY if it's the last backup, WITH
NORECOVERY if there are more to restore.


--
Tracy McKibben
MCDBA
http://www.realsqlguy.com
 
 
swapna





PostPosted: Tue Sep 05 09:25:03 CDT 2006 Top

SQL Server >> Transaction log backup Hi,

add some test data from the database ,take the ransaction log backup..delete
the test data and then apply the tl backup to restore the db,this way u can
check the script if this is correct.




> > Hi
> >
> > i am testing my backup script. Could someone please tell me how to test
> > transactional log backup restore
> >
> > thanks
> > v
>
> Restore the full backup WITH NORECOVERY, then restore the first
> transaction log backup, WITH RECOVERY if it's the last backup, WITH
> NORECOVERY if there are more to restore.
>
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
>
 
 
Hari





PostPosted: Tue Sep 05 21:02:07 CDT 2006 Top

SQL Server >> Transaction log backup Hi,

1. Do a full database back [Backup Database]
2. Perform some changes [Insert/update/delete/schema creation]
3. Perform a Transaction log back [Backup Log]

4. Restore the full database backup with NORECOVERY [Restore Database WITH
MOVE,NORECOVERY]
5. Restore the transaction log back with RECOVER [Restore Log WITH RECOVERY]

See the command usage from books online. If you need more info please write
us back.

Thanks
Hari
SQL Server MVP




> Hi
>
> i am testing my backup script. Could someone please tell me how to test
> transactional log backup restore
>
> thanks
> v