question

himani.dwivedi avatar image
himani.dwivedi asked

How to select a number of records per year for each table of every database.

Hello, 1. We have plan to do Archiving the old data for that we have to estimate the data size yearly 2001 to 1016. How I can select the number of records per years for every table for each database separately. Any table or schema in system db which can help to identify the date creation 2. If we have replication in progress do we need to take T-log backup to avoid log file full issue as well or not required. thanks.
replicationsql server 2008 r2archiving
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
David Wimbush avatar image
David Wimbush answered
You need to record the creation date of rows yourself. I'm afraid there's nothing built in that does it automatically.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.