up vote 1 down vote favorite
share [g+] share [fb]

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

link|improve this question
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.stackoverflow.com/questions/5234/… – marc_s Jun 2 '10 at 5:05
feedback

migrated from stackoverflow.com Jun 2 '10 at 23:13

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

1 Answer

up vote 1 down vote

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

link|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
feedback

Your Answer

 
or
required, but never shown
discard