@SQLFRNDZ (12/26/2012)
Jeff Moden (12/26/2012)
@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.
Sounds Good but SAN-Based replication supports specific to 1 dB ?
My understanding that his requirement is not DR and he just wants to copy a database to other lower environments daily and want to automate the process. SAN-replication sounds to me like mirroring the environment instead just a dB.
It depends on the SAN and either the software or the hardware they built in to it. At the current company I work for, we use it to replicate the entire environment offsite for DR purposes on a continual basis. At a previous company, we used it once at day at midnight to replicate the main prod database to a reporting/analysis DB. Total "offline" time was less than 15 seconds for that.
--Jeff Moden
Change is inevitable... Change for the better is not.