Sql differential backup Restoration

Anashwar N 46 Reputation points
2020-09-23T18:39:28.63+00:00

Hi Team

I have full backup on Sunday , differential backups on Monday, Tuesday, Wednesday

I want to make my DB available till Monday for testing some data

I am trying to restore my database on new server

Restored full backup ,restored differential backup took on monday

It throw s an error database cannot be restored to earlier state

How do I make my db available till Monday

Regards

SQL Server | Other
0 comments No comments
{count} votes

6 answers

Sort by: Most helpful
  1. m 4,281 Reputation points
    2020-09-28T01:36:36.293+00:00

    Hi @Anonymous ,

    Is the reply helpful?

    BR,
    Mia

    0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.