Rather than post the script I've found the link - see below.

http://support.microsoft.com/kb/246133/

Hope it helps

Hi

We've just done this exact process, ie move all our DB's from 1 2005 box to another and I found a login script that worked very well. Not only does...

Found it - finally.

Whilst the SQL agent on the old and new servers, run under local system account, it clearly uses the security from the SQL server service? On the...

Foiled again I'm afraid. The TSQL for the new plan is:-

EXECUTE master.dbo.xp_delete_file 0,N'\\cerium\dbdumps',N'BAK',N'2010-05-06T09:10:58',1

EXECUTE master.dbo.xp_delete_file 0,N'\\cerium\dbdumps',N'TRN',N'2010-05-10T09:11:24',1

It didn't work

The old server plan is as below:-

EXECUTE master.dbo.xp_delete_file 0,N'\\cerium\dbdumps',N'BAK',N'2010-05-06T09:12:06',1

EXECUTE master.dbo.xp_delete_file 0,N'\\cerium\dbdumps',N'TRN',N'2010-05-08T09:12:21',1

Just ran this and...

Hi

I checked all the obvious things such as a . before the BAK and TRN, permissions to the remote server, space on remote server, changing BAK to bak, adding a...

I know it's a bit obvious but it might be worth checking the SQL logs on the server you're trying to connect to. If there is a problem with remote...

I had a similar problem and it turned out to be because the SQL Server Browser service was not running on the SQL server I was trying to connect to....

Hello

We've just moved to SQL 2005 64 bit and the cleanups are not working (as seems to be the case for a lot of people).

We're on SP3 so does anybody...

Hi Chad

It's a strange one and not sure why it only does it on that new instance. However, I've had to move the databases to one of the existing instances...

Hi Chad

Sorry to bother you again on this, but I've added a new SQL instance recently and whilst it appears in the reports fine, for some reason the system databases...

Hello Chad

That's great - hadn't spotted that extra update was required and all is fine now - you're a star!

I did give myself a panic moment though by gleefully removing...

Hello Navendu

They're probably still sleeping over in the USA so thought I would post the link where you can download powershell for windows server 2003. My server is Windows...

Hello

I think I did that bit right because when I looked in the table dt_dim where it had previously had Nulls for the weekends, it now has the dates...

Hello Chad

I've tried to change it so that it picks up the backups over the weekend but I've failed miserably!

Could you advise what I need to do to modify this...

Really really helpful and well written - thank you very much.