Are you using sql 2000 or 7.0?  Is there a clustered index on the table?  If not that is probably your problem.  It needs to be a clustered index.  The new...

Is the maintenance plan doing anything else?  Reindexing, consistency checking?  There are many scripts in the scripting area that seem to do a much better job at managing backups then...

Is this a maintenance plan that is running?

Most of the 3rd party software that I deal with needs sa login for install.  During installation they usually create a bunch of backup jobs and maintenance jobs.  These are...

Page density is fill factor, at least to begin with.  If I build an index and specify a fill factor of 80 then my page density should be 80 to...

As Colin stated, are you sure it is the Sql Service that is running and using all of the CPU.  Go into task manager and make sure no other os...

The scan density is about as good as it gets.  Closer to 100% the better.  I'm not sure the syntax in the command your using but the avg. page density...

In either case you will have to apply the logs individually.  When doing restores I generally do not use the wizard.  I will restore with norecovery until I have applied...

Why do you want to create a bunch of individual files.  One file would have everything you would need to restore the database to a point in time.  If you...

I find it best practice to backup every database every night.  Run the consistency checkers once a week, and reindex when you can.  I have several systems I can reindex...

I would imagine that it is being blocked by another process.  Possibly an index build or a dbcc command.  What else is running when these are being blocked.  Have you...

I'll put a timeline together for you.  Maybe that will simplify things.

5pm-Start of Full backup job. 

        --Copy existing transaction log file to backup directory.(overwrites previous days tlog backup file.

       ...

You'll need to still run the trace and determine which sp's are using the temp tables.  Depending on the size of the temporary tables you can create indexes on them...

Sounds like a homework question. You'll need to look up the left join clause.

Tom

When I do my log backups I take a full and backup the transaction log with init, to initialize the tlog device.  I then append all tlog backups to that...