@SQLFRNDZ (12/26/2012)
The best way is Logshipping depends on the daily load though...
Not really. "It Depends". SAN-based replication is nearly instantaneous and puts no load on the production server. It has some disadvantages but, like I said, "It Depends". Hell would have to freeze over and pigs would have to grow wings before I'd ever consider using SSIS for such a thing.
--Jeff Moden
Change is inevitable... Change for the better is not.