How do you tell which is the most updated SQL database? The server that has the most recent entries.

Joshua Tay 246 Reputation points
2021-03-16T04:00:44.817+00:00

Hi,

I was given a server to manage my ERP, I have 5 databases siting on a server.
How do you tell which is the most updated SQL database?

78083-database.jpg

Thank you.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,270 questions
0 comments No comments
{count} votes

Accepted answer
  1. Nandan Hegde 30,951 Reputation points MVP
    2021-03-16T05:25:22.66+00:00

    Hey,
    What do you mean by most updated one?

    There can be multiple scenarios for the same:

    1) Right click on the database>> Properties and you can see Date Created.
    This shows you when a database was created.
    So in some scenarios the latest date meaning the most updated database or it can also mean a old database backup that was restored recently.

    2) You can check the information_schema details and log details of database to check where the objects are


0 additional answers

Sort by: Most helpful