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.
You need to record the creation date of rows yourself. I'm afraid there's nothing built in that does it automatically.
18 People are following this question.
