Best option for creating mirror database for querying

Usage and Config Platform
1

(imported topic written by SystemAdmin)

Hey guys. What is the preferred method for replicating the database of our Bigfix environment? We currently have a flat file restore process that works sometimes, at best. The file size of the flat file is currently 16gb and we think it is this size of the file that is causing the failed restores on the mirror database server. Most times the copy job would fail while other times it appears that the copy worked only to find out that the restore job fails.

I am just interested in doing the most efficient and most reliable method to replicate the data. Any help is greatly appreciated.

Thanks,

Paul Sisk, ML

2

(imported comment written by BenKus)

Hey Paul,

The size of your deployment and the number of properties that you have make this a tricky task. For deployments less than 50,000 computers or so, there will be significantly less data, which probably will have improved success rates… But unfortunately, that doesn’t really help you…

Perhaps this will work better:

  • do a database shrink
  • do a database backup
  • copy backup to replicated server
  • restore database to replicated server

Will that accomplish what you want?

Ben