|
|
Posted by Erland Sommarskog on 08/22/06 21:51
soulkitchen (esoulkitchen@gmail.com) writes:
> I hope someone can answer this question.... The problem above was
> happening, and I did not do anything to fix it, but the next day the
> problem went away. I can't imagine what could have happened over night
> to fix my problem. I do transaction log backups on the hour, and a full
> database backup once a week, but no last night.
To answer what happened in an office building far far away is kind of
difficult, but I will have to guess that you restarted something.
A possibility is also that there was a blocking issue. With the situation
gone all we can do is guess.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|