Right click the Maintenance Plan and select "View History". If that does not have enough information, please add an output file to the Job Step (under Advanced).

Agree with Gethyn. We cannot create it

I followed the same steps on an instance running SQL Server 2005. But I could not reproduce the issue.

sp_helptext gets the information from syscomments view.

You can extract the SQL Service pack binary and you will find several scripts.

Since...

The Service Pack copies new binaries and replaces the existing ones. After that is done, it executes certain scripts to update the system dbs/objects.

Looking at the error message already posted, the error seems like while applying some of the scripts during the installation of Service Pack, it is failing. I think the binaries...

vambati72 (12/7/2010)

---

has anyone come across this error and any solution :

Msg 3132, Level 16, State 1, Line 1

The media set has 2 media families but only 1 are provided. All...

@marc Bonjean,

Multiple backups will run simultaneously using different threads.

Is Query --> IntelliSense Enabled option selected? If yes, then you may try "Repairing" SQL Server in the "Add/Remove" applet.

The transaction log backups must be restored in the same sequence as they were backed up after the FULL backup. The log backup that you are trying to restore, was...

Please look for any errors messages in the log files located at C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG

Even I have a database where this error comes in whenever a particular tables is queried. Like in your case, the storage related errors are no where logged. Even though...

Please check the System Event Log for any storage related errors. This has to do something with the underlying storage.

Like you mentioned, restarting the instance will re-create the tempdb. If...

When Maintenance Plans are created, corresponding jobs are also created which will have the naming convention like 'MaintenancePlan.SubPlanName'. The changes that you are proposing should be made on the Maintenance...

Like you query sys.databases to find database information,...