Just curious, does the test e-mail option located in the Sql Server Agent properties work?  This is found under Agent>Properties>Alert System (tab)>Mail session

I have removed mirroring in Prod a few times with no issues.  To rest your worries and fears you could:  1) Take a fresh new full back up of the database(s)...

Again, as others have said, you want to avoid auto-growing at all costs due to the performance hit.  Without knowing your environment or application, I would set the initial size of...

You are pointing to (use the use statement) the correct database where this Invoice table exists, correct?

For the Logins, you could use sp_help_revlogin to script the logins from the source and create them on the destination.  For the Sql Server jobs, you can script out all...

Hi Mike,
To restore a database to an AOAG cluster, you would:
1) Remove the database from Availability Group
2) Drop the database on the Secondary
3) Restore the database on...

You won't see the available space after deleting data until a shrink occurs.  Most experts agree, as long as this is a one-time shrink, and the data is not expected to grow...

If I was in this situation, I would not add additional data files to tempdb for the reason of avoiding the IO messages in the sql error log.  I would...

Experts say, rather than do a verify, simply prove the backup is a good one completely by restoring it, where if the restore is successful, you've proved the backup is...

From Management Studio - go to the properties of the Availability Group, under the general tab, in the Availability Replicas section under Availability Mode.

When we did a similar thing, we simply stopped the connectivity of the applications to the databases first, then went into FCM (Failover Cluster Manager) and executed a "Stop Role"...

I would start here - https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/start-stop-pause-resume-restart-sql-server-services

Hi, could you post the exact error message?

I think you will find if you set the Database Compatibility level in the options of the database you are running the query against to Sql Server 2008 R2 (the old...

We always used add/remove programs to uninstall.  You may have to reboot after each remove and revisit add/remove programs afterwards until anything with "sql" in the name no longer exists...