After doing much reading, I learned that I am unable to load the backup file to RDS instance since backup and restore are not supported. A paid instance is needed...

I believe you need to go to properties of each node (Failover cluster manager => Services and applications => Right click each instance => Properties), from the server properties check...

I am not sure if you are able to take a full image of your servers while it is clustered, I have only done it with standalone servers.

In case...

your steps are correct, just make sure you take full backup of all databases and backup up all master keys (if you have database encryption).

It worked perfectly, I had to deal with some fixed width of columns afterwards and that was fixed too. Thank you. I fixed it at the source level by converting...

Great, I am testing it now. I will update you shortly.

I am updating this since I was able to fix it..

I removed a space in the mail profile and that seemed to fix the crashing. We haven't had any...

I know this is an old post, but I wanted to add this since lately we have been dealing with few failures of SQL Mail not sending email.

1) If...

It appears that the SSMS reads the redgate file even though it should read the native as it is the full backup. As you stated, changing the backup timing might...

One thing you can do is generate the script of the mail profile which works in 2012, and use the code to create it the same thing in 2008 and...

Here is a good link to troubleshoot, https://technet.microsoft.com/en-us/library/ms187540(v=sql.105).aspx

Try to restart it and see.

Also are you using more than one profile? If so, go to database mail and send...

The reason is converting some old financial data into a new system, the data came in text files from different groups and it was not clean. There are few steps...

Hugo - I am putting the query in SSIS package, I will be using your recommended method. Thanks for your input.

Thank you much, I got it! 🙂

Perfect, it worked like a charm! Now I have one last question to ask: The ultimate goal is after we group the data is to extract each subset of data...