I downloaded a backup copy of my database now I want to convert this backup copy that end with the extension .BAK into a working copy for my local server. Can someone tell how to convert a SQL database.
No such thing as a "Convert". That file is a backup file. You restore that file either over an existing database or allow SQL Server to create a new database from that file. I find it easier and more simple to allow SQL to overwrite an existing database.