Copy Database Wizard

I'm trying to copy a database from my laptop to my web server over the Internet using a VPN.
After solving all the common well documented problems with getting this to work, it now fails on the last step, where its supposed to be executing the job. The event log on the server says it failed to connect to my laptop. ("Failed to connect to server xxx") The event log on the laptop says that the server failed to log on. If I use the sa account it says the login failed for user 'sa', and if I use Windows Authentication it says SSPI handshake failed with error code 0x8009030c ... connection has been closed.
Of course this makes no sense as the first 2 steps of the wizard test that the login can be performed, and the SQL Management studio on the server can connect to my laptop fine either way.
I just spent several hours getting the encrypted connection to work between my laptop and the server. The server is in texas, i'm in BC. I had to set up a VPN, edit the windows hosts file to map the computer names to the VPN ip's, export a certificate from the server to my laptop, and change the sql server to run as 'local service' instead of 'network service' just to get this far.
Isn't there an easier way to do this? Why can't I just create a database with the same name on the server and overwrite the database files with ones from my laptop. It would take about 30 seconds instead of 30 hours...
Could any of the other features of sql server help me with this? replication? subscriptions? linked servers? data export wizards?
i noticed in the event log on the source computer if i use windows authenticaiton it fails to connect to the server as 'anonymous user' or something like that. maybe thats a clue?|||bump...
i solved my problem by copying a backup file to the server and got the restore working. But i still want to know why this doesn't work. I have problems with other wizards too, and knowing whats going on here might help me fix the other problems.

Copy Database to another server

Hello there
I have database on my local server
I have also database on internet server
at 12:00pm i would like to update the internet server with all the changes
that made on the local server
how can i do this?
any help would be useful
If every table on your database has a primary key you should be using
transactional replication for this.
"Oded Kovach" <roygoldh@.hotmail.com> wrote in message
news:u8joTU$kEHA.1936@.TK2MSFTNGP12.phx.gbl...
> Hello there
> I have database on my local server
> I have also database on internet server
> at 12:00pm i would like to update the internet server with all the changes
> that made on the local server
> how can i do this?
> any help would be useful
>
|||Thankes kilary
I have many databases on the server
and some of the tables in some databases realy haven't primary key
These databases shouldn't be raplicated at all
How can i remove them from the list of the replication?
hope that you can help me
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:eDrqXlAlEHA.2500@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> If every table on your database has a primary key you should be using
> transactional replication for this.
>
> "Oded Kovach" <roygoldh@.hotmail.com> wrote in message
> news:u8joTU$kEHA.1936@.TK2MSFTNGP12.phx.gbl...
changes
>
|||Thanks Hilary
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:eDrqXlAlEHA.2500@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> If every table on your database has a primary key you should be using
> transactional replication for this.
>
> "Oded Kovach" <roygoldh@.hotmail.com> wrote in message
> news:u8joTU$kEHA.1936@.TK2MSFTNGP12.phx.gbl...
changes
>