Article 3.6.1X : Why I couldn't restore ElnetDB in SQL?
We can always restore the DB in Same version or upgraded version of SQL (but not lower version).
For example - If the backup is taken in SQL 2014, the backup file can be restored only in SQL 2014 or later but not in SQL 2008 or lower version.
If the above mentioned point is right, when restoring click "Close the existing DB" checkbox & click restore.
*** End of article ***
Related Articles
Article 3.6.2S : SQL Configuration manager already installed in PC for new ElNet installation.
As mention in the subject SQL server configuration manager is already installed in a PC of new ElNet software installation. But as I have checked on PC there is not an installed SQL server management studio (SSMS). customer is using SQL for account ...
Article 3.6 SQL 2019 Installation Guide
Please find the attachment
Article 3.6.5S : How to check Server name and PW of SQL?
Yes, we can know the server name and Password of the SQL server management studio. With the help of ElNet master application is available in the software installation folder in the server PC program file. Click on ElNet master and we can know the SQL ...
Article 3.6.1AE : How to check Live Data in a SQL?
First, open the SQL server management studio (SSMS) and log in with the user id and password. After that follow below hierarchy to get Online data from SQL. ElNetDB > dbo.LiveData > Edit Top 200 Rows. You will find the table of the list of the meter ...
Article 3.6.1T : How to copy SQL Data from one table to another table ?
1. SET NOCOUNT ON SET STATISTICS TIME ON INSERT INTO Table_name_one ( colm1, colm2, colm3, colm4, colm5 ) SELECT colm1, colm2, colm3, colm4, colm5, FROM Table_name_two SET STATISTICS TIME OFF SET NOCOUNT OFF Note: Before ...