title: "Logical file 'Movies' is not part of database"
body: <p>First and foremost, I am very brand new to databases so please keep instructions simple for me. thanks!</p>
  <p>Usually when I need to make a manual change I just back up my <strong>SQL Server Management Studio 2012</strong> database called <strong>Movies</strong>, then upload it to my host, then use their restore feature to implement it.</p>
  <p>I am still in a testing phase so data does not need to be kept that is acquired online, however I wanted to try keeping the data today so I used the host's backup option which created a <strong>DB_76779_test_backup.bak</strong> file for me.</p>
  <p>I then download this and &quot;attempted&quot; to updated it's information into the SQL database on my machine (<strong>Movie</strong>) which I believe is where I messed everything up.</p>
  <p>From what I remember I right-clicked my database &quot;Movies&quot; and selected &quot;Tasks -&gt; Restore -&gt; Database&quot;, I kept everything as is, but for <code>Source</code> I selected <strong>Device</strong> then chose the <code>DB_76779_test_backup.bak</code> file and and below that selected &quot;Movies&quot; as the Database and hit OK.</p>
  <p><img src="https://i.stack.imgur.com/kHB72.png" alt="enter image description here" /></p>
  <p>This seemed to work fine, so I opened and edited the tables values that needed to be changed. Then as usual, I just backed it up, ftp'ed it to the host, and restored my database.</p>
  <p>I got an error however when trying to restore and my support told me the following.</p>
  <blockquote>
  <p>&quot;Logical file 'Movies' is not part of database 'DB_76779_test'. Use
  RESTORE FILELISTONLY to list the logical file names.&quot;</p>
  <p>I'm afraid we only support restores of databases that contain only 1
  .mdf file and 1 .ldf file with no extra partitions.</p>
  </blockquote>
  <p>I am assuming that since the only different thing I did this time was restore my database on my computer is that somehow I broke it, or created more than 1 mdf and ldf file (no clue what those even are). All I was trying to do was keep the actual data from online, so I am not even sure if that was correct way to go about this, but regardless I am unable to restore the database on my host now..</p>
  <p>I am hoping someone here has instantly realized what idiotic mistake I made, because I only know a basic level of databasing and not much of the &quot;under the hood&quot; mechanics.</p>
  <p>Let me know if you need further details.</p>