Amazon RDS MS SQL?

Compresses, encrypts, secures and monitors SQL Server backups.

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

Amazon RDS MS SQL?

Postby hbax450 » Thu Nov 08, 2012 4:47 am

Great tool, but doesn't work with Amazon RDS MS SQL. Anyone have luck with this?
hbax450
 
Posts: 2
Joined: Thu Nov 08, 2012 4:45 am

Postby eddie davis » Fri Nov 09, 2012 11:47 am

Hi hbax450

SQL Backup does not support Amazon RDS. From the information I have read about Amazon RDS is that they provide you with a database instance and they perform all the administrative tasks including backup services for your database instance.

For SQL Backup to operate successfully, you will need to install the SQL Backup Server components which include:
    Total of nine Extended Stored Procedures which are created in the master database.
    SQL Server Compact Edition, used to cache the backup and restore history from the msdb database.
    SQL Backup Agent Service, Windows service that runs the SQL Backup engine.

I suspect that you would be denied installing the SQL Backup Server Components on the Amazon RDS.

Many Thanks
Eddie
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 943
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software

Postby eddie davis » Fri Nov 09, 2012 12:20 pm

Hi hbax450

I have just had another thought. If you are a Red Gate SQL Compare and SQL Data Compare user, you could use these tools to obtain a local copy of your database by comparing and deploying the changes to a test database.

Many Thanks
Eddie
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 943
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software

Postby hbax450 » Tue Dec 04, 2012 5:33 pm

Thanks Eddie, yes we are. It's just something I'd rather have automated. To run that routine on the 10+ databases we have, it would be a huge time commitment.
hbax450
 
Posts: 2
Joined: Thu Nov 08, 2012 4:45 am


Return to SQL Backup 7

Who is online

Users browsing this forum: No registered users and 0 guests