Skip to main content

how to copy my database from local to a hosting SQL Server

Thread needs solution
Beginner
Posts: 1
Comments: 0

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.

Thanks :)

0 Users found this helpful