Best way to replicate 170GB DB for reporting purposes

• Johan Bijnens

  SSC Guru

  Points: 135377

  More actions

  January 15, 2011 at 1:23 am

  #1273879

  If those objects are strictly for reporting purposes, you can easily put them in their own database at the reporting sql instance and have them access your read only database without an issue.

  Or using 3 part object references ( select ... from readonlydb.yourschema.yourobject where ... )

  or using synomyms that point to the read only db.

  Johan
  
  Learn to play, play to learn !

  Dont drive faster than your guardian angel can fly ...
  but keeping both feet on the ground wont get you anywhere :w00t:

  - How to post Performance Problems
  - How to post data/code to get the best help[/url]

  - How to prevent a sore throat after hours of presenting ppt

  press F1 for solution, press shift+F1 for urgent solution 😀

  Need a bit of Powershell? How about this

  Who am I ? Sometimes this is me but most of the time this is me