Just as mentioned, you would need to look at the root cause for the CPU peaking.

Monitor the workloads. If all your BI cubes et al are built after the...

You can try WMI scripts to remotely change the connection info. How are you storing the connection information?

Please refer to https://msdn.microsoft.com/en-us/library/ms143412%28v=sql.110%29.aspx

A VM should be sufficient for the test machine. That way you are not restricted by future growth

Are you accessing the report manager internally on the server that has SSRS installed or externally?. If the there is firewall issues connecting externally, you can RDP to the server...

SQL Server Availability groups set requires two or more standalone SQL Server with its own storage.The fail over cluster method users shared disk and SQL Servers are also set...

You create table and stored procedure to do this. First populate the table with the name of all the files in the folder. Then call the stored procedure to do...

Each schema is associated with set of users and permissions/access can be set up easily for particular schema by functionality/usage

Form the link information provided, yes it can set up between two data centers thru SQL Azure in the cloud. More info at https://alexandrebrisebois.wordpress.com/2013/05/23/windows-azure-sql-data-sync-is-this-service-right-for-your-database/

rstone - I stand corrected, we should never not select 'application aware processing'. If its done, the OS might be consistent but not application. This is the case even when...

Please try to copy the install files from CD to your C drive and run 'As administrator'. Let me know if it works

Error show 'Unable to refresh Database Mail profile . (reason: No mail profile defined)'. Did you configure a database mail profile. Please follow the link on directions http://msdn.microsoft.com/en-us/library/ms187605.aspx#SSMSProcedure

What is the server role and permission for that id?

How are you calculating the query timeout as 27 secs?

SSC-Addicted nice points and links. I posted two responses separately.Yes, totally agree on your points that its needs to be tested with restore. Logically, the following might work.

1. Only Veeam...