I may be mistaken, but I thought the "upgrade" to Windows 8.1 was actually a full reinstall of the OS? One of our infrastructure staff here found this out when...

No, if the file is encrypted, you either need an unencrypted version of the file, or the keys used to encrypt it so you can decrypt it. Either way, SQL...

Is there anything in the SQL Server log itself from when the job ran?

Create a new identical job, but change it to doing a simple T-SQL select and then emailing...

Have you enabled the Database Mail Profile in the SQL Server Agent properties? This is a step I always missed when I first started out!

No, enabling/disabling any installation features does not need a service pack reinstall these days, thankfully that all went out of the window with NT, that had very specific processes for...

Can you give us more information on this relating to the disks, are they internal disks, SAN volumes, NAS etc. Anything in the event logs of the server itself around...

Yes, use SQL Search (it's free I think) as you're just rewriting that functionality really

EDIT: Even SQL Search doesn't check whether the searc string is commented or not.

I've run into this issue before with FILESTREAM, and it HAS to be locally attached storage. you just can't add a FILESTREAM location that is any kind of UNC path...

But you can restore the backup to another server easily enough, so I'm not sure what gains having a copy of the raw database files there are when you already...

I've had a similar thing before but with a site to site VPN between our office and the data centre where the tunnel to the subnet that the SQL Servers...

Are the clusters on the same network segment as your computer?

Yeah, I use the same approach as the others, I use AD groups to manage user membership and just apply the appropriate permissions to the AD group. It keeps logins...

As others have mentioned, I've run into this situation before and with the application running from a web server in our case. For security our SQL Servers run in their...

I've come across this so many times with the Import/Export wizard, because it's a very simplistic SSIS package. The import wizard scans the first few rows in the file and...

The db_securityadmin role at the database level won't allow him to create the SQL login though will it?