BackUp the database

Posted by Saranya Boopathi under Sql Server category on 6/13/2013 | Points: 40 | Views : 1226

BackUp the database with compression and without compression

BACKUP DATABASE May2013_CutOff_LCC_01062013 
  TO DISK = 'E:\May2013_CutOff_LCC_01062013.BAK'
  WITH COMPRESSION

BACKUP DATABASE May2013_CutOff_LCC_01062013 
  TO DISK = 'C:\May2013_CutOff_LCC_01062013.BAK'
  WITH NO_COMPRESSION, INIT

Bookmark It

Latest Code Snipptes