title: script to restore database sql server from bak file, doesn't work
body: <p>I have an empty database: </p>
  
  <p><code>DB_Clients</code></p>
  
  <p>And I want to restore the database from a <code>.bak</code> file: </p>
  
  <pre><code>OldDBClients.bak
  </code></pre>
  
  <p>This is the path:</p>
  
  <pre><code>C:\OldDBClients.bak
  </code></pre>
  
  <p>And this is my script:</p>
  
  <pre><code>USE [master]
  GO
      RESTORE DATABASE DB_Clients
      FROM DISK = 'C:\OldDBClients.bak'
  </code></pre>
  
  <p>When I execute it, I get this error message:</p>
  
  <blockquote>
    <p>Msg 3154, Level 16, State 4, Line 15<br>
    The backup set holds a backup of a database other than the existing 'DB_Clients' database.<br>
    Msg 3013, Level 16, State 1, Line 15<br>
    RESTORE DATABASE is terminating abnormally.</p>
  </blockquote>
  
  <p>Can someone tell me why this happen?
  I have to point that the file has the permissions to read and write. </p>
  
  <p>Thank's.</p>