Phill,

I changed my job to alert on replication 14151 errors as you suggested to execute this step:

declare @Msg varchar(4000)

SET @Msg = 'Error: [A-ERR]' + CHAR(10) + 'Severity: [A-SEV]' + CHAR(10)...

Steve,

Could the computed column possibly have a _WA* system created statistic on it? If so, I believe this also causes the index rebuild step of the maintenance plan to fail....

Steve,

We have had the same error occur on reindex step of a couple of our maintenance plans, and the error is a result of having an index on a computed...

Phil,

Can you give me an example of how to raiseerror to test the modification to the job?

TIA....Michelle

Thanks for the advice Phill. I'll give it a try.

Michelle

David,

Thank you for the quick response and the information.

Michelle

I am getting ready to install Reporting Services for the first time on one of our servers, so I am by no means experienced in it. In reading through the...

Do you have all databases selected for backup? If so, and any of those databases are in simple recovery mode the transaction log backup will fail, which causes the backup...

Viking and Ian thanks for your responses. I attempted the solution of setting the databases to BULK_LOGGED before the optimization job to minimize the growth of the transaction logfile. Little...

You could also use a stored procedure like the one below, with changes to fit your situation and schedule it to run periodically.

create procedure dbo.sp_dumplog

@dmpdevice varchar(80)

as

declare @db varchar( 40)

declare @name...

I believe the system error 112 is telling you the disk you are trying to restore to is full. You should check your disk space to make sure that you...

Thank all of you for the responses. One of the first things I did was look in the event log as I thought it was probably a hardware issue. Unfortunately, the event...

I did look in the event viewer for any disk or hardware errors, but didn't find any. We will be running disk repair on the affected volume next week and...

Thank you very much for the response. As a matter of fact we are planning on running a disk repair on the volume where the corrupted databases are located next week. Fortunately, we...