SQL Server backs up and compresses the backed-up files

server|sqlserver| Backup | compression
SQLSERVER2000 Backup

Example 1: (Backup)

1 Use Master
2 Declare @path = ' C:\aa\zy.bak '
3 Backup Database Zy to
4 disk= @path with Noinit

Description
1 Using System libraries
2 set the path and filename of the backup, note that it is quoted in single quotes.
3 databases to be backed up
4 Set up the backup drive, set the path to the drive, and then set the way to backup (override or overwrite)


Example 2: (compressed database file for backup)

Use master
exec xp_makecab ' C:\m.cab ', mszip,1, ' C:\aa\zy.bak '
exec xp_cmdshell ' copy c:\123.cab ', ' D:\123.cab '

Description
Name of ' C:\m.cab ' compressed backup
Mszip compression mode
The path of the ' C:\aa\zy.bak ' compressed file

Copy to another directory save