Article 3.6.1J : How to take SQL backup using query ?
You can directly take backup using sql query. It will save your time for taking backup.
BACKUP DATABASE [ELNetDB]
TO DISK = 'D:\Alok\KB\Backup Sql\ELNetDB.bak'
Related Articles
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 ...
Article 3.6.1AD: In SQL, how to clear all the rows in one query?
If you want to delete all the rows in a table, use the below command. Click new query and type this command - truncate table "TableName". FYR - Kindly have a look at the attached image.
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 ...
Article 3.6 SQL 2019 Installation Guide
Please find the attachment
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 ...