Create QA database with only some production tables

5 pts.
Tags:
Clone database
Filegroup
QA
SQL scripts
SQL Server 2008
SQL Server tables
I have a large database with some tables that have largely static data. I need to make a new database on a different server with the same table structure with the static data tables intact (keys, etc.). The other tables must be empty. They're all in the same filegroup in the original database. I've done this once, by some sort of partial (copy only?) backup and changing filenames... but I've lost the script and I can't locate the original article (yes, I'm kicking myself). Thanks

Answer Wiki

Thanks. We'll let you know when a new response is added.

I believe that you are look for a file group backup and restore. That should give you the keywords to find the article you are looking for.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Rwaltz
    [...] Have anything to add mrdenny’s suggestion for a user trying to create QA database with only some production tables? 6. CharlieBrowne and TomLiotta provided some great suggestions for locking an [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following