OK, I have tested and the following files in the same dir as backups :

testdocbakinfilename

testdocfilename.bak

testdocwithbakinfilenameand.txt

are not removed during cleanup.  I have a feeling (maybe read somewhere) that the cleanup actually...

Diwakar, as I mentioned in my last post you still need to grant exec permission to the proxy user (in your case cmdproxy) on the xp_cmdshell proc which is in...

I have left the time in and removed the '.' This 100% works for me.  I have gone back to the maint plans and removed the '.' from these to,...

Hi, I know its a late post to this but I had same issue and I think the above fix may be a bit misleading.  I tested as above removing...

ok try this.  create a maint plan via the gui in em. Simple check integrity then backup all system databases.  Modify logging to appropriate directory.

Right now export that package using...

Oh by the way Rudy ru sure its TCP 445 not UDP ??

Thanks very much Rudy, I will try 445 hope it resolves.  Yeh if you could advise other port info that would be great.

Thanks again.

Derek

Ahaha, Steve this was the memory jog I needed re my post to your article on separate service accounts (best practices).  If you use separate accts for each instance (best...

Yes sql2000 supports multiple collations 'each of which can be set to a different collation' at the sql instance level, the database level, the table level and columns within a...

Thanks all for responses.

1. Yes network protocols are enabled, I am able to connect via Management studio all other functionality exists.

2. I created new registrations for all 2005 instances but imported...

Steve, I pretty much agree on all items you raise and have pretty much adopted this for my installs of sql2005.  I also adopted this for sql 2000 where I...

Uh You might have been a little more specific in your question.

anyway, do the same thing via the GUI and then in the backup dialog screen ensure you select what...

That allows change of a databases collation not the sql server instances collation.

sp_who2 will probably fail as well.  Usually caused by locking on tempdb