How to copy ms sql file to a server.
I create a MS SQL database. Using Visual Studio I created a Web Site using the data.
I want to update the data so I was able to important to my local machine.
I made a copy of the local database (hrd.mbf) with the idea to just paste it on the server to replaces (hrd.mbf) on the server.
On the server
I put hrd.mbf offline when renamed it (hrd1.mbf)
I copied hrd.mbf.
In the SQL Server object Explorer it showed hrd (suspect) it added the word “suspect” next to the table.
I use Visual Studio to create a login page so only some employees can see the data. When I go to page it asks to login, which is what it is supposed to do when I to login I get an error message saying that it cannot connect to the hrd.
Does anyone know the correct way to do this?