The change was done as described worked without any issues.

EdVassie -- as you also run some DB's in EC2 hopefully you will not mind if I ask you a question?

How do you back up data in EC2?

One of our servers creates about 130GB a day in backups.

We plan to backup locally then move them after the backups to S3 (keeping n days on an attached drive , and x days on S3)- with n & x being whatever the business decides), then later on to Glacier (Glacier is not yet in Sydney EC2).

And this does not even take into account the Log Backups.

We do full backups and I don't really want to go to differentials unless I have to.

The issue is the time to move the files, zip if required, the resource overhead to move and zip and the cost of the space to store n & x days of backups

So do you use normally use MSSQL backups or do you use a 3rd party tool to backup and compress etc. like CloudBerry Backup for SQL Server for example.

Do you compress?

Of course your answer may be relative to the database sizes you have in Amazon but it would be interesting to know.

thanks