Category: Server Advance

In SQL Server, you can restore a database very easily. To restore a database right click on the Databases node. You will get a image like this: Click on the restore database. Enter the database name which you want to restore and the name of the database where you restore. Here we restore “javatpoint” database…

In SQL Server, you can create a backup of a database very easily. Create a Backup Open Microsoft SQL Server Management Studio. You will see Server Object. (See below image) When you click on the server object you will see Backup device. Right click on the Backup device. You will see an image as follow:…

A view is a virtual table created according to the result set of an SQL statement. A view contains rows and columns, just like a real table. The columns in the view are the columns from one or more real tables in the database. SQL functions, WHERE, and JOIN statements can also be added to…