July 24, 2006 at 1:35 pm
We have a sql server env where we take daily backups from our production server(sql7) and perform a restore on another machine(sql2000) for reporting. Every so often, the retore process does not seem to fully restore certain tables on the reporting server, yet absolutely no errors are generated during the process. Any possible reason for this? anyone ever seen behavior like this?
So for example, backups occur at 2am...copy backup files and restore at 4am on reporting machine. No errors. Data on a particular table only contains transactions up to 3:30am previous day?...
sorry pretty vague description of intermittent problem. please email any question around this that may help pin point this issue.
thanks
July 25, 2006 at 7:47 am
I am generating the reports from second server using the same sequence and never came across any issuse that you specified.
I do not understand what you mean by every so often, If there is any problem with any command than this behaviour should continue all the time.
In your example you said backup occurs at 2 am and copy restore at 4 am on reporting machine.I am seeing some ambiguity here as well
Data on a particular table only contains transactions up to 3:30am previous day?...
Your Restore should not contain any data after 2 am.[Last Backup]
When you say 3.30 prev. day , are you saying you are missing 22.5 hrs worth data in some table ?
Best thing is to write a job that daily inserts couple of rows in dumy table that include getdate() in one column at 1.50 am and see if you get that rows everyday in your reporting db.
If that works fine, you can say for sure that you do not have issues with backup, copy or restore.
Hope this helps,
Kindest Regards,
Sameer Raval [Sql Server DBA]
Geico Insurance
RavalSameer@hotmail.com
July 25, 2006 at 1:01 pm
Yes, this is an intermittent issue. same scripts, same everything, yet sometimes every so often, this issue crops up.
correct, there seems to be 22.5 hrs or so of missing from a particular table in the example i gave. example: 07/24/06 @2am backup -> 3am copy backup files to reporting server -> 4am restore on reporting server -> data in particular table contains data up to 07/23/06 3:30am. ?
For your suggestion about getting rows into a table with the date; the table with the missing data already has that and that is how I know how much time is missing in the data. Pleanty of other tables with a getdate() column are included in the backup/restore.
Just another note; today the backup/restore was successful and of course included all the data that was missing in the previous process.
July 25, 2006 at 3:12 pm
try to run profiler for the most commonly missed tables....
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply