Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

share|improve this question

migrated from Jun 2 '10 at 23:13

This question came from our site for professional and enthusiast programmers.

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:… – marc_s Jun 2 '10 at 5:05

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

share|improve this answer
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 '10 at 3:31

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.