"Enterprise" version of the SQL Backup Pro client?

Compresses, encrypts, secures and monitors SQL Server backups.

Moderators: Chris Auckland, eddie davis, Colin Millerchip, Brian Harris, james.billings, RBA, petey

"Enterprise" version of the SQL Backup Pro client?

Postby mdgraves » Mon Feb 13, 2012 3:24 pm

My DBA team currently manages 104 SQL instances, having a total database count (approx) 1000.

Our current configuration is SQL Backup Pro is installed locally for each SQL instance, with our in-house SQL code running via SQL Agent making the command line Backup Pro calls. Each of these calls uses a backup drive (locally on each server) for storage of the backup file.

We would like to change the topography to manage the backups from a single client, one at each of our two data centers, and use a single storage location (at each data center) for storage of the backup files.

Is there an "Enterprise" version of the SQL Backup Pro client? We would like to manage the 1000 databases from a database view, not segmented by individual SQL instance groupings.
mdgraves
 
Posts: 42
Joined: Fri Sep 21, 2007 7:56 pm

Or

Postby mdgraves » Mon Feb 13, 2012 3:43 pm

Maybe I can write remote command line calls from a server in each data center if no UI is available.
mdgraves
 
Posts: 42
Joined: Fri Sep 21, 2007 7:56 pm

Or - more

Postby mdgraves » Mon Feb 13, 2012 4:07 pm

Can I see all databases for servers placed into LOCATION(s) and/or GROUP(s)? And scheduled jobs too?
mdgraves
 
Posts: 42
Joined: Fri Sep 21, 2007 7:56 pm

Postby Brian Donahue » Tue Feb 14, 2012 6:46 pm

Hello,

For this type of solution, you'll probably want to get away from using the command-line client as it can't be invoked remotely using the SQL Backup management console. The Professional edition is the highest edition, and it allows you to manage backups and restores remotely. You can add as many servers into the SQL Backup console and group them by location.

Using the SQL Backup console this way, you will use the console to send backup commands directly to the SQL Server, which will get the SQL Backup server components to do the necessary work.

If you have any more questions, please let me know.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

batch register servers

Postby mdgraves » Tue Feb 14, 2012 7:18 pm

Brian
As I have @ 104 SQL instances, is there a command line and/or batch method to register servers on that one centralized console? Modify backend data files, etc. to get all 104 SQL instances registered. Also, to add schedule backups, etc.?
mdgraves
 
Posts: 42
Joined: Fri Sep 21, 2007 7:56 pm

Postby Brian Donahue » Wed Feb 15, 2012 10:00 am

SQL Backup hasn't got the ability to automatically add servers to manage. You do get a backup scheduling wizard once a server is registered though.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Backup 6

Who is online

Users browsing this forum: No registered users and 0 guests