Are you using a SAN? The Storage Admins might have some options to help you through disk mirroring and/or snapshots. It worth talking to them if you have any...

If you can add your account to the local admins on the server and start the SQL service in single-user mode you can access the server and then reset the...

Check out the articles available here in the Stairway to SQL Powershell http://www.sqlservercentral.com/stairway/91327/

I've never used or seen CyberArk so I can't comment on that.

Here are a few links to get you started:

http://www.mssqltips.com/sqlservertip/2946/centralized-ssis-solution-to-monitor-failed-sql-server-agent-jobs-across-the-enterprise/

https://www.simple-talk.com/sql/sql-tools/registered-servers-and--central-management-server-stores/

http://ask.sqlservercentral.com/questions/34972/central-management-servers.html

Hi Anoop,

I've set something like this up a couple of times now. I've set up a Central Management Server on a SQL Server and used that to do the...

And where in the question does it say that the fellow DBA is working for the same company? I regulary get asked questions from fellow DBAs in other companies.

Happy to help. I'm glad it worked out for you.

It's quite easy to set up. Switch to the Alias tab and then click Add. The entry for "Server alias:" will be the Production server name, the entry...

How many different production server names are going to need to be changed in the reports and data sources? The reason I ask is that you could use the SQL...

Changing model won't affect any of the existing databases on the server. It will only change the initial file sizes, recovery model, etc for any new databases you create...

That is only if you accept the defaults. I normally leave model as it is and size the new databases appropriately in the create database script. If you...

SQL Server Management Studio 2012 connects to SQL 2000 server instances without any issues for me.

I agree. I also find it much easier to deploy jobs using scripts to multiple servers compared to maintenance plans.

Well the transaction log backup job has been running...

I'm sure that many progressive companies running on SQL 2012 also have previous versions of SQL still in use. I know we do. We have all versions of...

The backup is configured using a SQL Server Agent Job calling Ola Hallengren's DatabaseBackup stored procedure. The job has run every 30 minutes for months without any issue until...