>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

Does the account you are using when you do the backup maybe not have rights to the missing tables?

Are the tables named something really screwey that might be reserved or illegal in SQL?