On 32bit systems \PAE switch is required to use memory that is >4 GB. i.e if the Box has 16 GB, in order to make the windows server to use...

What is the size of the datafile and what is the DBCC option you are using to shrink the data file?

Best Regards,

SQLBuddy

Check if the the disks with the db files are accessible or if you have any network issues with those drives if there are on SAN.

...

Hi Derrick,

Clustered index can be created on a single column and it is...

Gail is right.

First, Select * should be avoided. Only the required columns must be selected within a query .. not a column more.

Creating an index by including each and every...

Check the tempdb size using sp_helpdb.

Tempdb Cannot be shrunk if there are any active transactions running.

Check for any open transactions using DBCC Opentran. Sometimes these transactions needn't be long enough...

Use Sp_helpdb.

Best Regards,

SQLBuddy

What is the Memory size on the Windows server and is your SQL server 64-bit ?

...

Right. Do you have the backups of these dbs going into individual folders ?

...

You don't find any errors in that Log?

Then check whether the agent has access to that backup directory?

...

Maintenance Plan Logs ... check this folder

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG

Thank You,

Best Regards,

SQLBuddy

Be Confident.. Understand the Business.. Know how things work... Know Change amd Incident mnanagement processes ASAP... ASk for any documentation that exists about their environment and check for failed...

Use the default trace as steves mentioned.

Thank You,

Best Regards,

SQLBuddy

Could you check for any errors in the MP logs.

...

Steve is absolutely right.

Thanks & Regards,

SQLBuddy