Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I want to explain the following. I have a database that is a recovery db from our main environment. This database is kept up-to-date through log shipping. However, I want to copy all tables from this database to another SQL Server 2008r2. What the best way to approach this?

share|improve this question
Please clarify: are you using log shipping and want to know how to copy tables from the secondary server? You can read from the secondary server if it is setup in STANDBY mode. – StanleyJohns May 17 '13 at 8:41
And do you want to move structure and data, or just the structure? – Stuart Moore May 17 '13 at 8:45
Which edition of SQL Server are you running? select @@version will help if you're unsure. – Nathan Jolly May 17 '13 at 11:38
Just use management studio's import/export wizard and it will take care of creating the tables and importing data. You might want to disable referential integrity constraints if any. – avakharia May 17 '13 at 21:11

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.