Create a full database backup by executing the BACKUP DATABASE statement to create the full database backup, specifying:<\/p>\n\n\n\n
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.<\/p>\n\n\n\n
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.<\/p>\n\n\n\n
For Examples:<\/p>\n\n\n\n
BACKUP DATABASE ANDARPRODUCTION TO DISK = ‘F:\\Backup\\ANDARPRODUCTION.bak’
WITH COPY_ONLY, INIT, COMPRESSION;<\/p>\n\n\n\n
Also, most likely you should backup to Log for the same database as well to avoid lose any uncommited transitions.<\/p>\n\n\n\n
BACKUP LOG ANDARPRODUCTION TO DISK = ‘F:\\Backup\\ANDARPRODUCTION.TRN’
WITH COPY_ONLY, INIT, COMPRESSION;<\/p>\n","protected":false},"excerpt":{"rendered":"
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 Read More<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[10,625],"tags":[1799,1800],"class_list":["post-5121","post","type-post","status-publish","format-standard","hentry","category-microsoft","category-sql","tag-backup-microsoft-sql-database-by-using-transact-sql","tag-backup-ms-sql-database-by-using-query"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\t