Not to different filegroups no.

Got to watch out for MSDB history purges too...

When you add a datafile to an existing filegroup, the SQL server will balance the storage across the files automatically. It won't move old data to the new file,...

When a VDI based backup is taken, cache memory on the device taking the snapshot is used to hold the current and new disk i/o in. This allows for...

I'm leary of third-party stuff myself and prefer to do native backups. And the person in charge, really should know how thier recovery process works (or should work).

Agreed. Testing is very important in this, you don't want to impact your production system by taking the BCV's...

There is a possibility that they're using some kind of disk-level VDI based backup, and the possibility that they could be using an "agent" that backs up the database...

The OP...

We've got an EMC Symmetrix and are using Replication Manager as a front-end to Timefinder to do single-SAN BCV's of our core db servers for reporting purposes. It took...

Pat, do you need the reporting of the login failure > 5 as it happens or do you need to be able to generate a report to show auditors?

N J (4/10/2008)

---

In Sql Server 2005 you can use logon triggers and direct the result to temporary table. Finally query table to find out logins with more than 5 failure...

See...

Mark Avis (4/9/2008)

---

When you are connected to Microsoft SQL Server 2005, you can click View only when Log to table is checked. In this case, the job step output is...

You're quite welcome.

The script can be compiled as a procedure easy enough, just add the appropriate CREATE statement. Once you have it as a procedure in a database you...

The bummer about DTSBackup is that it doesn't retain the text-formatting that is in the packages...hence the reason I put together my proc.

I've used this for migrating DTS packages saved in the MSDB to file... You need a copy of textcopy.exe and a valid Standard auth. account on the SQL server,...

This is a procedure I wrote some time ago to delete files from a fileshare older than n-days.

IF EXISTS (SELECT [name] FROM dbo.sysobjects WHERE [name] = 'usp_Admin_Delete_Files_By_Date' AND...