{"id":112,"date":"2011-04-26T12:17:55","date_gmt":"2011-04-26T12:17:55","guid":{"rendered":"http:\/\/eldar.pro\/?p=112"},"modified":"2019-07-18T22:05:24","modified_gmt":"2019-07-18T22:05:24","slug":"%d0%b8%d0%b7%d0%bc%d0%b5%d0%bd%d0%b5%d0%bd%d0%b8%d0%b5-%d1%80%d0%b0%d1%81%d0%bf%d0%be%d0%bb%d0%be%d0%b6%d0%b5%d0%bd%d0%b8%d1%8f-%d1%84%d0%b0%d0%b9%d0%bb%d0%be%d0%b2-%d1%80%d0%b5%d1%81%d1%83%d1%80","status":"publish","type":"post","link":"https:\/\/eldar.pro\/?p=112","title":{"rendered":"\u0418\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u0435 \u0440\u0430\u0441\u043f\u043e\u043b\u043e\u0436\u0435\u043d\u0438\u044f \u0444\u0430\u0439\u043b\u043e\u0432 \u0440\u0435\u0441\u0443\u0440\u0441\u043d\u043e\u0439 \u0411\u0414 \u0432 SQL Server 2008 R2"},"content":{"rendered":"

\u0412 SQL Server 2005 \u0438\u0437\u043c\u0435\u043d\u044f\u0442\u044c \u0440\u0430\u0441\u043f\u043e\u043b\u043e\u0436\u0435\u043d\u0438\u0435 \u0444\u0430\u0439\u043b\u043e\u0432 \u0440\u0435\u0441\u0443\u0440\u0441\u043d\u043e\u0439 \u0411\u0414 \u043c\u043e\u0436\u043d\u043e, \u0447\u0442\u043e \u0437\u0430\u044f\u0432\u043b\u0435\u043d\u043e \u0432 msdn.<\/a>
\n\u041f\u043e\u0441\u043c\u043e\u0442\u0440\u0438\u043c \u0442\u0430\u043c \u0436\u0435 \u043e SQL Server 2008 R2<\/a>, \u0447\u0438\u0442\u0430\u0435\u043c:
\nThe resource database cannot be moved.<\/strong><\/p>\n

\u0412\u0441\u0435 \u0436\u0435 \u043f\u043e\u043b\u044e\u0431\u043e\u043f\u044b\u0442\u0441\u0442\u0432\u0443\u0435\u043c, \u0438 \u043f\u043e\u043f\u0440\u043e\u0431\u0443\u0435\u043c \u0441\u0434\u0435\u043b\u0430\u0442\u044c\u00a0\u0442\u0430\u043a \u0436\u0435, \u043a\u0430\u043a \u043e\u043f\u0438\u0441\u0430\u043d\u043e \u0432 msdn \u0434\u043b\u044f SQL Server 2005:<\/p>\n

C:\\>NET START MSSQLSERVER \/f \/T3608<\/code><\/pre>\n
\u041f\u0440\u043e\u0432\u0435\u0440\u0438\u043c \u0432\u0435\u0440\u0441\u0438\u044e:<\/p>\n
select @@version<\/code><\/pre>\n
Microsoft SQL Server 2008 R2 (SP2) – 10.50.4000.0 (X64) Jun 28 2012 08:36:30 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1(Build 7601: Service Pack 1) (Hypervisor)
\n<\/em>
\n\u0417\u0430\u0434\u0430\u0435\u043c \u043d\u043e\u0432\u043e\u0435 \u0440\u0430\u0441\u043f\u043e\u043b\u043e\u0436\u0435\u043d\u0438\u0435:<\/p>\n
ALTER DATABASE mssqlsystemresource\n MODIFY FILE (NAME=data, FILENAME= 'C:\\DATA\\mssqlsystemresource.mdf');\n ALTER DATABASE mssqlsystemresource\n MODIFY FILE (NAME=log, FILENAME= 'C:\\DATA\\mssqlsystemresource.ldf');<\/pre>\n
The file “data” has been modified in the system catalog. The new path will be used the next time the database is started.
\nThe file “log” has been modified in the system catalog. The new path will be used the next time the database is started.
\n<\/em>
\n\u041f\u0435\u0440\u0435\u043c\u0435\u0449\u0430\u0435\u043c \u00a0\u0444\u0430\u0439\u043b\u044b \u0411\u0414 mssqlsystemresource:<\/p>\n
C:\\>move \"C:\\Program Files\\Microsoft SQL Server\\MSSQL10_50.MSSQLSERVER\\MSSQL\\Binn\\mssqlsystemresource.*\" C:\\DATA\\<\/code><\/pre>\n
C:\\Program Files\\Microsoft SQL Server\\MSSQL10_50.MSSQLSERVER\\MSSQL\\Binn\\mssqlsystemresource.ldf<\/code>
\nC:\\Program Files\\Microsoft SQL Server\\MSSQL10_50.MSSQLSERVER\\MSSQL\\Binn\\mssqlsystemresource.mdf<\/code>
\n2 file(s) moved.<\/code><\/em><\/p>\n
\u0418 \u043f\u0435\u0440\u0435\u0437\u0430\u043f\u0443\u0441\u043a\u0430\u0435\u043c SQL Server – \u0432\u0441\u0451 \u0440\u0430\u0431\u043e\u0442\u0430\u0435\u0442.<\/p>\n","protected":false},"excerpt":{"rendered":"
\u0412 SQL Server 2005 \u0438\u0437\u043c\u0435\u043d\u044f\u0442\u044c \u0440\u0430\u0441\u043f\u043e\u043b\u043e\u0436\u0435\u043d\u0438\u0435 \u0444\u0430\u0439\u043b\u043e\u0432 \u0440\u0435\u0441\u0443\u0440\u0441\u043d\u043e\u0439 \u0411\u0414 \u043c\u043e\u0436\u043d\u043e, \u0447\u0442\u043e \u0437\u0430\u044f\u0432\u043b\u0435\u043d\u043e \u0432 msdn. \u041f\u043e\u0441\u043c\u043e\u0442\u0440\u0438\u043c \u0442\u0430\u043c \u0436\u0435 \u043e SQL Server 2008 R2, \u0447\u0438\u0442\u0430\u0435\u043c: The resource database cannot be moved. \u0412\u0441\u0435 \u0436\u0435 \u043f\u043e\u043b\u044e\u0431\u043e\u043f\u044b\u0442\u0441\u0442\u0432\u0443\u0435\u043c, \u0438 \u043f\u043e\u043f\u0440\u043e\u0431\u0443\u0435\u043c \u0441\u0434\u0435\u043b\u0430\u0442\u044c\u00a0\u0442\u0430\u043a \u0436\u0435, \u043a\u0430\u043a \u043e\u043f\u0438\u0441\u0430\u043d\u043e \u0432 msdn \u0434\u043b\u044f SQL Server 2005: C:\\>NET START MSSQLSERVER \/f \/T3608 \u041f\u0440\u043e\u0432\u0435\u0440\u0438\u043c \u0432\u0435\u0440\u0441\u0438\u044e: select @@version Microsoft SQL […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[39],"tags":[],"class_list":["post-112","post","type-post","status-publish","format-standard","hentry","category-s-sql-server-ru"],"_links":{"self":[{"href":"https:\/\/eldar.pro\/index.php?rest_route=\/wp\/v2\/posts\/112","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/eldar.pro\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/eldar.pro\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/eldar.pro\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/eldar.pro\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=112"}],"version-history":[{"count":7,"href":"https:\/\/eldar.pro\/index.php?rest_route=\/wp\/v2\/posts\/112\/revisions"}],"predecessor-version":[{"id":474,"href":"https:\/\/eldar.pro\/index.php?rest_route=\/wp\/v2\/posts\/112\/revisions\/474"}],"wp:attachment":[{"href":"https:\/\/eldar.pro\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=112"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/eldar.pro\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=112"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/eldar.pro\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=112"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}