Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ann06
Posting Yak Master
171 Posts |
 Posted - 2010-12-02 : 04:22:44
|
| hi,i configured log shipping as followsfull backup with init on srv1/ restore on srv2 every 1 weekdiff backup with init on srv1/ restore on srv2 every 1 daylog backup with init on srv1/ restore on srv2 every 30 minscript for log backup/ restore is as follows1. Backup Log Efiling To Efiling_log_backup_device with no_truncate,init2. restore log efiling from disk = 'f:\Efiling_log_backup_device' with dbo_only, standby='c:\undo_efiling.ldf'problem, i want to be able to restore to a point of time for the same day but more than for 30 min. ie to be able to get back to the 10 am in the morning while it is 4 pm.there should be the noinit i suppose but how would I be able to specify each time the file name of the latest log by the script when no init is specified?i have sql 2000 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2010-12-02 : 12:37:09
|
| You don't have log shipping configured correctly. You should only be applying tlogs to srv2. You should not be applying full backups or diffs.I don't quite understand your problem, but you just need to restore all of the tlogs until the final one and specify the STOPAT option in the restore command. You would use NORECOVERY for each of them except the last you'd use RECOVERY.Noinit has nothing to do with the restore. It has to do with overwriting or appending backup files.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
ann06
Posting Yak Master
171 Posts |
Posted - 2010-12-04 : 00:39:17
|
| thanks for the reply,my problem is that using my method iam able to replicate my original db to a replicate every half hour automatically, but i would not be able to restore to a time earlier than half an hour because am not keeping the older logs.if i used the noinit and kept the logs how i can do the restore automatically, don't the restore needs the log file name if all are stacked in the same file?thank you |
|
|
|
|
|
|
log shipping question