Is there any way to implement SQL Server log shipping

Discussion in 'Databases' started by HumanSystems, Jul 17, 2016.

  1. I would like to ship logs to a reporting database and would like to avoid restoring a database backup. Is this or will it be possible? - thx
     
  2. mjp

    mjp

    It might be possible on a Manged SQL server, but not on the shared servers.

    If you think you might be interested in a Managed SQL Server, drop an email to support@ and they can check in to the viability of log shipping for you.
     
  3. Thank you - do you know how people are architecting a separate near realtime reporting database with NopCommerce in the shared server environment?
     
  4. mjp

    mjp

    A separate reporting database, no. Maybe if someone else is doing what you're trying to do they can chime in here with some advice.

    Is there a reason you can't use SQL Reporting Service on the primary NopCommerce database? Because that is included in every plan, and it would be available for a shared SQL database.
     
  5. I like the bundled SQL Reporting Services, but generally don't like to mix ad-hoc or potentially large/batch reporting operations with transactional systems. It's a pretty standard strategy to separate near real-time reporting from transactions. Just looking at options with Everleap right now, and may very well use the primary DB for first phase. - thanks for your help.
     

Share This Page