|
|
|
Author |
Message |
fredrikgunne
|
Posted: 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
|
Posted: 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
|
Posted: 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
|
Posted: 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
|
|
|
|
|
|
|