SQL Backup, Restore & Script Part V

SQL Backup, Restore & Script

SQL  Backup :

  • A copy of SQL server data that can be used to restore and recover the data after a failure.
  • A backup of SQL Server data is created at the level of a database or one or more of its files or filegroups.
  • Backup of a database can also be used to restore a copy the database to a new location.
There are Three main Types of Backup :

1) Full Backup :

  • Full Backup stores a full copy of a specific database at the point in time that the backup completed.
  • It contains all the data in a specific database or set of filegroups. 

2) Differential Backup :

  • Full Backup stores a full copy of a specific database at the point in time that the backup completed.

3) 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 databases folder Right-click the databases and select Tasks and then select Back Up :


2) Select Full as the Backup type then click on Add to add a backup file :


3) Select backup file and assign to the file name with .bak extension & click ok :


4) Click ok again to create the backup :


5) Backup of Database completed successfully :


6) Open the destination folder and check the backup is created successfully  : 


SQL  Restore :

  • The Restore is a process of restoring or recovering data from backup.

Steps for Restore Database :

1) Connect to database and Right-Click on database then select restore database : 


2) Click on device and click on Add to a add backup file :


3) Select backup file & click ok :


4) Click ok  to create the restore file :


5) Assign name for restore database & click ok :


6) Database is restored successfully :


7) 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) Connect to database and Right-Click on the databases and select Tasks and then select Generate Scripts :


2) Select specific database object or click on tables :


3) After clicking next then Click on Advanced : 


4) Choose type of data to scripting object type for schema and data then click ok :

5) Save to new query window then click on next :


6) Scripts are save to click on finish :


7) Click on script file to the set of commands :


8) Open the destination folder and check the script is generated successfully :


Comments

Post a Comment

Popular posts from this blog

Basic Concept In C Sharp Day 16

Image
Lecture 16 : Basic Concept In C Sharp C Sharp : C#  (pronounced  see sharp , like the musical note C♯, but written with the number sign) is a general-purpose, multi-paradigm programming language encompassing static typing, strong typing, lexically scoped, imperative, declarative, functional, generic, object-oriented (class-based), and component-oriented programming disciplines. C# was developed around 2000 by Microsoft as part of its .NET initiative and later approved as an international standard by Ecma (ECMA-334) in 2002 and ISO (ISO/IEC 23270) in 2003. It was designed by Anders Hejlsberg, and its development team is currently led by Mads Torgersen, being one of the programming languages designed for the Common Language Infrastructure (CLI). The most recent version is 9.0, which was released in 2020 in .NET 5.0 and included in Visual Studio 2019 version 16.8. C-sharp musical note : " C sharp " was inspired by the musical notation whereby a sharp symb
Read more

VS Code In JavaScript Day 6

Image
Lecture 6 : VS Code In JavaScript What is VS Code : Visual Studio Code is a lightweight but powerful source code editor which runs on your desktop and is available for Windows, macOS and Linux. VS Code was announced on April 29,2015 by Microsoft at the 2015 Build conference. Why did we build VS Code : Visual Studio Code combines the simplicity of a source code editor with power developer tooling, like IntelliSense code completion and debugging. First and foremost, it is an editor that gets out of your way. The delightfully frictionless edit- build- bebug cycle means less time fiddling with your environment, and more time executing on your ideas. IntelliSense : IntelliSense is a general term for a variety of code editing features including : code completion, parameter information, quick information, and member list. IntelliSense features are sometimes called by other name such as "code completion", "content assist", and "code hinting".
Read more

ASP.NET MVC Interview Questions Part - II Day 26

Image
Lecture 26 : ASP.NET MVC Interview Questions Part - II 1) How is the URL structure of MVC core ? URL structure of MVC core is controller name with action name. Example : localhost:1234/{controller}/{action name}. The "localhost:1234" is considered as a controller name. 2) If the view name is different than action name how to invoke it  ? If the view name is different from action name we have to write and the view in double quotes. 3) How do we define navigation using anchor tag ? The HTML <a> element (also called the anchor element), containing its href attribute, creates a hyperlink to other web pages, locations within the same page, location to a specified title of another web page, or to an email web page.  The <a> tag defines a hyperlink, which is used to link from one page to another. The navigations can be defined using anchor tag as <a href="/Controller name/Action name"></a>. 4)  How to pass mode
Read more