SQL backup , restore and scripts

-

 

SQL  Backup :

  • The backup copies the data or log records from database to device such as disc.
  • This copy can be used to restore or recover the data after failure.
  • Their are three main types of backup :

Full backup :

  • It is a backup of database which represent the whole database at the time the backup finished.
  • It contains all the data in a specific database or set of filegroups. 

Differential backup :

  • It is the backup based on latest full backup of complete or partial database.

Log backup :

  • It is the backup of transaction logs that have all log records that are not backed up in previous log backup.

Steps for back up database :

1) Connect to database and expand database, select the database which we want to backup :


2) Select the backup type:


3) You can add new destination and add .bak extension :


4) Click on "Ok" and the database backup completed :


5) You can check whether the backup is created successfully or not by going to destination folder :


SQL  Restore :

  • The restore is a process of restoring or recovering data from backup.
Steps for restoring database :

1) Click on database => Restore database :


2) Click on device and select backup device : 


3) Give name for database  :


4) Now database is restored successfully :


5) And refresh database to see restored database :


SQL  Scripts :

  • We can create or generate scripts for transferring database between instances.
  • SQL script is a set of SQL commands which are stored as a file in SQL scripts.
Steps for generating scripts :

1)  Click on database => Task => Generate scripts :


2) After clicking next, choose entire database or specific object :


3)  Click on save as script file and destination :


4)  We can see the scripts are saved, now click on finish :


5)  Open the destination folder and verify the script is generated or not :


6) Click on script file, we can see the set of commands :



      In this blog we have seen how to backup, restore and scripts in SQL. If you have any questions comment below.

Thank You!!!

For more understanding watch below video :

Comments

Post a Comment

Popular posts from this blog

Day 3 : JavaScript

-
Image
 Data Types of JavaScript:  In JavaScript, their are three data types present i.e number, string and boolean. As we all know JavaScript is a dynamic language, means one variable can hold different datatypes.                    Example :                                      var x;                                      x=10;              //number                                      x="Hello"      //string                     // In above eg. the x holds number as well as string but shows string.                 ...
Read more

SQL Concepts-1

-
Image
              In this blog we are going to understand the important and basic concepts of SQL... Q. How to  create a SQL server database  connection and new database? 1. Firstly open SSMS and connect with server also ensure SQL Server(MSSQLSERVER) is in running mode - 2. Create a new database -                                                              3. Create a table - // U need to refresh whenever u add a new table            Q. What is primary key and foreign key in SQL server? Primary Key :  Primary key is a column having unique record. Primary key cannot have NULL values. It is used to uniquely identify records in relational database. Only one primary key is allowed in a table. When we delete or update records, data integrity happens. Foreign Key...
Read more

ASP .NET Session Management

-
Image
  Q. Why http protocol is called as stateless ? HTTP protocol is called as stateless because the http server not keeps the record of any information. When client requests to server, every time request treated independently(it not checks whether it requested before or not) by server. We can also say that when client ends the process of any task the connection between server and browser also terminated. In below example we can see that after accessing browser when we again access the value of i starts again from 0.                                                   Stateless Protocol : Stateless protocols are the protocols in which client sends request to server and server response back to client based on current state.  Server not require to maintain information of each client with multiple requests. Some important features of stateless protocol are :...
Read more