Just don't set the DB to simple recovery model in the process.

Steve Jones - SSC Editor (8/21/2015)

---

I had someone ask recently about seeing more dev articles, especially T-SQL based ones. Anyone up for doing some one-pagers that solve some of the...

Phil Parkin (8/21/2015)

---

Most importantly is avoidance of the run_date cast. As we are using YYYYMMDD int format, the simple -1 works and we don't lose the possibility of an index...

podmate (8/20/2015)

---

I have never worked for a tech employer that would pay you for training or encouraged you to train on company time (barring being sent offsite for training which...

Yes. It's a common reason for error 32.

Fix your virus checker according to MS recommendations: https://support.microsoft.com/en-us/kb/309422

What you probably want to read is this: http://www.sqlservercentral.com/articles/Administration/64582/

Before you do anything, find out what the recovery requirements are for the databases. If drives fail, is restoring to the previous...

Why? He's not deleting the log.

Operating system error 32 is "File in use by another process". It's not permission-related.

The logical reads should be the same with identical plans. The physical reads may not.

It's...

Which is missing any useful information. 🙁

Check that the query window where you ran the SELECT from sys.databases is pointing to the correct server. There's no reason I can think...

Someone who's more familiar with mirroring please have a look here: http://www.sqlservercentral.com/Forums/Topic1713336-2799-1.aspx

Does not look right to me that a mirrored DB isn't in the system views (I wonder if she's...

Also confirm that no one's done anything stupid, like granting CONTROL SERVER to public or assigning the sysadmin role to <DOMAIN>\Users (seen both before)

Huh?

No, once you fail over the mirror is active and the DB is online.

You have mirroring implemented at the moment, the principle on one instance, the mirror on another?...

Now there's something for someone's sig..

DECLARE @Myself CHAR(3) = 'GOD';

Does the database xyz exist?

What does this return?

select name from sys.databases