You can do that which Jeff suggested, as well.  However,it is under the "Query" menu option, not "Tools".  Thanks.

Chris

I know in SQL 2K you can go to the Query menu item in Query Analyzer and specify that the query be outputted in text.  The column headers will be...

Could it be that the duplicate data is coming from your insert?  Not the data that already exists in the table, but that which you are trying to insert.  Look...

Thanks for the feedback, everyone.

Chris

Good morning.  How do you most of you decide to use openrowset versus bcp versus DTS?  Thanks.

I found this via a Google search:

SELECT Column1, column2

from table1

where column1 in (SELECT min(column1) from table1 group BY Column1)

It seems to work for my purpose.  Any thoughts.  Thanks.

Chris

Andrew, just be sure -- double check the schedule -- that your restore job runs after your backup job.  Other than that, I don't know what else to tell you. ...

Andrew, was the first part successful -- the full backup and restore?

If so, the worst case scenario is to just re-create the log-shipping job.

Thanks...Chris

Andrew, was the first part successful -- the full backup and restore?

If so, the worst case scenario is to just re-create the log-shipping job.

Thanks...Chris

You can also use the DTS ftp task to transfer the file.  In DTS, you can check to see if that step was successful.  I hope that this helps.  Thanks.

Chris

Good morning, Andrew.  As for getting your log-shipping back on track.  Stop (disable) all log-shipping jobs (transaction log backups and transaction log restores).  Next, take a full backup of the primary...

I'm also encountering a problem with blocking.  The problem is that when I run DBCC Inputbuffer with the id of the process that is blocking, there are no results (I...

Excellent advise, everyone!  Thank you VERY much!

Chris

I really appreciate everyone's responses, thus far.

The log-shipping is purely for maintaining a warm standby server.  So, using the SAN can eliminate the need for this, right?

Colin, I understand your...

OK, here's my understanding of using SAN backups to recover from a disaster.

- SAN takes backup of database files (.mdf, .ldf, .trn)

- the SAN array can be attached to the...