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
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