26 June 2013

BackUp the database with compression and without compression inseq server

compression

BACKUP DATABASE database_name

TO DISK = 'D:\database_name.BAK'

WITH COMPRESSION
 
Example:

BACKUP DATABASE exe

TO DISK = 'D:\exe.BAK'

WITH COMPRESSION
 
 
without compression

BACKUP DATABASE database_name

TO DISK = 'E:\database_name.BAK'

WITH NO_COMPRESSION, INIT

Example

BACKUP DATABASE exe

TO DISK = 'E:\exe.BAK'

WITH NO_COMPRESSION, INIT

No comments:

Post a Comment