Well... looks like there has never been any cleanup.

2006-02-27 18:27:52.000 is min backup_finish_date

Thanks for your patience folks... new to this.

So, in my new Maint Plan I have a "Cleanup Task"...

sysjobhistory498

sysjobs 26

sysjobactivity427

sysjobsteps28

sysjobstepslogs0

sysjobschedules18

backupmediaset13596

backupmediafamily13596

backupset38492

backupfilegroup38481

backupfile76992

So... is every backup ever done tracked in the "backup..." tables? Seems pretty large.

Hmm... hadn't looked into that.

Now that I do I see that it is set to "Limit size of job history log to:

Max Log Size = 1000 rows and Max History...

This is still an issue for me... In addition, my MSDB has grown to about 10GB.

Should I expect this after establishing a Maint Plan which runs full backups nightly for...

Hi Sorry for the double post...

I will try to copy the file to the UNC in a bit - we have actually just been evacuated from our building and...

Actually I just created a new maint plan on this server and it is scheduled to clean up files after 74hrs. There are quite a few DBs in the...

no problem... glad you finally found the issue.

Have you restarted the server since modifying the Surface Area Config? Not sure if that will help... down to grasping at straws I guess.

Here is a blog I have...

On the destination server... type

netstat -an

in a command prompt. This will show you all IPs and Ports on which your server is listenting (as well as any...

Hmmm... double check the Surface Area Config to ensure remote connections is enabled (I think you already did that).

Try the IP instead of the server name.

Try to fully qualify the...

Hi...

Couple of follow up questions:

1. Can you ping the destination SQL server from the Source SQL server?

2. When you say "cannot connect from the SQL...

Right O... that was my expectation. However, I don't see them in the Object Explorer unless I actually import the dtsx file from SSIS.

Thanks... just a curiosity as I'm learning.

Oops, sorry for the misinformation.

I assumed becasue the tables were consistently empty it was only used as needed.

Thanks for the link to the article.

I believe the ReportServer TempDB is a "scratch" db and shouldn't need to be parrt of your backups.