driveletter is the share (d$). The account is a domain account: domainname\accountname. All of our IT accounts are domain accounts.

Everything looks to be fine, except the blasted backup won't run. Does it make a difference that the original server is 2005 and the target is 2000?

Both are running under our master account, that account has full permissions to the share on the target drive.

It's running as a maintenance plan

I am running this from SSMS on my machine on another server, trying to place the backups on a thrid server. I have the drive on the final target...

I'm getting:

DECLARE @GUID UNIQUEIDENTIFIER (a database is defined)

Access Denied (I have sysadmin on both machines)

Location does not exist (If it doesn't then I've lost an entire drive array)

I...

Every thing is the same. When I run:

sp_help_alert @alert_name='Type 025'

I get: "The specified @alert_name ('Type 025') does not exist"

When I run sp_add_alert I get: "The specified @name ('Type 025')...

No, they didn't show up in the list. The code shows nothing. sp_help_alert shows that they exist.

I tried the code change 'Severity' in the name to 'Type' and received errors that they all existed. I still don't see anything in the notification page.:crying:

Type 001, Type 007, Type 008, Type 009...Type 025.

SQL 2005

But, I just want to be notified of the standard alerts. For those, all I see is 'Enable All' and 'Disable All' and New Alerts, (that one has 'response')....

No. What I'm looking for is something that will let me look at each server and tell me if each database is backedup in a maintenance plan?

Thanks folks. If it's one thing I've learn in more than 30 years in IT is that there are always more than one way to approach everything. 🙂

Tim

Is revision 1399 the original release? :unsure: That's what on this server. :pinch:

Tim