Isn't there an option to overwrite the destination file or not in the file system task?

We recently had this discussion and, after bringing in a well-respected consultant, it was decided that having a large pool of disks assigned specifically to SQL Server, configured as RAID...

Is this update required for an environment running SQL Server 2008 SP1 Standard 32-bit using AWE and PAE in order for Lock Pages in Memory to be functional? I...

We don't need much more than the alerting that we get from SQL Response and it works good for that. Hopefully the new version will be out soon. ...

We were using LiteSpeed and I switched to SQL Backup, mainly because of the cost for the annual maintenance of LiteSpeed. If there are any significant differences, and I...

I'd be very interested in hearing more about the NetApp issues that the one person (Andeavor) mentioned. Our Infrastructure group is considering NetApp and I have concerns about the...

Check this key:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Servic es\Tcpip\Performance\Disable Performance Counters

I had this problem recently and it was set to 1. After I changed it, I was able to load them using the directions...

I saw a suggestion somewhere to set the alert to .90, instead of 90. That resolved the issue for us.

I keep one full and the associated t-log backups local to each server and on our backup server. We also have a week's worth retained on that backup server...

Do you have a 64 bit version of SQL Server installed on the server?

I've attached scripts that I use that work well. There is one for SQL Server 2000 and one for 2005/2008.

I agree that it could be a permission issue and you just don't see any errors. When I have issues such as this with copying filee using xp_cmdshell, I...

You could drop just that article and then add it back and run the snapshot agent. That would basically re-initialize just that article. It wouldn't explain the issue,...

I think this is what you were asking for. I think the script tasks are easier to follow than the expressions.

Dim ExportFileName As String, ArchiveExportFileName As String

...

You'd have to look at the Properties of the share on the server and look at the permissions. Check to see if the SQL Agent service account has write...