I have also seen this issue and have not yet found a permanent fix for it. I did see something from Microsoft about this error but that deals with...

Terry,

I agree with everything that you said included your method for backing up to disk and then have the tape backup sweep from there. To clarify, the reason I...

One issue with it is that your Differential backups will NOT be tied to your FULL backup from Backup Exec. Differential backups are changes since the last full backup...

It is always best if you only have one system doing the backups. Otherwise you will always run into issues with which order to restore in. I would...

Did you ever get an answer to this? We are facing the same issue here.

Chad

The reason you see different values in status for your read-only databases is that the status field is a bit field. You can see most of these values from...

Did anyone ever find why this happened? I just came upon a server that also has no values in the dropdown. Same specs - SQL 2000 MSDE running...

I needed to change this code to make it a use a UNC path instead of just using the drive letter.

Select @vcQueryOutPath =...

You can perform a search on this site for "long running jobs" and find reference to many ways to do this. Here is one of the links I found:

[/url]

Chad

SP2 did nothing to resolve this here as well. I currently have my client tools and servers at SP2 CU4 and still have the issue.

Chad

I have a question about using the Microsoft SQL Server 2000 DTS Designer Components.

I have noticed that when I open a DTS package up using this that my SSMS locks...

The issue first addressed with this was not a DNS issue. It specifically had to do with cdo and SQL on a Windows 2000 server.

We worked with Microsoft and...

We never did find out why this happened. Our solution, as stated above, was to use a link server for sending out notifications. The local sp_SQLSMTPMail sp was...

Has anyone ever gone back and completed this to automate the process?  I would be very interested in it.

Thanks,

Chad

This can be done using the Options tab of the WorkFlow properties.  To see this tab you actually select the 2 tasks the workflow is going between and then Right...