Hi,
I have 4 databases , all are in FULL recovery model :DB1,DB2,DB3,DB4....
I have taken full backups of DB1 , DB3, DB4 and i did not take DB2 full backup , now when i try take
differential backups of DB1,DB2,DB3,DB4 the job fails saying DB2 don't have a full backup,
what happens to DB1,DB3, DB4 database differential backups ?
The differential backups for DB1 , DB3 and DB4 will be successful , SQL server job executes DB1 diff backups , then search for DB2 full backup, if not found it would go to DB3, then DB4 and do differential backups then throws the error saying DB2 don't have a Full backup ....
Thanks
I have 4 databases , all are in FULL recovery model :DB1,DB2,DB3,DB4....
I have taken full backups of DB1 , DB3, DB4 and i did not take DB2 full backup , now when i try take
differential backups of DB1,DB2,DB3,DB4 the job fails saying DB2 don't have a full backup,
what happens to DB1,DB3, DB4 database differential backups ?
The differential backups for DB1 , DB3 and DB4 will be successful , SQL server job executes DB1 diff backups , then search for DB2 full backup, if not found it would go to DB3, then DB4 and do differential backups then throws the error saying DB2 don't have a Full backup ....
Thanks
No comments:
Post a Comment