If the transaction log file(s) does not have sufficient free space the constant auto-expanding will impact performance. You should schedule transaction log backups often enough that the log does...

You mention above that the users connect to the application via an Application Role. If this is the case, then isn't the Application Role determining the user's access rights...

One advantage of mirroring is the ability to use a broader spectrum of hardware. In many onf the sites where we mirror, the backup server is the old production...

I don't have a lot of mirroring out there. After all it is new technology. One site I work at a lot we are mirroring to a server...

Situations that would push me toward clustering might be where I have multiple databases that are dependent on each other or other services running that that interact with the databases.

AndyD,

It's always informative to get views and opinions from different people. Over the years, many of the practices I follow started out as somebody else's opinion.

I do agree that there...

Our practice for mirrored databases:

1. Create new server logins on primary

2. Transfer to mirror using SQL script

3. Add db users to principal database. (Mirroring activity will...

I don't agree. Database Mirroring is not a...