Lempster (9/15/2014)
GilaMonster (9/11/2014)
cafescott (9/11/2014)
Based on your earlier comment I'm going to research Transactional Replication as it seems the best way to copy a production DB two or three times a day during work hours.That's not what transactional replication does. Replication is *continuous*
Again, where am I *recommending* that he not use the technology which I suggested he use?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability