Hey Pedro,

thats shaved off two seconds! great!

But now I'm getting

2006-05-05 00:00:00.000

2004-07-20 00:00:00.000 etc 

How do I trim the trailing zero's without converting it? Is there a function to trim or...

I AM NOT WORTHY!

Thank you so much guys. AMAZING response time to my very frustrating problem. This forum is by far the best one out there.

Please continue to keep up...

Excellent, thanks Ray.

"Generally though if there are pending transactions it will not shrink very much unless you force a page reorganization"

By this do you mean running the Microsoft supplied script...

Excellent,

Thanks for the info Deni. I think those may be the main points. Any other opinions or reasons not mentioned by Deni are welcome.

Siz

If you have no probs upgrading SS then thats fine, but Phil is right, you can setup log-shipping on SQL 7.0 or Standard Ed by breaking down the tasks as...