Red Gate forums :: View topic - Amazon RDS MS SQL?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup 7
SQL Backup 7 forum

Amazon RDS MS SQL?

Search in SQL Backup 7 forum
Post new topic   Reply to topic
Jump to:  
Author Message
hbax450



Joined: 08 Nov 2012
Posts: 2

PostPosted: Thu Nov 08, 2012 4:47 am    Post subject: Amazon RDS MS SQL? Reply with quote

Great tool, but doesn't work with Amazon RDS MS SQL. Anyone have luck with this?
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 938
Location: Red Gate Software

PostPosted: Fri Nov 09, 2012 11:47 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
eddie davis



Joined: 14 Jun 2006
Posts: 938
Location: Red Gate Software

PostPosted: Fri Nov 09, 2012 12:20 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
hbax450



Joined: 08 Nov 2012
Posts: 2

PostPosted: Tue Dec 04, 2012 5:33 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group