It looks like there are several issues. What is the hottest issue at the moment?

Is the backup software causing problems on the DB server?

Leaving this place to work on your project would...

I have also experienced this error. Unfortunately, I did not find a work around for the problem.

The scheduled update statistics in chunks, (A..E, ect) will have to be checked to see if it is working OK.

It could be that the general design is to spread the...

After the step in QA, reconfigure with override

Will the SQL Server instances need to be cycled to pickup the configuration changes?

If boot.ini had the /PAE...

OK. The goal is to equally share the memory resources accross both instances.

We all agree that for this 8 GB box with two SQL instances:

In boot.ini: have the /PAE switch

and...

Your post was for 6 DEC.

Do you still have an out of sync log shipping operation?

If you do, you might want to plan to remove log shipping and re-create the...

Hi Noelle,

You mentioned that you wanted to run TLog backup for the system databases.

msdb and model are OK. master does not permit a TLog backup.

Or, do you have another issue?

--5/28/2004 1:48PM

--Clark Cruz

There are two situations:

1. Planned Failover

2. Unplanned Failover

Unplanned Failover

In an unplanned role change like in the case of site destruction, recent transactions...

Possibly, the rolling occurs on the primary databases due to some error or poor query execution that SQL is rolling back. Bundled in the transaction log and shipped to the...

If you still need help, and you are willing to trust me, then provide me

the name of the database, and I will send you a procedure to truncate the log.

It could be the security permission for the  job. Set the user to sa. See the article below.

PRB: Unable to Back Up Database to a Network Drive...