How to do BackUp and Restore Operation in SQL Server in AWS | WinAndApp
This videos will show you how to do BackUp and Restore Operation in SQL Server in AWS. How to Creation Option Group in AWS. How to Create S3 Bucket in AWS.
AWS Link: http://aws.amazon.com/
Let’s Learn to Teach.
Refer below scripts that I have mentioned in my video.
To Restore SQL Server Database to AWS:
-----------------------------------------------------------------
exec msdb.dbo.rds_restore_database
@restore_db_name='database_name',
@s3_arn_to_restore_from='arn:aws:s3:::'bucket_name/bakup_file'
To check the status of Task Execution :
-----------------------------------------------------------------
exec msdb.dbo.rds_task_status
To Compress the BackUp Operation in AWS:
-----------------------------------------------------------------------
EXEC rdsadmin..rds_set_configuration 'S3 backup compression', 'true'
To BackUp SQL Server Database from AWS:
----------------------------------------------------------------------
exec msdb.dbo.rds_backup_database
@source_db_name='database_name',
@s3_arn_to_backup_to='arn:aws:s3:::'bucket_name/file_name_and_extension',
@overwrite_S3_backup_file=1;
BGM: Water Truck by Trevor Garrod is licensed under YouTube license
Track Title: Water Truck
Artist: Trevor Garrod
Mood: Dark
Genre: Cinematic
Please Subscribe to my channel for all upcoming videos.
Subscribe on YouTube: @ / winandapptech
Follow me on Facebook: @ / winandapptech
Follow me on Instagram: @ / winandapptech
Follow me on Twitter: @ / winandapptech
Mobile users, switch the video resolution to 1080p and use Headphones for better experience.
#AWS #SQLServer #SQLBackUpRestore #AmazonWebServices #AWS_RDS #MicrosoftSQLServer #SQLBackUp #SQLRestore #WinAndApp