Have all of the databases had a FULL backup made of them?  I am not sure if SQL 2008 R2 is this way, but transaction logs are not kept, until...

Any service account change in a failover cluster needs to be done through the SQL Server Configuration tool.

https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/scm-services-change-the-password-of-the-accounts-used?view=sql-server-2017

note, that the article does say that once the password has...

A few years ago, I did a similar upgrade (2008 R2 to 2014 parallel upgrade).  One thing you will want to watch out for:

Queries that use table valued functions will...

First, check to see if the index is even being used, by checking the query plan.  Next, if the query is being used, you can use Event Sessions to see...

Heh.  I just finished reading a book about the Titanic.  They had some of the messages that were sent from the various ships.  With all of the abbreviations, call signs,...

Backing up the log should advance the active VLF to the next entry.  If there is no next entry (i.e. you are at the end of the file), then it...

There will be a few things in play here.

Since the database is in bulk-logged mode, the transaction log will not be cleared out, until you backup the log.  It is...

You may also want to check to make sure that AUTO_CLOSE is not turned on for this database.

If this is not an anti-virus problem, then it might be a server...

Around here, the crazy season starts about January 1, but it lets up on December 31.

Off to another meeting to tell the finance guys they should not have permissions to...

This sounds like a job for Extended Events.  In order to get more information, you should probably set up an Event Session to collect Login Events from this particular ID. ...

This can be done with a simple (ok, not quite simple) LIKE statement.  In the below example, the [0-9] elements mean any digit.  [^0-9] means any non-digit.  Part of the...

• This reply was modified 5 years, 4 months ago by  crow1969. Reason: Added a caveat for 7 digit numbers

the timing of any transaction at the subscriber would depend on the subscription agent running.  It could be that the subscriber agent is set to run on a schedule, or...

This should be a very simple metadata operation.  I have to admit, I have never seen anything like this, either.  Is this a blocking issue?  That would not surface in...

----- Q) is it to deny any connection to role while restore is in progress?

This is to prevent connections for members in the server role ROLENAME.  As this is only...

What sort of replication was set up?  Transactional replication, or snapshot?  Under transactional replication this is difficult to understand, unless you are somehow getting index rebuild commands sent to you...