Maybe.

The database backup backed up data as it finds it on disk. Once it's done that, it backs up enough of the transaction log to ensure that the database can...

What wait type are you seeing on the queries when they run long?

The message is pretty self explanatory. SQL can't take a log backup...

Already have.

If you completely disable mirroring, you will have to restart it from scratch, with a restore of a full backup.

Why did you need to check the mirrored DB? It...

Why do you want to manage locking in the app?

SQL takes locks automatically in the required mode and with the best possible granularity for each statement, nad it will release...

I'm not sure I understand you. Have you stopped mirroring or are you planning to. First post said you had, second said you needed to do it. If you have...

Did you pause the mirroring session, or did you completely disable mirroring?

If you look at the servers in management studio's object explorer, do the database still mirrored and principal/mirror?

Someone tried to log into the SQL server and requested the database ASPState to be the default database. The ogin failed because the DB is inaccessible, or it doesn't exist

Reindex again with a higher fill factor. Do you have a reason for wanting the data pages to be only 40% full after the reindex?

Please don't cross post. It just wastes people's time and fragments replies.

No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic603443-357-1.aspx

You can switch a database into norecovery using the backup log statement. It's not possible to switch it into standby the same way.

backup log SomeDB to disk = 'd:\someDB.trn'...

Likewise.

Couple of hours of meeting people that you usually interact with online only, gambling monopoly money and generally having...

Why do you want it in a standby state?