To quote a friend of mine, "I'm like WOW"

I am so glad I asked the question. I did not know about the Central Management servers. That is so...

Sweet!!!!!

See what I get for just asking. Even though I thought it might be considered a dumb question, I thought I would ask anyway. I'm glad I did.

Thanks.

Steve,

I will do an impact analysis for each server. I will weigh pros and cons about getting rid of the maintenance plan and creating a new script.

I appreciate the...

Excellent point Gail. That was exactly the impression that I got.

If it is not broken, don't fix it unless there are more options we could add.

Got it.

This has been...

Steve,

Thanks for you feedback.

I am busy and by no means just have time to waste. However, if it will benefit our company in the end, the I will look...

Gail,

Thank you very much!!

I was going to buck the idea, but your advice was what I needed. I will be open to the idea of creating our own scripts....

Thanks Lowell for the feedback. I appreciate.

But we had backups of the databases.

Now the SAN did have an error, which is why SQL crashed in the first...

Yes and that is the thing.

That was one of the first things I checked. They were all set to full!

Thanks though for the feedback!

Tony

I found the problem.

We had to manually change the sid. Here is an example:

use msdb

Update msdb.dbo.sysssispackages

Set [ownersid] =suser_sid('domain\owner')

Where name='- Incremental hourly backups'

This stopped the owner from changing.

Luke,

The GUID is the job name. The job is automatically created when you create a subscription. How do I know which job got created for which report subscription?

Thanks,

Tony.

Hello,

I was trying to figure out what was going on. I ran sp_who2. I noticed that a process was blocking another process. This was happening in MSDB.

I...

Thanks everyone.

I appreciate your help and I got the query working now. Here is the code I got to work:

ALTER procedure spGetBirthdays

( @birthdateSTR as varchar(10),

...

Hmmmmmm,

Now that is embarrassing to say the least. Oh well, at least I am still able to learn.

Thanks Gail. It worked perfectly.

Tony

(A very embarrassed Tony)

Here is the sql that I ran (doctored up for company privacy)

DECLARE @BakDate as datetime

SET @bak1 = '\etworkserver\backup\bak\mydata\mydata.bak'

RESTORE DATABASE [MyData]

FROM

DISK = @bak1

WITH FILE = 1,...

Chuck,

That looks like an awesome script. I need to study it some more.

Thanks.

Tony