Point of the question was actually to have you show us what you have tried. Post your code.

And what have you done to try and solve this problem?

It Depends. Not being familiar with your systems I can't really answer that question.

Please define what you mean by Julian Date. Sorry, but I have seen systems that have used that term and the Julian Date was a home grown representation.

Don't shrink your databases or the logs, unless you have done some one off processing that may have resulted in excessive growth of the log or significantly decreased the amount...

I can purchase a single license of SQL Server 2005 Enterprise Edition and install it on two servers as long as the second server is a "passive" failover, either as...

You are going to need some down time, even if it is just a cople of minutes in order to rename databases to effect the swap of data.

Unless SSC happens to be on the critical path for the work they are doing. 😉

Still, after numerous questions that could be answered by a little work on their...

Blocking the checkpoint seems logical to me. Ensures a consistant backup of the transaction log.

Now to this one. This individual really needs to figure out how to open and read BOL.

GilaMonster (8/27/2009)

Lynn Pettis (8/27/2009)

Personally, looks like a good reseearch topic for some one. I'd...

I'm just curious, but have you even tried looking some of this stuff up in BOL (Books Online, the SQL Server Help System) that you can easily access from SSMS...

Personally, looks like a good reseearch topic for some one. I'd just leave your...

Could you post your code and the name(s) of your linked server(s).

As does BOL (Books Online).