How to archive big table in prod envrmnt in SQL server azure

Dec 18 2019 6:37 AM

Hi All,

I have a database in production environment, i have 3 big tables, 1 table around 300 gb, 2nd table around 100 gb 3rd tbale around 50gb.

I need to do two tasks:

1. Take backup of these tables.

2. Remove previous years data from the table in prod environemt (tbale have date column to filter data)

Points:

DB or table should not lock for long time while backup or removing data as DB is in prod environment.

DB is azure SQL database, i am using SSMS 2019.

looking for best possible approach.

thanks

Answers (3)