I setup Team Foundation server (TFS) for our group and web team, the DBA team never utilized it but the web team are using it and it has been working...

Sue,

After talking to network team, it turned out I was given the windows cluster ip address and not the virtual SQL ip address which makes a big difference....

Sue,
I have, and I am getting can't find the IP message.. As I said the two nodes were rebuilt but the cluster was not destroyed. The old SQL instances...

Thank you both Sue and Prettsons, I did see the link but I have not tried it yet. I am going to give it a try today. I did ping...

The security group you set is to control the traffic in/out of the instance, you also need to setup NACL at the subnet level. To connect securely to PowerBI, setup...

EdVassie,

The script I posted works. I have uploaded about 750 GB of .bak files (backing up the SQL database to 12 .bak files) first to S3 storage, I used...

Even this post is real old, but I would like to add that I use powershell to copy files between AWS S3 and my local machine. Here is an example:

I suggest using PowerShell when it comes to copying large files between your local/AWS. Use Write-s3object cmdlet to copy your .bak file after making the backup through SQL. You need to...

Phil - Thank you for the link, I will look into it. Meantime please let me know if there are any other known simple ways to do it.

Phil -
I indeed searched before asking the question since most of the times there are examples/articles out there, I only found others mentioning the use of  Invoke-Command but couldn't find a...

Jeff -

Good question.. At first I had in mind to use transaction and use try/catch in each step so I know where it failed. Now that the process is very...

Phil -

You are correct, initially I was trying to print the error message if there was an error. I appreciate correcting me, and I have added throw vs using print...

That is why I initially was thinking of using try / catch so I catch an error if first step fails. Thanks for correcting me, I will correct my mistake.

Jeff and everyone else -

I did modified my script based on everyone input, thanks. I am starting by placing the database offline => restore => then placing it back online....