Hi

I've a database called db1(full recovery model) which is a large database ,I
backed up a complete backup and then (when some activities happened there) I
backed up a differential type,
now I imagine there's a crash and I want to restore my db,I guess I should
restore the full one at first and the dif one for the second,I did the full
one successfully (by selecting the "leave database nonoperational but able
to restore additional transaction log ") on that server with another name
and when I tried to restore the dif backup ,following error occurred :
"cannot apply the backup on device 'h:\db1dif' to database db2 restore db is
terminating abnormally."
I selected different options in the 2nd tab of restore window but for all of
them the error was the same.

my second question is :
I backup my db in full type and then tlog type periodically ,but how can I
reduce the size of .ldf file of my db,cause it's growing all the time ?

any help would be greatly thankful

Are you positive you tried to restore the diff to the correct db? It sounds
like you accidentally chose the original db and not the copy to restore the
diff.
As for the log file issue see my reply to your previous post.


--
Andrew J. Kelly SQL MVP


"maryam rezvani" <rezvani (AT) parskhazar (DOT) net> wrote

I'm deffinetly sure,but I don't know why?
"Andrew J. Kelly" <sqlmvpnooospam (AT) shadhawk (DOT) com> wrote