>Hello all,
>
>I am pulling my hair out. I have a SQL database on my local machine and a SQL database on my web host. I am trying to move my database with the data contained to the other SQL Server. Both are SQL 2008 10.0.2531. When I right click my database, choose tasks, then pick backup I get a backup file of my database. Then when I restore that data to the other SQL Server there are three missing tables. Every time! What am I doing wrong or what might cause this? I really need those three tables and they contain too much data for me to re-create them. The other table have data and they come over.
>Thanks
>Tim
Maybe you could detach the database first, then copy it and attach back. Then you can attach the copied version to other server.
HTH.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham