{"id":3022,"date":"2019-09-10T02:39:32","date_gmt":"2019-09-09T17:39:32","guid":{"rendered":"https:\/\/1bed.allright.life\/?p=3022"},"modified":"2020-04-18T18:37:39","modified_gmt":"2020-04-18T09:37:39","slug":"post-3022","status":"publish","type":"post","link":"https:\/\/1bed.allright.life\/?p=3022","title":{"rendered":"MS SQL Server \u306e\u30c7\u30fc\u30bf\u3092 LocalDB \u306b\u30ea\u30b9\u30c8\u30a2\u3059\u308b"},"content":{"rendered":"

\u7d4c\u7def<\/h2>\n

\u672c\u756a DB \u306e\u30c7\u30fc\u30bf\u3092\u4f7f\u3063\u3066\u30c6\u30b9\u30c8\u3092\u884c\u3044\u305f\u3044\u3053\u3068\u304c\u3042\u308a\u3001\u30b5\u30fc\u30d0\u30fc\u3068\u3057\u3066\u4f7f\u308f\u308c\u3066\u3044\u308b MS SQL Server \u306b\u3042\u308b\u30c7\u30fc\u30bf\u3092\u3001\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u306e LocalDB \u306b\u30ea\u30b9\u30c8\u30a2\u3059\u308b\u3053\u3068\u306b\u3057\u305f<\/p>\n

\u305d\u306e\u6642\u306e\u30e1\u30e2\u3092\u5099\u5fd8\u9332\u3068\u3057\u3066\u96d1\u306b\u6b8b\u3059<\/p>\n

\u624b\u9806<\/h2>\n

MS SQL Server \u306e\u30d0\u30c3\u30af\u30a2\u30c3\u30d7<\/h3>\n
    \n
  1. SSMS(SQL Server Management Studio) \u3092\u8d77\u52d5<\/li>\n
  2. Object Explorer \u304b\u3089\u3001\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3092\u3068\u308b Database \u3092\u53f3\u30af\u30ea\u30c3\u30af -> Tasks -> Backup \u3092\u9078\u629e<\/li>\n<\/ol>\n

    \u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u30aa\u30d7\u30b7\u30e7\u30f3\u306f\u30c7\u30d5\u30a9\u30eb\u30c8\u3067\u53d6\u5f97<\/p>\n

    \u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u30d5\u30a1\u30a4\u30eb\u3092\u30ea\u30b9\u30c8\u30a2<\/h3>\n

    \u30af\u30e9\u30a4\u30a2\u30f3\u30c8 PC \u306b\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u30d5\u30a1\u30a4\u30eb\u3092\u79fb\u52d5<\/p>\n

    \u30af\u30e9\u30a4\u30a2\u30f3\u30c8 PC \u3067 SSMS \u3092\u8d77\u52d5\u3001LocalDB \u306b\u63a5\u7d9a
    \n\"\"<\/p>\n

    \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9 master \u3092\u53f3\u30af\u30ea\u30c3\u30af\u3057\u3066\u3001New Query \u3092\u9078\u629e
    \n\"\"<\/p>\n

    \u4e0b\u8a18\u30af\u30a8\u30ea\u30fc\u3092\u5b9f\u884c<\/p>\n

    RESTORE FILELISTONLY\nFROM DISK = '<\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u30d5\u30a1\u30a4\u30eb\u306e\u30d5\u30eb\u30d1\u30b9>';<\/code><\/pre>\n
    \u4f8b.
    \n\"\"<\/p>\n
    \u3053\u3053\u3067\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u30d5\u30a1\u30a4\u30eb\u306e LogicalName \u3092\u78ba\u8a8d\u3059\u308b<\/p>\n
    \u30ea\u30b9\u30c8\u30a2\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3059\u308b<\/p>\n
    RESTORE DATABASE <\u30ea\u30b9\u30c8\u30a2\u5148\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u540d>\nFROM DISK = '<\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u30d5\u30a1\u30a4\u30eb\u306e\u30d5\u30eb\u30d1\u30b9>'\n\nWITH MOVE '<LogicalName>' TO '<\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30d5\u30a1\u30a4\u30eb\u306e\u30d5\u30eb\u30d1\u30b9>',\nMOVE '<LogicalName>' TO '<\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30ed\u30b0\u30d5\u30a1\u30a4\u30eb\u306e\u30d5\u30eb\u30d1\u30b9,\nREPLACE;<\/code><\/pre>\n
    \u4f8b.
    \n\"\"<\/p>\n
    \u8003\u5bdf<\/h2>\n
    \u3067\u304d\u308b\u3053\u3068\u306f\u78ba\u8a8d\u3067\u304d\u305f\u306e\u3067\u3001\u30b3\u30de\u30f3\u30c9\u30e9\u30a4\u30f3\u5316\u3057\u3066\u697d\u3057\u305f\u3044<\/p>\n","protected":false},"excerpt":{"rendered":"
    \u7d4c\u7def \u672c\u756a DB \u306e\u30c7\u30fc\u30bf\u3092\u4f7f\u3063\u3066\u30c6\u30b9\u30c8\u3092\u884c\u3044\u305f\u3044\u3053\u3068\u304c\u3042\u308a\u3001\u30b5\u30fc\u30d0\u30fc\u3068\u3057\u3066\u4f7f\u308f\u308c\u3066\u3044\u308b MS SQL Server \u306b\u3042\u308b\u30c7\u30fc\u30bf\u3092\u3001\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u306e LocalDB \u306b\u30ea\u30b9\u30c8\u30a2\u3059\u308b\u3053\u3068\u306b\u3057\u305f \u305d\u306e\u6642\u306e\u30e1\u30e2\u3092\u5099\u5fd8\u9332\u3068\u3057\u3066\u96d1 […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[49],"tags":[99,117],"class_list":["post-3022","post","type-post","status-publish","format-standard","hentry","category-database","tag-localdb","tag-sqlserver"],"_links":{"self":[{"href":"https:\/\/1bed.allright.life\/index.php?rest_route=\/wp\/v2\/posts\/3022","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/1bed.allright.life\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/1bed.allright.life\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/1bed.allright.life\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/1bed.allright.life\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3022"}],"version-history":[{"count":14,"href":"https:\/\/1bed.allright.life\/index.php?rest_route=\/wp\/v2\/posts\/3022\/revisions"}],"predecessor-version":[{"id":3094,"href":"https:\/\/1bed.allright.life\/index.php?rest_route=\/wp\/v2\/posts\/3022\/revisions\/3094"}],"wp:attachment":[{"href":"https:\/\/1bed.allright.life\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3022"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/1bed.allright.life\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3022"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/1bed.allright.life\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3022"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}