I'd suggest to backup to a local disk and have EMC back that up, clearing the local backups to purge every 2-3 days or so, whatever your space will allow...

Jacob, Northern DBA and Maddave, many thanks to all of you for contributing on finding a solution. I have more than enough info here to get what I'm looking for....

Jacob and Northern DBA, thanks for answering my post, your time is very much appreciated. I'll explain what I'm looking to get.

Say I have a SQL instance. It has 6...

I just realized the join (from msdb.dbo.backupmediafamily b join msdb.dbo.backupset c on b.media_set_id=c.backup_set_id) was not correct, bad oversight on my part...

select CONVERT(CHAR(100), SERVERPROPERTY('Servername')) AS Server,a.name,File_Location=b.physical_device_name,backup_start_date=max(backup_start_date)

from master.sys.databases a

left join(select...

I wish I had an answer but I've run into SSIS packages that were stored in MSDB and found the same issue. If the package is located in a folder...

I ran into the same issue when someone restored some databases to the wrong server. I was never told how this happened or how they were removed. They didn't embellish...

Are the two servers on different domains? I've seen this when servers are built or SQL is installed on the same domain, then one is moved to another domain etc...

As...

I've had a long discussion with EMC about the Avamar backups. They ensured me that there are no DBCC commands and suggested I run this on my own for the...