I found myself having to restore a Microsoft SQL 2000 database using only a file system backup. I was very cautious about my approach, because I wanted to restore the database to a database with a different name. I did this by using “Attach database …” from Enterprise Manager. <\/p>\n
Right mouse click on “Databases”.
\nGo to “All Tasks”
\nThen, “Attach Database…”
\nBrowse to MDF file that you restored (MDF and LDF should be restored from file system backup), by clicking the “…” next to the “Verify” button.
\nThen, database name you want to use for the restored database in the “Attach as” field.
\nThen, choose the database owner in the “Specify database owner” drop down.<\/p>\n
It worked great, and was simple. Of course, I know that I should be doing the restores from a SQL backup, but circumstances came up where that was the only backup I had to work from. I will probably verify this procedure on a more current version of SQL server and update accordingly. <\/p>\n
I decided to go from one extreme to the other. I installed SQL Server 2012 RCO to try to restore a database from a file system backup. It is a little different, but basically the same steps.<\/p>\n
Right mouse click on “Databases” and click “Attach…”
\nClick the “Add…” button and add the mdf file you restored.
\nThen double click the name under the “Attach As” column heading to restore to a database with a different name.
\nClick “Ok” to finish.<\/p>\n","protected":false},"excerpt":{"rendered":"
I found myself having to restore a Microsoft SQL 2000 database using only a file system backup. I was very cautious about my approach, because I wanted to restore the database to a database with a different name. I did this by using “Attach database …” from Enterprise Manager. Right mouse click on “Databases”. Go [&hellip<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[219,218,98],"class_list":["post-621","post","type-post","status-publish","format-standard","hentry","category-documentation","tag-attach","tag-mssql","tag-restore"],"share_on_mastodon":{"url":"","error":""},"_links":{"self":[{"href":"https:\/\/jim-zimmerman.com\/index.php?rest_route=\/wp\/v2\/posts\/621","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jim-zimmerman.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jim-zimmerman.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jim-zimmerman.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/jim-zimmerman.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=621"}],"version-history":[{"count":4,"href":"https:\/\/jim-zimmerman.com\/index.php?rest_route=\/wp\/v2\/posts\/621\/revisions"}],"predecessor-version":[{"id":626,"href":"https:\/\/jim-zimmerman.com\/index.php?rest_route=\/wp\/v2\/posts\/621\/revisions\/626"}],"wp:attachment":[{"href":"https:\/\/jim-zimmerman.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=621"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jim-zimmerman.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=621"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jim-zimmerman.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=621"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}