Truthfully, I would get support from company or consultant that is familiar with performance tuning and troubleshooting. This is something that can go back and forth trying to get down...

To me that sounds like a bug in the version of NetBackup you are running. I would verify what agent version is running on the server and then check what...

If it was connection to the AD controller I would think the message would be more toward a type of login failure, not necessarily access denied. Access denied would tell...

Afraid not, the only thing I could find in my testing is that a table in msdb keeps up with the version build but it does not give you any...

Alan.B (5/5/2015)

---

I'm not trying to belittle Shawn's solution as he was just fixing your code.

It is worth noting, however, that sp_MSForEachDB is undocumented and you should never use...

You will have to use sp_executesql to execute it:

EXEC master.dbo.sp_MSForeachDb 'USE [?]

IF "?" NOT IN (''master'',''model'',''msdb'',''tempdb'')

BEGIN

SELECT ''?''

DECLARE @query nvarchar(50)

SET @query = ''CREATE SCHEMA [T_schema]''

EXEC sp_executesql @query

END

'

Yeah, could be on modifying the logical filenames and show a few examples of...

I can tackle this one. Interested in doing it only in T-SQL, or possibly PowerShell/SMO as well?

Koen Verbeeck (4/29/2015)

---

1. There is no need to shrink them. If your transaction logs are full, take transaction log backups.

(and how big can the transaction log for the model database...

sqlcmd

SQL Server PowerShell

.NET + PowerShell

SMO + PowerShell

You can take a look at the MSSQLTip I wrote on missing services from SSCM[/url].

You can likely look under services management console (services.msc) and see Browser service listed there. If...

I do not have direct access to the specific SQL server instance, so I would like to be able to construct an email telling which numbers I am interested in...

There is no connection made between the login made in the connection to SQL Server to the Windows Login that may have initiated it from the client end. This is...

Polymorphist (2/6/2015)

---

So I think this is an account issue with Powershell trying to access Excel via a launching user. While i'm not sure that I quite understand the mechanics...

I have a client that uses DPM for all of their database servers, including one using AlwaysOn Availability Groups, and they do full and log backups. I have been told...