Tuesday, 6 August 2013

SQL - I have just Differential backup but database exists

SQL - I have just Differential backup but database exists

i have Differential backup from my database.one table is deleted.my data
is lost.i create that table again but i cannot restore Differential backup
because sql wants a full backup first.if i get full back up an restore it
with norecovery.when i want restore Differential backup sql get error.it
says that:
this Differential backup cannot be restored because the database has not
been restored to the correct earlier state.
What should i do???????

No comments:

Post a Comment