Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bala012
Starting Member
4 Posts |
 Posted - 2014-09-17 : 10:08:47
|
| HiiiiiiI want to sync Datbases to secondary server which is used for Read-only for SSRS purpose,these sync can be done once or twice during nightly and mid morning,Sync database size would be 400 Gb ,50 GB 60 GBWhat are my options to approach these scenarioI planned to implement logshipping by using redgate so my backup would be compressed and easier to implement,but i am not sure how to maintain the logfile size for maintenace purpose like when to shrink logfiles because it may grow enoromus untill i take log backup in the night.orthere are any other options like mirroring or replication please advice me on theseThank you. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-09-17 : 12:30:04
|
| What version of SQL Server are you using and which edition?Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
Databases sync for secondary server