In this article I am talking
regarding different procedure of Database backup in Microsoft SQL server. I am discussing
below listed point.
(1)Take Backup using Wizard.
(2)Take backup using generates script functionality.
Let’s start
(1) Take Backup using Wizard
Right click on database which
you want to take backup-> go to ->Task->go
to->Back Up
Using below
window you can configure general tab which contain backup type you can changes
backup type (Full backup, Differential backup) according to requirement and you
can change backup physical location in Disk.
Full backup-> full
backup Take backup of whole database.
Differential backup->this
type of backup capture only the data that has changes since full backup.
After that
configure Option tab->Go to Option
tab in same window.
In this window you can
select option like append to existing backup set and overwrite all existing
backup set and you can also set backup compression option for shrink database
backup file.
Finally click
ok button show in below.
After completion of task
you see this window. This window display successful message this message indicate
Database backup task is completed successfully.
(2) Take backup using generates script
functionality
(a)This type of backup functionality use when you are unable
to restore backup file on other server database.
(b) If in your database large amount of data then this
type of backup functionality is not suitable.
But in some cases generate script functionality is very useful.
Right click on database->go to->Task->go to->Generate Script
In this window you can configure multiple things:
(a)Select database object to script
(b) Configure how script should be save and publish.
(a)Select database object
to script-> in this tab two options are available one is script entire
database object or select some specific database object like table, views,
stored procedure etc.
(b) Configure how script should
be save and publish-> in this tab also two option available one save script
to a specific location on your disk or save to clipboard or save to new query window.
Here you can also
configure advance setting using advance button.
For advance setting go to
this window. Here you can select option according requirement. Here I am selecting
type of data to script option is schema and data that means I want to generate
script of database schema and data. You can select option according to own
need. After that click ok button.
After completed all tasks
go to save or publish tab of this window. After that you can see script in new
query window according to your setting. Then click on finish button.
You can see output here.
