May 8, 2014 at 9:33 am
Hi,
Whilst preparing to move a DB between ISP's last night, I choose to preform a full backup in the morning , and then preform a differential backup in the evening due to the transfer time of the DB.
Resulted in a failure, as the Diffential Backup did not pick up the lastest full backup , but the one beforehand.
Any idea why
database_namebackup_start_date checkpoint_lsn differential_base_lsnBackupType
ecommerce08/05/2014 10:02:18229064000000054000000229064000000030000000Differential
ecommerce08/05/2014 09:46:14229064000000030000000NULL Full
ecommerce08/05/2014 03:10:13229058000000853000000NULL Full
ecommerce07/05/2014 19:52:01228885000000232000000NULL Full
ecommerce07/05/2014 19:36:31228885000000226000000227582000000041000000Differential
^^^^^^^^^^^^^^^^
ecommerce07/05/2014 18:40:45228885000000218000000227582000000041000000Differential
ecommerce07/05/2014 09:22:17228797000000438000000NULL Full
^^^^^^^^^^^^^^^
ecommerce07/05/2014 03:01:55228796000000582000000227582000000041000000Differential
ecommerce06/05/2014 03:01:48228596000000019000000227582000000041000000Differential
ecommerce05/05/2014 03:01:42228379000000489000000227582000000041000000Differential
ecommerce04/05/2014 03:01:04228218000000022000000227582000000041000000Differential
ecommerce03/05/2014 03:01:51228008000000859000000227582000000041000000Differential
ecommerce02/05/2014 03:02:20227822000000418000000227582000000041000000Differential
ecommerce01/05/2014 03:08:08227582000000041000000NULL Full
May 8, 2014 at 9:54 am
Could it have been a copy only full backup that you performed?
May 9, 2014 at 2:32 am
I thought about that , but as you cannot specify it from the GUI I dismissed it, but I rememered that I reran a scripted job and you are correct.
Thanks
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply