Menu Bar

Home
Introduction to HTML Tables Elements and Attributes Lists Google Home Page Registration Form Forms_1 Forms_2
Introduction to CSS Three types of css Tables Forms(id,class,psuedo class) Backgrounds Periodic table Border in a table Margins and Padding Height,Width,Overflow
Introduction Basic Script Data types and Operators String methods and Arrays Functions and Objects Events Dialog boxes Conditions Loops Error Handling External JS Simple Calculator
Introduction SQL Installation and User creation SQL:Database and Table Creation SQL:Alter Constraints Select,Insert Delete Operators Functions Joins, Union, GroupBy Missing Items User Defined Functions Views Backup and Restore Company DB, Table and records Queries on Company DB Computer Business DB and Queries
Introduction Variables, Datatypes & Operators Conditional & Looping Statements Functions Pointers & Recursion Array & Files Patterns
Introduction Problems in C++
Configuration SQL server connection Introduction to PHP
Introduction VB.NET VB.NET Compilation & Run VB.NET Problems No link
Design Principles Stone Profit support page MasterLegacy MasterDev Work with Live System

Backup and Restore

Backup :
A copy of SQL Server data that can be store and recover the data after a server failure. A backup of SQL Server data is created at the level
of a database or one or more of its files or filegroups. Table level backups cannot be created. In addition to data backups, the full recovery
model requires creating backups of the transaction log.
Recovery Model: A database property that controls transaction log maintenance on a database. Three recovery models exits: simple, full
and bulk-logged. The recovery model of database determines its backup and restore requirements.
Restore: A multi-phase process that copies all the data and log pages from a specified SQL Server backup to a specified database, and
then rolls forward all the transactions that are logged in the backup by applying logged changes to bring the data forward in time.

 Manual:







Query:



Types of Backups:
Copy-Only backup: Backup  for a special purpose without affecting the overall  backup and restore procedures for the databse.
Types: Copy only full backups, Copy only log backups
Data backup: a backup of data in a complete database or a partial database or a set of data files or filegroups.
Database backup: A backup of a database. It represent the whole database at the time the backup finished.
Differential backup: It contains only changes made to the database since its most recent full database backup.




Full backup: A data backup contains all the data in a specific database or filegroups or files, and enough log files to recovering that data.
Manual:





Query:




Log backup: A backup of transaction logs that include all log records except previous backed up log records.
File backup: A backup of one or more database files or filegroups.

 Partial backup: Contains data from only some of the filegroups in a database, including the data in the primary filegroup, every read/write filegroup, and any optionally-specified read-only files.
Subscribe to: Posts (Atom)