{"id":41921,"date":"2017-04-21T00:00:00","date_gmt":"2017-04-20T21:00:00","guid":{"rendered":"https:\/\/prohoster.info\/blog\/blog_prohoster\/administrirovanie-sql-servera-razrabot"},"modified":"2020-02-18T13:44:41","modified_gmt":"2020-02-18T10:44:41","slug":"administrirovanie-sql-servera-razrabot","status":"publish","type":"post","link":"https:\/\/prohoster.info\/az\/blog\/administrirovanie\/administrirovanie-sql-servera-razrabot","title":{"rendered":"SQL serverinin idar\u0259 edilm\u0259si: t\u0259rtibat, t\u0259hl\u00fck\u0259sizlik, DB yarad\u0131lmas\u0131","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

SQL Server<\/strong> \u2013 unikal m\u0259hsuldur ki, b\u00f6y\u00fck sayda m\u0259lumat bazalar\u0131 il\u0259 i\u015fl\u0259y\u0259 bilir, proqramla\u015fd\u0131rma v\u0259 idar\u0259etm\u0259 funksiyalar\u0131n\u0131 yerin\u0259 yetirir.<\/span><\/p>\n

SQL serverinin idar\u0259 olunmas\u0131 m\u0259lumat bazas\u0131 sisteminin haz\u0131rlanmas\u0131n\u0131, t\u0259hl\u00fck\u0259sizlik sisteminin yarad\u0131lmas\u0131n\u0131, veril\u0259nl\u0259r bazas\u0131n\u0131n, obyektl\u0259rin t\u0259rtib edilm\u0259sini n\u0259z\u0259rd\u0259 tutur, eyni zamanda istifad\u0259\u00e7il\u0259r\u0259 m\u00f6vcud m\u0259lumatlara daxil olma\u011f\u0131 m\u00fcmk\u00fcn edir. <\/span>
\n\u0130dar\u0259\u00e7i m\u00fcnt\u0259z\u0259m olaraq ehtiyat n\u00fcsx\u0259l\u0259rini yarad\u0131r, m\u0259lumat sisteminin b\u00fct\u00f6vl\u00fcy\u00fcn\u00fc yoxlay\u0131r, m\u0259lumat fayllar\u0131n\u0131n v\u0259 tranzaksiya jurnal\u0131n\u0131n icaz\u0259 veril\u0259n h\u0259cmini n\u0259zar\u0259td\u0259 saxlay\u0131r.<\/span><\/p>\n

BD \u2014 adland\u0131r\u0131lm\u0131\u015f ba\u011fl\u0131 komponentl\u0259rin toplusu<\/span><\/strong><\/p>\n

Bu baza x\u00fcsusi sistem t\u0259r\u0259find\u0259n idar\u0259 olunur v\u0259 aktual olmas\u0131n\u0131 d\u0259st\u0259kl\u0259y\u0259n, laz\u0131m olan m\u0259lumatlar\u0131n s\u00fcr\u0259tli axtar\u0131\u015f\u0131n\u0131 t\u0259\u015fkil ed\u0259n dil v\u0259 proqram vasit\u0259l\u0259rinin kompleksidir. <\/span>
\nDB-nin strukturu.<\/span>
\nKeyfiyy\u0259tli m\u0259lumat bazas\u0131 t\u0259\u015fkil etm\u0259k \u00fc\u00e7\u00fcn idar\u0259\u00e7i m\u0259suliyy\u0259tli yana\u015fmal\u0131, m\u00f6vcud m\u0259lumatlar\u0131n bir \u00e7ox t\u0259tbiq variantlar\u0131n\u0131 d\u0259rind\u0259n \u00f6yr\u0259nm\u0259li, dig\u0259r sisteml\u0259rl\u0259 olas\u0131 inteqrasiyan\u0131 v\u0259 daxil olma\u011f\u0131 n\u0259z\u0259rd\u0259 tutmal\u0131, m\u00fcasir texnologiyalardan istifad\u0259 etm\u0259kl\u0259 sistemd\u0259 t\u0259l\u0259b olunan d\u0259yi\u015fiklikl\u0259ri etm\u0259lidir.<\/span><\/p>\n

SQL-in idar\u0259 olunmas\u0131 server<\/a> iki versiyada h\u0259yata ke\u00e7irilir.<\/span><\/strong><\/p>\n

Birincisi \u2013 fayl-serverdir, burada DB fayl-serverd\u0259 yerl\u0259\u015fir,sunucusu<\/a>bu, m\u00fcxt\u0259lif komp\u00fcterl\u0259rd\u0259 \u00e7al\u0131\u015fan m\u00fc\u015ft\u0259ril\u0259rin m\u0259lumat bazas\u0131n\u0131 saxlamas\u0131n\u0131 v\u0259 ona giri\u015fini t\u0259min edir. Emal i\u015f stansiyalar\u0131nda h\u0259yata ke\u00e7irilir, burada DB fayllar\u0131 \u00f6t\u00fcr\u00fcl\u00fcr. M\u00fc\u015ft\u0259ri \u015f\u0259xsi komp\u00fcterl\u0259rind\u0259 idar\u0259etm\u0259 sistemin\u0259 sahibdir v\u0259 bu, \u00f6t\u00fcr\u00fclm\u00fc\u015f m\u0259lumatlar\u0131 emal edir.<\/span>
\nM\u00fc\u015ft\u0259ri-server versiyas\u0131, eyni zamanda m\u0259lumatlar\u0131n tam h\u0259cmini emal edir, saxlan\u0131lmas\u0131ndan ba\u015fqa. \u0130cra olunmas\u0131 \u00fc\u00e7\u00fcn g\u00f6nd\u0259ril\u0259n sor\u011fu m\u00fc\u015ft\u0259ri t\u0259r\u0259find\u0259n, laz\u0131mi m\u0259lumatlar\u0131n axtar\u0131\u015f\u0131n\u0131 v\u0259 \u00e7\u0131xar\u0131lmas\u0131n\u0131 t\u0259\u015fviq edir. Bu m\u0259lumat, \u015f\u0259b\u0259k\u0259 vasit\u0259sil\u0259 serverd\u0259n m\u00fc\u015ft\u0259riy\u0259 \u00f6t\u00fcr\u00fcl\u00fcr.<\/span>
\nM\u00fc\u015ft\u0259ri-server iki hiss\u0259d\u0259n ibar\u0259tdir: m\u00fc\u015ft\u0259ri v\u0259 server.<\/span>
\nM\u00fc\u015ft\u0259ri hiss\u0259si \u015f\u0259xsi komp\u00fcterd\u0259 yerl\u0259\u015fir, o, qrafik interfeysin t\u0259minat\u0131 funksiyalar\u0131n\u0131 h\u0259yata ke\u00e7irir.<\/span>
\nServer hiss\u0259si is\u0259 t\u0259chiz edilmi\u015f serverd\u0259<\/a> yerl\u0259\u015fdirilir v\u0259 m\u0259lumatlar\u0131n ayr\u0131lmas\u0131, m\u0259lumat bazas\u0131n\u0131n idar\u0259 edilm\u0259si, idar\u0259etm\u0259 xidm\u0259tl\u0259ri v\u0259 t\u0259hl\u00fck\u0259sizlik t\u0259dbirl\u0259rinin h\u0259yata ke\u00e7irilm\u0259sini t\u0259min edir. <\/span>
\nM\u00fc\u015ft\u0259ri-server sistemi, sor\u011fular\u0131 strukturla\u015fd\u0131ran v\u0259 veril\u0259nl\u0259r bazas\u0131na daxil olma\u011f\u0131 t\u0259min ed\u0259n x\u00fcsusi dil ifad\u0259l\u0259rini istifad\u0259 etm\u0259yi xarakteriz\u0259 edir.<\/span><\/p>\n

 <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"

SQL Server - b\u00f6y\u00fck miqdarda informasiya bazalar\u0131 il\u0259 i\u015fl\u0259y\u0259 bil\u0259n unikal bir m\u0259hsuldur, proqramla\u015fd\u0131rma v\u0259 idar\u0259etm\u0259 funksiyalar\u0131n\u0131 yerin\u0259 yetirir. SQL serverinin idar\u0259 edilm\u0259si, informasiya bazas\u0131 sisteminin i\u015fl\u0259nilm\u0259si, t\u0259hl\u00fck\u0259sizlik sisteminin yarad\u0131lmas\u0131, veril\u0259nl\u0259r bazas\u0131n\u0131n t\u0259rtibi v\u0259 obyektl\u0259rin yarad\u0131lmas\u0131n\u0131 n\u0259z\u0259rd\u0259 tutur, el\u0259c\u0259 d\u0259 istifad\u0259\u00e7il\u0259rin bazada olan m\u0259lumatlara giri\u015fini m\u00fcmk\u00fcn edir.<\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":1016,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[688],"tags":[],"class_list":["post-41921","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-administrirovanie"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\n","aioseo_head_json":{"title":"\ud83e\udd47 Pe\u015f\u0259karlar\u0131m\u0131z t\u0259r\u0259find\u0259n SQL serverl\u0259rinin \u00f6d\u0259ni\u015fli idar\u0259 edilm\u0259si | ProHoster","description":"SQL Server \u2013 unikal m\u0259hsuldur ki, b\u00f6y\u00fck sayda m\u0259lumat bazalar\u0131 il\u0259 i\u015fl\u0259y\u0259 bilir, proqramla\u015fd\u0131rma v\u0259 idar\u0259etm\u0259 funksiyalar\u0131n\u0131 yerin\u0259 yetirir.","canonical_url":"https:\/\/prohoster.info\/az\/blog\/administrirovanie\/administrirovanie-sql-servera-razrabot","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"az_AZ","og:site_name":"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b","og:type":"article","og:title":"\ud83e\udd47 \u041f\u043b\u0430\u0442\u043d\u043e\u0435 \u0430\u0434\u043c\u0438\u043d\u0438\u0441\u0442\u0440\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435 SQL \u0441\u0435\u0440\u0432\u0435\u0440\u043e\u0432 \u043d\u0430\u0448\u0438\u043c\u0438 \u0441\u043f\u0435\u0446\u0438\u0430\u043b\u0438\u0441\u0442\u0430\u043c\u0438 | ProHoster","og:description":"SQL Server \u2013 \u0443\u043d\u0438\u043a\u0430\u043b\u044c\u043d\u044b\u0439 \u043f\u0440\u043e\u0434\u0443\u043a\u0442, \u0441\u043f\u043e\u0441\u043e\u0431\u043d\u044b\u0439 \u0440\u0430\u0431\u043e\u0442\u0430\u0442\u044c \u0441 \u043e\u0433\u0440\u043e\u043c\u043d\u044b\u043c \u043a\u043e\u043b\u0438\u0447\u0435\u0441\u0442\u0432\u043e\u043c \u0438\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0438\u043e\u043d\u043d\u044b\u0445 \u0431\u0430\u0437, \u0432\u044b\u043f\u043e\u043b\u043d\u044f\u0435\u0442 \u0444\u0443\u043d\u043a\u0446\u0438\u0438 \u043f\u0440\u043e\u0433\u0440\u0430\u043c\u043c\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f \u0438 \u0430\u0434\u043c\u0438\u043d\u0438\u0441\u0442\u0440\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f.","og:url":"https:\/\/prohoster.info\/az\/blog\/administrirovanie\/administrirovanie-sql-servera-razrabot","og:image":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:secure_url":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:width":350,"og:image:height":350,"article:published_time":"2017-04-20T21:00:00+00:00","article:modified_time":"2020-02-18T10:44:41+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"41921","title":"\ud83e\udd47 SQL serverl\u0259rinin \u00f6d\u0259ni\u015fli idar\u0259 edilm\u0259si m\u00fct\u0259x\u0259ssisl\u0259rimiz t\u0259r\u0259find\u0259n | #site_title","description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"seo_analyzer_scan_date":"2026-02-22 15:36:49","breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-03-01 00:08:31","updated":"2026-02-22 15:36:49","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/az\/wp-json\/wp\/v2\/posts\/41921","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/az\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/az\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/az\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/az\/wp-json\/wp\/v2\/comments?post=41921"}],"version-history":[{"count":2,"href":"https:\/\/prohoster.info\/az\/wp-json\/wp\/v2\/posts\/41921\/revisions"}],"predecessor-version":[{"id":162054,"href":"https:\/\/prohoster.info\/az\/wp-json\/wp\/v2\/posts\/41921\/revisions\/162054"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/az\/wp-json\/wp\/v2\/media\/1016"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/az\/wp-json\/wp\/v2\/media?parent=41921"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/az\/wp-json\/wp\/v2\/categories?post=41921"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/az\/wp-json\/wp\/v2\/tags?post=41921"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}