Doh!

Thanks Jim

The problem is that one or more of the VLF segments is still in use.

The easiest way to get around this issue is to:

0. backup the database

1. Put the database...

Lowell (5/3/2010)

---

Ray i had the same thing happen; locked out of a new install.

the fix is to add yourself as an administrator; you should be able to find the SQL...

First suggestion is to try the operation on similar set of hardware. I frequently start by trying this type of operation on my "test box". It has a...

Hi Tim,

I am pretty sure that this statement is not accomplishing what you intended.

exec('USE ' + @YourDatabaseName)

When Exec is executed the database context is changed, but only for the statement(s)...

I have to disagree with you Robert.

:hehe:Sorry, I looked more closely at the posting and now see that Robert is referring specifically to the use of Single Quotes rather than...

How much of the space reserved for your datafile is actually in use? If you are using SSMS you can right-click the database and the properties tab will show...

You should add a check for AutoStats. If you set the database to single user and AutoStats gets started you may have problems regaining access. I used a...

Hi Peter,

Thanks for the reply.

We are pretty sure we have this resolved now and it turns out to be a client issue with TCP/IP Sockets. This Microsoft Support Article...

Don't you hate it when you are trying to find the answer to something like "What does Sort_Init" mean and someone tells you that you can run DBCC CheckDb to...

There is a nice tool I have used called WildEdit that applys reqular expressions to search and modify a set of files. The tool comes from the same folks...

Thanks Gail,

I was running in circles for sure. 🙂

Hi chbinraj,

I hate this stuff. These are "API Cursors" and are very poorly documented. They are the mechanism that ODBC, OLEDB, and other providers use to implement...

Hi rambilla4

I have not seen this error on MSDB before but when I get it on an app database it is trouble.

The message is telling you that an I/O...

Hi Paul,

Thanks for the quick and informative response. I have seen almost all of the symptoms that you describe including the log messages related to the LSN.

My question is...