can you also do a DBCC CHECKALLOC and post the results.

Do you have multiple data Files or so you have partitioning of any kind.

Check this out:

http://support.microsoft.com/kb/301292

How did you land up with a SUSPECT Database. There should be a hint in the errorlog or event viewer.

use can use the sp_resetstatus (dbname) SP to recover from a...

When doing a DBCC DBREINDEX consider a friendlier Fillfactor. There is no rule, but generally it goes like this: If you have a highly transactional system and have often Page...

Do you have Huge tables?

Do you use lookups to join those tables.?

Is your server 32-BIt and which SQL Server Edition do you have? ENT/STD/.

Which service pack are you on right now.

What Does the SSIS PAckage do?

Steve is right,. What kind of issues are you having with the Server, is it related to connections or Timeouts etc..

Check out more in BOL, and go through the literature...

THere is no definite rule about changing the default values:but yes thread pooling can help optimize performance, if you are getting congested on connecton, try increasing it to 2048 on...

Try covering indexes

Right Click on INDEX -> Property--> Columns and then specify the columns to be used in the index, try to choose numeric type columns for better results... This...

indexes is a good strategy, try to accomodate and use covering indexes to improve query performances....

Also Look into Table partitioning and multiple filegroups.

you can use this and manipulate this query to code as needed..

DECLARE @GENRANDOM nvarchar(9)

SET @GENRANDOM =LEFT(SUBSTRING (RTRIM(RAND()) + SUBSTRING(RTRIM(RAND()),3,11), 3,11),9)

--SELECT SUBSTRING(@GENRANDOM ,3,1)

SELECT @GENRANDOM as 'RANDOM_NUMBER'

Strange, but here is what i went through. not exactly as your situation...

I had a 70GB DB FULL Backup happening at 2.00AM, same time there is a Transaction log...

As suggested, try a restore on another box.

This 42000 error generally means or relates to consistency errors..

Just Curious: Was this backup file already created or were you trying to...

As Matt suggested, go with the DB SNAPSHOT, insted of landing up with complex solutions to Simple problems.