topic Re: StoreOnce Catalyst plugin for MS SQL in StoreOnce Backup Storage

StoreOnce Catalyst plugin for MS SQL

ianbutton1 — Tue, 17 Dec 2019 16:22:15 GMT

We are looking at this, as currently we run SQL native backups onto a staging-post, then use Data Protector to backup to Catalyst. It's all rather slow, so a direct method would be quicker & save intermediate storage.

The install/user guide isn't very clear - does the plugin require the SQL server to be zoned with the StoreOnce, so that data moves direct? Or does data move through a media server? Media server is mentioned in the guide, but no information about required architecture. And I can't see media server name showing as part of the backup configuration process.

TIA

Re: StoreOnce Catalyst plugin for MS SQL

ianbutton1 — Tue, 17 Dec 2019 16:36:55 GMT

Aha, I think I can answer my own question. The title page of the User Guide says "instructions on using the StoreOnce System with media servers running Microsoft SQL Server". So that's it. It makes sense, but the guide doesn't clarify that anywhere else. We would have to buy SQL licences for the media servers - so this idea looks like a non-runner.

Re: StoreOnce Catalyst plugin for MS SQL

ianbutton1 — Wed, 18 Dec 2019 10:35:47 GMT

Further question - do the SQL databases have to be on the media server, or can the plugin use SQL Management Studio to look across at another SQL server in order to run the Catalyst backup. Has anybody tried this?

TIA