Skip to main content
2 of 2
edited tags; edited tags
user avatar
user avatar

Retrieve archived data

MSSQL database has previously been archived on another database. Approximately 70m rows (includes sales information.)

Now, I am asked to move this archived data to live database. Because, customer can't see order history older the 3 years.

Is it reasonable to do this? I think it will be slow. Are there other solutions?

  • Live DB size : 250GB
  • Archive DB size : 50GB
  • CPU : 8 Core
  • Memory : 64GB
  • Version : Microsoft SQL Server 2016 (SP1)
Yunus UYANIK
  • 1.1k
  • 1
  • 10
  • 27