SQL SERVER - 2005 - Create Script to Copy Database Schema and All The Objects - Stored Procedure, Functions, Triggers, Tables, Views, Constraints and All Other Database Objects - SQL Authority with Pinal Dave
Move SQL databases to a different server using SQL Server log shipping