One thing that comes to mind is you will have to reconfigure the endpoint URL's with the new domain information.  I suspect you will have to break always on down...

Check for any log backup jobs that happened outside of the log backup restore jobs that you expect to run. From SSMS you can right click the database name,...

Check out this page for information on SQL Agent roles defined in the msdb database:

https://msdn.microsoft.com/en-us/library/ms188283.aspx

Look for a procedure that runs at startup:

SELECT ROUTINE_NAME

FROM MASTER.INFORMATION_SCHEMA.ROUTINES

WHERE OBJECTPROPERTY(OBJECT_ID(ROUTINE_NAME),'ExecIsStartup') = 1

Thanks for the scripts, Eric. You just helped me with tracking down the culprit that was consuming all of the space in tempdb (about 70GB with 8 duplicate copies...

Thanks. Most of these are tracked in our ticketing system, so numbers and projects worked should not be a problem to find and report on.

What we do is well documented, and management is well aware that they would have issues replacing any of the DBA team (although none can make their way without preparing...

Thanks for the reply. Those could certainly come in handy. It would just be presentation that may be a bit challenging. I see pie charts that would...

This link https://msdn.microsoft.com/en-us/library/ms174396(v=sql.110).aspx indicates that if you use

select SERVERPROPERTY('SERVERNAME')

you should see the new name. In the remarks section on the 'servername' property you will find a statement...

We have found that once a database grows beyond 1TB striping is required, if only just to fit into our maintenance window. We currently have been backing up a...

You need to add the server name (the DEV team's server) to sys.servers (I am not sure how it is NOT there, unless the server has been renamed):

sp_addserver [new_name\instancename], local;

What output do you get On the DEV team's server (2008R2) for:

select * from sys.servers

What does

select @@servernamereturn?

Try:

Declare @ServerName sysname

select @ServerName = @@servername

Print @ServerName

This will explain and give options:

http://sqlperformance.com/2014/06/sql-indexes/hotfix-sql-2012-rebuilds