I'm having a difficult time following exactly what occured in your test, but it looks like the truncate you attempted in step 6 did not succeed, therefore the log sequence...

What are the four files?

All databases must have at least two files, an mdf (data) and an ldf (transaction log).  They can also have one or more ndf (additional data, or...

I don't know where my head was, but it certainly wasn't where it should have been.  That first sentence is WRONG!  A transaction log backup contains the transactions that have...

There is a difference between shrinking and truncating a log file.  Truncating (done with a transaction log backup) removes inactive transactions from the file.  Shrinking removes unused space from the...

A transaction log backup contains the transactions that have occured since the last backup was taken (full, diff, or tran).  It keeps track of this using an LSN (log sequence...

CAST was not added to SQL Server until version 7.0 .

I agree that Bob's solution is excellent, and I'm not going to say that this is any better, just a slightly different take.

You could subtract 21 years from the current...

Can you cut and paste the text of the message?  All I see is a red x.

Steve

Script an existing job (right click on the job, select "all tasks", select "generate scripts", "preview", and "copy", then paste into query analyzer) to get the syntax, and just make...

I'm not sure about handling across servers, possibly master/target servers.  But you could use sp_start_job for your dependencies.  Just add a step to Job A that fires Job B using that...

These changes can be made without restarting and are painless.  The main consideration is if the database is "owned" by a 3rd party application, making any changes could void the...

Try this...

select @Total = sum(amount) from customer

Steve

You can restore the database to the second server without changing the logical filename.  However, you should change the physical file name.  Use the "WITH MOVE" clause in the restore...

I know you said you want to use operating system command.  But, if you were to write it in SQL, you would have more flexibility. 

Example: You could call your...

Just to focus on the Windows 2000 command part of the question, I have found a couple of resources quite valuable.

http://www.jpsdomain.org/index.html?winshell/winshell.html

and the book "Windows NT Shell Scripting" by...