how to copy my database from local to a hosting SQL Server
I just purchased windows hosting on Hostforlife.eu. The package I purchased comes with SQL Server. I am currently running SQL Server locally which I use to provide some information on one of my webpages. I am trying to copy my local database and put it on the SQL Server on Hostforlife but I am having a really hard time.
I've connected with SQL Server Management Studio to the Hostforlife.eu server successfully. Once there I can see the database I have created. I go to restore, then I select to restore from device but I am not able to select any local files from my machines (I have created a .bak file of my database.).
Does anyone know how to successfully Copy an entire database that has already been created to a SQL Server database on Hostforlife?
Any help would be greatly appreciated it.