Hrides Thakur

Hrides Thakur

  • 1.8k
  • 292
  • 30.8k

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)