1

I have really wired problems here. I am using MS 2008 sql server at the moment. After I did a tail-log backup, the target database is automatically restoring and keeping on restoring.

Does anyone know what's the problem?

Thanks, Ling

1
  • 3
    Please get in the habit of accepting the best answer provided, the one solving your problem. It's the right and polite thing to do on StackOverflow and serves as an incentive for others to continue to help those looking for answers. See: meta.stackexchange.com/questions/5234/…
    – marc_s
    Jun 2, 2010 at 5:05

1 Answer 1

1

It's most likely because you didn't restore with the WITH RECOVERY option.

1
  • Thanks Dave, the question is I could not remember I did restore or not. I am only sure that I did the tail_log backup in the last operation. it is really wired.
    – LingAi
    Jun 2, 2010 at 3:31

You must log in to answer this question.