>Do I use my own SQL Server Management Studio to attach it to the web server?
>
Usually you don't have client tools on the server (e.g. you may not have SSMS on the server). So, I assume the answer is Yes, you connect to that server using your local SSMS and attach the database. But the database file should be physically on the server.
If it's not broken, fix it until it is.
My Blog