In SQL 2008R2 forward, you can create an audit specification and record the logs in the Security Log on the Windows server. This will not be able to stop...

I discovered an old SQL Express instance backing one of our virtual environments, and needed to upgrade to SP4 in order to further upgrade to SQL 2012 Express. Your...

I've been using NetApp SnapManager for SQL for almost 2 years now. Like all snapshot technologies, it is quick, handy and useful when it works, but should not become...

I've been using SnapManager for the last year after inheriting it with the job. It works great ... when it works. SnapDrive is a moderately unstable dependancy of...

Hi Massan,

Here's a script I use to fix the orphans issue during migrations and DR recoveries. The assumption here is that the db user will have...

I see nobody has replied ... I never get any replies when I post questions concerning SnapManager backups either.

What is the purpose of the " ,'0' " in...

The last time this happened in our shop, the Exchange folks had enabled "require authentication" at the Exchange server, and we were using smtp on our sql servers.

The fourth statement is 48 characters long, hence when stored in a varchar(45) variable, it is truncated at character 45 resulting in a syntax error due to the last character...

Have you checked your disk space on the target server? I've seen sql server grind to a halt during such a transfer when it ran out of disk space....

Just a thought, since you are getting degraded performance in a query that executes using parrallelism on a new server install. Have you checked the max degee of parallelism...