After the RESTORE DATABASE command to utilize your database backup from 10 pm, issue a RESTORE LOG command.  (See RESTORE in the BOL)

In some cases you might be able to...

OK.  I'm running a bit slow today... I re-read your original post and I believe this is what you were looking for (modify to suit your needs):

USE pubs

GO

SET SHOWPLAN_ALL ON

GO

--...

This is just a WAG, but I believe what you're looking for is

SET SHOWPLAN_TEXT {ON | OFF}

Cheers,

Ken

Sorry about that.  I meant Full.

I have a "rest-of-the-day-plus-a-half-hour" meeting in about 15 minutes so I'm sure I won't see your reply until Monday, but check the Database Maintenance Plan History for your job.  Is...

Is SQL Agent running?

Giving this a little more thought...

If the dump and copy work but you're not seeing error messages on the load - or, in fact, no messages about a load at...

Please forgive what may be an odd question: why do they need to capture passwords in the first place?  If they need and deserve the SA password, they just need...

Around SP2 (I think), M$ discovered that SQL Standard could still participate as a target in Log Shipping.  They put the brakes on that real quick.  So, the point: What...

That's really curious.  I'd been using log shipping for quite a while now and after the initial stumbling it seems pretty solid.  The fact that all necessary jobs show success,...

I'm not sure who posted this question, but if you're looking for a scanning tool, try http://www.sqlsecurity.com - click Tools/Free Tools and look for SQLPing2.  You might also try...

For this example, I'll use:

  E:\MSSQL\Data for your new DATA location

  E:\MSSQL\Log for your new LOG location

  <ServerName> for the SQL Server you will be working...

For what it's worth...

Can you "batch" your deletes into more granular segments?  The faster you commit your deletes and run a checkpoint, the smaller you can keep the log.

A Day in the Life of a DBA

   A day in the life of a DBA is usually quite hectic.  The DBA maintains production and test environments,...

I'll give you two items as food for thought.

1.) VB has a SQLDMO library available.  Write your own SCRIPTXFR.EXE.  I'm not a VB programmer but I was able to muddle...