HOW TO GET SQL BACK UP

When we dealing with SQL server it is very import to get the SQL Back up because some time we want back up to resort data base if data base corrupt or loosing data. Basically SQL provide facilities to get back up.
Following below step you can get easily SQL back ups

Select whatever database which wants to get back up. And right click.

Task--> Back Up…..
















Figure 1 shows that the pop up window.

1) By drop downing can select back up type. (Full, Differential, Transaction Log). In here select Full option from Backup combo box.
2) Provide Suitable name and description for backup which are going to take.
3) Back up set Expire. Inhere able to provide particular day or days to expire the backups. It will defend on user requirements.
4) By pressing Add button able to add new store folder to the back. Likewise we can add more physical location for our back up. Like wise we can remove store location by pressing Remove.

By pressing ok can get SQL backup easily.









Figure 2 show that the backup which created.


As well as following above steps we all so can do same process using SQL Query.
Open Query editor
And enter code like below.

BACKUP DATABASE [Name of Database] TO
DISK =N'Backup save path\backupname.bak’
WITH NOFORMAT, NOINIT,
NAME =N'DESCRIPTION OF BACK UP',
SKIP, NOREWIND, NOUNLOAD, STATS=10
GO

By executing above query can get backup also.














Figure 3 shows that example code.