Hey Chaps,

Anyone got any suggestions:

I need to backup and restore a database to a new server. I don't want the log (which is over 1 gig in size). I back up and restore fine it takes a long time though. I'm wondering what I can do T-SQL wise or thru the manager to backup the DB without a log (will that work on restore ????)

Cheers

Chubby..