Reg Database

bharathnan
Member Posts: 92
HI
how to know the date when for the last database is restored in navision 2017.
Please advice
how to know the date when for the last database is restored in navision 2017.
Please advice
0
Answers
-
I don't think you can check it inside NAV.
You can however check this sort of things in SQL Server Management Studio - right click on the database, click Properties, and in General tab you will see the Database Created property. That would be when the database has been restored.Slawek Guzek
Dynamics NAV, MS SQL Server, Wherescape RED;
PRINCE2 Practitioner - License GR657010572SG
GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-030 -
Thanks Slawek ..Is there anyother way to sort this out since we don't have ssms in local machine it is in remote server.
Thanks
0 -
Ask the server/database administrator?
You can retrieve creation date by executing the following T-SQL query against your SQL ServerSELECT create_date FROM sys.databases WHERE name = 'MyDatabaseName'
Any tool which will let you connect to the database and let you execute the query above will do.
You could even build something in NAV enabling you to run T-SQL queries and retrieve results from any database. It is a bit complicated, but if you look into UpgradeToolkit on the installation DVD there is a codeunit inside one of these fobs, Upgrade - SQL Mgt, which will have all DotNET components already defined, and also a code base you can learn from.
Slawek Guzek
Dynamics NAV, MS SQL Server, Wherescape RED;
PRINCE2 Practitioner - License GR657010572SG
GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-030
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions