migrating SQL Server databases with file stream to AWS Custom RDS

0

Hi Team,

As we know, file stream databases are not supported in RDS, so we plan to custom RDS SQL Server. I think it will be the same as on-premises. could you please share any AWS links for migrating file stream DBs to custom RDS?

Thanks

1 Risposta
0

You can perform a native backup onto a file and upload the file to S3.

BACKUP DATABASE mydatabase TO DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Backup\mydb-backup.bak' WITH COMPRESSION;

Please find in the doc: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/custom-migrating.html https://www.sqlops.com/migrating-databases-to-aws-rds-a-step-by-step-guide/

profile picture
ESPERTO
con risposta 4 mesi fa

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande