Usando AWS re:Post, accetti AWS re:Post Termini di utilizzo

Can we have database datafiles and logfiles in S3 bucket and SQL installed on windows OS

0

We are using windows server. On that windows server we have SQL server installed. We are planning to upgrade that to SQL 2022. Now I want to know the feasibility to move databases to S3 bucket. Is it feasible to have mdf and ldf files of the SQL databases on S3 bucket directly and SQL server installed on windows server which is hosted on AWS.

posta 2 anni fa820 visualizzazioni
2 Risposte
1
Risposta accettata

You can theoretically store those files on S3, yes. But it won't work well because S3 is object storage and can't natively be mounted directly to the file system in a way that will be performant for your database server.

You would be better off using EFS or EBS. The best option would be to get off EC2 and switch to a managed solution like RDS for SQL Server: https://aws.amazon.com/rds/sqlserver/

AWS
con risposta 2 anni fa
profile picture
ESPERTO
verificato 6 mesi fa
0

May I ask why do you want to store Database files on S3?

You can not store MDF and LDF files on S3 and have those files actively in use by SQL Server, because S3 is object storage and every time object is changed a new version is uploaded. Block file on the other hand allow for a single block to be changed without the need for the whole file to be uploaded.

con risposta 2 anni 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