Sample SQL Code for Veeam Database

Asked By 0 points N/A Posted on -
qa-featured

Hello and Good Day Experts!

Can you provide any examples of SQL code for Veeam Database which needs to be executed using only the command prompt? 
 
I need to execute the Select, Insert, Update, Delete, Backup and Restore commands in the Customer Table with the following fields: ID, Name, Email, Phone and Address. 
 
Any example codes will be a great help. 
 
Thank you.
SHARE
Answered By 15 points N/A #183725

Sample SQL Code for Veeam Database

qa-featured

Hello Williams,

This situation describes how to use the Microsoft SQL revival wizard to carry out a specific query alongside a specific database and re-establish the query consequences. You can save the consequences of the query back to the construction record or save them as data files to a detailed file.

If you desire to refurbish the outcome of the query to the construction database, the Microsoft SQL re-establish wizard will generate a new board in the preferred database on the fabricated Microsoft SQL Server and insert the query results.

For details,

See Scenario 3.2. Restoring Query Results to Data Files

Answered By 0 points N/A #183726

Sample SQL Code for Veeam Database

qa-featured

Hi Naomi,

To enter and execute SQL statements or commands such as SELECT, INSERT, UPDATE, DELETE, BACKUP, and RESTORE, input the statement or command at the SQL prompt.

  • Use the SQL SELECT statement if you want to select data from the database.

             For example:

             If you want to select customer name and email from the Customer Table, command should be:

             SQL > SELECT customer name,email FROM Customer; 

  • Use the SQL INSERT INTO statement if you want to insert new records into the database.

              For example:

              If you want to insert Eric James, eric_james@gmail.com in the Customer Table, command should be:

              SQL > INSERT INTO Customers

              VALUES ( 'Eric James', 'eric_james@gmail.com')

  • Use the SQL UPDATE statement if you want to update records in a table.

               For example:

               If you want to update the email address of Eric James in the Customers Table, command should be:

               SQL > UPDATE Customers

               SET Email='eric_james21@yahoo.com'

               WHERE CustomerName='Eric James'

  • Use the SQL DELETE statement if you want to delete records in a table.

              For example:

              If you want to delete customer ID of Eric james, command should be:

              SQL > DELETE FROM Customers

              WHERE CustomerID='1'

  • Use BACKUP DATABASE to create full database backup, command should be:

             SQL > BACKUP DATABASE database

  • Use RESTORE Command to restore backup database.

             SQL> RESTORE DATABASE database

Related Questions