Create a full database backup by executing the BACKUP DATABASE statement to create the full database backup, specifying:
The name of the database to back up.
The backup device where the full database backup is written.
The backup options like COPY_ONLY, COMPRESSION, etc.
COMPRESSION will be very helpful to reduce the backup size.
COPY_ONLY is very useful for created a once-off backup, so if won’t affect any existing backup plan if any.
For Examples:
BACKUP DATABASE ANDARPRODUCTION TO DISK = ‘F:\Backup\ANDARPRODUCTION.bak’
WITH COPY_ONLY, INIT, COMPRESSION;
Also, most likely you should backup to Log for the same database as well to avoid lose any uncommited transitions.
BACKUP LOG ANDARPRODUCTION TO DISK = ‘F:\Backup\ANDARPRODUCTION.TRN’
WITH COPY_ONLY, INIT, COMPRESSION;