Michael,

The recovery model is simple - and I don't think that anyone has control over making it not Simple.  As for truncation, it is as if it does not happen.  How...

Michael,

I just ran sp_configure - the configurations on the two are identical.

As for temp tables, they appear to be constantly created and deleted (i.e. as I run the command[select * from...

Michael, thanks for the suggestions ... I'm looking at it right now.

As for the restore, we basically have 2 servers with identical settings.  One of the servers had to go...

I believe you are a bit confused.

Backing up the database does nothing to the transaction log I believe.  You have to back up the two separately.  Also, the two could...

Guys,

Thanks for the replies, but I am still a bit confused.

Are you saying that the owner of the job should be a user with priviliges to access both servers?

Thanks a...

This is very useful indeed.

I have a question though.  I need to change the excel spreadsheet name every day (i.e. I want to dynamically incorporate a time stamp in its...

Thanks Steve ... I'll go with your suggestion!

Yes, I am aware of that.

Thank you

Thanks for the suggestions guys.

Steve: I am reading your link now ... very useful!

I don't think it is possible, other than restoring the whole db somewhere, and then copying the table over to wherever place you need it ...

1. Backup NGPROD (or if you have a good backup already, it is not necessary)

2. Restore  this backup, wherever necessary, with a different name.

Thanks for the advice.

The puzzle has been solved by using this tool: http://vyaskn.tripod.com/code/sp_show_huge_tables.txt

I identified that I had one table not purged for a long time...

Guys,

The puzzle has been solved!  Before we even had this new server, the old server was made faster by performing a memory change, as described here: http://support.microsoft.com/kb/274750/.

We did the...

Michael - very well described!

One possible thing to do [to add to what you said] would be to process things in chuncks.  If, for example ,you need to perform a huge...

David,

I ran this command in both - old and new environments and have the results (~100 rows of data).  I don't think its good idea to post so much stuff...