I think the answer depends on the type of environment you have and what type of disaster you have.   When all we need is a simple restore from tape, our...

For the logins, you could do a BCP out of the syslogins table on a nightly basis and copy the output file to the second server.  As part of our Distaster Recovery,...

That is much tougher!  I am always wary of making anyassumptions about that something is never used, because things could be used very infrequently, but be very necessary.   Is your...

Justin,

The answer would depend on what you mean by "redundant objects".   Do you mean tables with duplicate rows, or more than one index with the same columns on the same...

Another possible way to do this would be:

select convert(char(3), getdate(), 107)+convert(char(2),getdate(),11)

Any format that uses the two-year date as the first couple of numbers would work (2,11 or 12)