{"id":1007,"date":"2026-09-18T13:20:00","date_gmt":"2026-09-18T06:20:00","guid":{"rendered":"https:\/\/itonstartplus.com\/?p=1007"},"modified":"2026-09-18T13:20:00","modified_gmt":"2026-09-18T06:20:00","slug":"sql-server-backup-tsql-verify","status":"publish","type":"post","link":"https:\/\/itonstartplus.com\/?p=1007","title":{"rendered":"\u0e2a\u0e33\u0e23\u0e2d\u0e07\u0e10\u0e32\u0e19\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25 SQL Server \u0e14\u0e49\u0e27\u0e22 T-SQL \u0e41\u0e25\u0e30\u0e15\u0e23\u0e27\u0e08\u0e44\u0e1f\u0e25\u0e4c\u0e2a\u0e33\u0e23\u0e2d\u0e07"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">\u0e44\u0e1f\u0e25\u0e4c\u0e2a\u0e33\u0e23\u0e2d\u0e07\u0e21\u0e35\u0e04\u0e48\u0e32\u0e01\u0e47\u0e15\u0e48\u0e2d\u0e40\u0e21\u0e37\u0e48\u0e2d restore \u0e44\u0e14\u0e49\u0e08\u0e23\u0e34\u0e07 \u0e1a\u0e17\u0e04\u0e27\u0e32\u0e21\u0e19\u0e35\u0e49\u0e2a\u0e23\u0e38\u0e1b\u0e23\u0e39\u0e1b\u0e41\u0e1a\u0e1a\u0e01\u0e32\u0e23\u0e2a\u0e33\u0e23\u0e2d\u0e07\u0e2b\u0e25\u0e31\u0e01\u0e02\u0e2d\u0e07 SQL Server \u0e41\u0e25\u0e30\u0e27\u0e34\u0e18\u0e35\u0e15\u0e23\u0e27\u0e08\u0e44\u0e1f\u0e25\u0e4c\u0e01\u0e48\u0e2d\u0e19\u0e27\u0e31\u0e19\u0e17\u0e35\u0e48\u0e15\u0e49\u0e2d\u0e07\u0e43\u0e0a\u0e49<\/p>\n\n\n\n<h2 id=\"\u0e2a\u0e33\u0e23\u0e2d\u0e07\u0e41\u0e1a\u0e1a-full-differential-\u0e41\u0e25\u0e30-log\" class=\"wp-block-heading\">\u0e2a\u0e33\u0e23\u0e2d\u0e07\u0e41\u0e1a\u0e1a Full, Differential \u0e41\u0e25\u0e30 Log<\/h2>\n\n\n\n<pre class=\"wp-block-code language-sql\"><code>-- Full backup\nBACKUP DATABASE [MyDb]\nTO DISK = N'D:\\Backup\\MyDb_FULL.bak'\nWITH COMPRESSION, CHECKSUM, INIT, STATS = 10;\n\n-- Differential backup (\u0e40\u0e09\u0e1e\u0e32\u0e30\u0e2a\u0e48\u0e27\u0e19\u0e17\u0e35\u0e48\u0e40\u0e1b\u0e25\u0e35\u0e48\u0e22\u0e19\u0e08\u0e32\u0e01 Full \u0e25\u0e48\u0e32\u0e2a\u0e38\u0e14)\nBACKUP DATABASE [MyDb]\nTO DISK = N'D:\\Backup\\MyDb_DIFF.bak'\nWITH DIFFERENTIAL, COMPRESSION, CHECKSUM, STATS = 10;\n\n-- Transaction log backup (\u0e43\u0e0a\u0e49\u0e44\u0e14\u0e49\u0e40\u0e21\u0e37\u0e48\u0e2d\u0e10\u0e32\u0e19\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e40\u0e1b\u0e47\u0e19 Full recovery model)\nBACKUP LOG [MyDb]\nTO DISK = N'D:\\Backup\\MyDb_LOG.trn'\nWITH COMPRESSION, CHECKSUM;<\/code><\/pre>\n\n\n\n<div class=\"wp-block-group is-style-itb-note is-layout-flow wp-block-group-is-layout-flow\">\n<p class=\"wp-block-paragraph\">\u0e01\u0e32\u0e23\u0e2a\u0e33\u0e23\u0e2d\u0e07 Log \u0e43\u0e0a\u0e49\u0e44\u0e14\u0e49\u0e40\u0e09\u0e1e\u0e32\u0e30\u0e10\u0e32\u0e19\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e17\u0e35\u0e48\u0e15\u0e31\u0e49\u0e07 Recovery Model \u0e40\u0e1b\u0e47\u0e19 <code>FULL<\/code> \u0e2b\u0e23\u0e37\u0e2d <code>BULK_LOGGED<\/code> \u0e41\u0e25\u0e30\u0e15\u0e49\u0e2d\u0e07\u0e21\u0e35 Full backup \u0e21\u0e32\u0e01\u0e48\u0e2d\u0e19<\/p>\n<\/div>\n\n\n\n<h2 id=\"\u0e15\u0e23\u0e27\u0e08\u0e27\u0e48\u0e32\u0e44\u0e1f\u0e25\u0e4c\u0e2a\u0e33\u0e23\u0e2d\u0e07\u0e2d\u0e48\u0e32\u0e19\u0e44\u0e14\u0e49\" class=\"wp-block-heading\">\u0e15\u0e23\u0e27\u0e08\u0e27\u0e48\u0e32\u0e44\u0e1f\u0e25\u0e4c\u0e2a\u0e33\u0e23\u0e2d\u0e07\u0e2d\u0e48\u0e32\u0e19\u0e44\u0e14\u0e49<\/h2>\n\n\n\n<pre class=\"wp-block-code language-sql\"><code>RESTORE VERIFYONLY\nFROM DISK = N'D:\\Backup\\MyDb_FULL.bak'\nWITH CHECKSUM;<\/code><\/pre>\n\n\n\n<div class=\"wp-block-group is-style-itb-warning is-layout-flow wp-block-group-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><code>RESTORE VERIFYONLY<\/code> \u0e15\u0e23\u0e27\u0e08\u0e04\u0e27\u0e32\u0e21\u0e2a\u0e21\u0e1a\u0e39\u0e23\u0e13\u0e4c\u0e02\u0e2d\u0e07\u0e44\u0e1f\u0e25\u0e4c \u0e41\u0e15\u0e48\u0e44\u0e21\u0e48\u0e44\u0e14\u0e49\u0e1e\u0e34\u0e2a\u0e39\u0e08\u0e19\u0e4c\u0e27\u0e48\u0e32 restore \u0e41\u0e25\u0e49\u0e27\u0e41\u0e2d\u0e1b\u0e43\u0e0a\u0e49\u0e07\u0e32\u0e19\u0e44\u0e14\u0e49 \u0e04\u0e27\u0e23\u0e0b\u0e49\u0e2d\u0e21 restore \u0e08\u0e23\u0e34\u0e07\u0e1a\u0e19\u0e40\u0e04\u0e23\u0e37\u0e48\u0e2d\u0e07\u0e17\u0e14\u0e2a\u0e2d\u0e1a\u0e40\u0e1b\u0e47\u0e19\u0e23\u0e30\u0e22\u0e30<\/p>\n<\/div>\n\n\n\n<h2 id=\"\u0e14\u0e39\u0e1b\u0e23\u0e30\u0e27\u0e31\u0e15\u0e34\u0e01\u0e32\u0e23\u0e2a\u0e33\u0e23\u0e2d\u0e07\u0e25\u0e48\u0e32\u0e2a\u0e38\u0e14\" class=\"wp-block-heading\">\u0e14\u0e39\u0e1b\u0e23\u0e30\u0e27\u0e31\u0e15\u0e34\u0e01\u0e32\u0e23\u0e2a\u0e33\u0e23\u0e2d\u0e07\u0e25\u0e48\u0e32\u0e2a\u0e38\u0e14<\/h2>\n\n\n\n<pre class=\"wp-block-code language-sql\"><code>SELECT TOP 10\n       database_name,\n       type,\n       backup_start_date,\n       backup_finish_date,\n       CAST(backup_size \/ 1048576.0 AS DECIMAL(18, 1)) AS size_mb\nFROM msdb.dbo.backupset\nORDER BY backup_finish_date DESC;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u0e43\u0e19\u0e04\u0e2d\u0e25\u0e31\u0e21\u0e19\u0e4c <code>type<\/code> \u0e04\u0e48\u0e32 <code>D<\/code> \u0e04\u0e37\u0e2d Full, <code>I<\/code> \u0e04\u0e37\u0e2d Differential \u0e41\u0e25\u0e30 <code>L<\/code> \u0e04\u0e37\u0e2d Log<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u0e2a\u0e33\u0e23\u0e2d\u0e07 SQL Server \u0e17\u0e31\u0e49\u0e07 Full, Differential \u0e41\u0e25\u0e30 Log \u0e14\u0e49\u0e27\u0e22 T-SQL \u0e1e\u0e23\u0e49\u0e2d\u0e21\u0e27\u0e34\u0e18\u0e35\u0e15\u0e23\u0e27\u0e08\u0e27\u0e48\u0e32\u0e44\u0e1f\u0e25\u0e4c\u0e2a\u0e33\u0e23\u0e2d\u0e07\u0e43\u0e0a\u0e49 restore \u0e44\u0e14\u0e49 \u0e41\u0e25\u0e30\u0e14\u0e39\u0e1b\u0e23\u0e30\u0e27\u0e31\u0e15\u0e34\u0e01\u0e32\u0e23\u0e2a\u0e33\u0e23\u0e2d\u0e07\u0e25\u0e48\u0e32\u0e2a\u0e38\u0e14<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[26,25,27,11],"class_list":["post-1007","post","type-post","status-publish","format-standard","hentry","category-database","tag-backup","tag-sql-server","tag-t-sql","tag-demo"],"_links":{"self":[{"href":"https:\/\/itonstartplus.com\/index.php?rest_route=\/wp\/v2\/posts\/1007","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/itonstartplus.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/itonstartplus.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/itonstartplus.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/itonstartplus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1007"}],"version-history":[{"count":0,"href":"https:\/\/itonstartplus.com\/index.php?rest_route=\/wp\/v2\/posts\/1007\/revisions"}],"wp:attachment":[{"href":"https:\/\/itonstartplus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1007"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/itonstartplus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1007"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/itonstartplus.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1007"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}