How to import XML into SQL Server database?

SQL Server 2005 Selective Backup?

I need to do a backup of a database in SQL server 2005. The database is around 70Gig, I need to only backup some of the tables in the database so that I can restore this backup into a testing database. Is there a way to do this. Currently the only option I have is to do a import data into the test database and choose the tables I want to import.
Answer:

Then place those tables into a different filegroup and take backup of that filegroup only... SQL 2005 has option of partial restore so you can restore only them in test server and do your testing If you are new to SQL and want to learn SQL Server then Check out free SQL Server Video Tutorials at http://wtv.watchtechvideos.com

shaydes at Yahoo! Answers Visit the source

Was this solution helpful to you?

Related Q & A:

How to control the excessive use of ram by SQL Server?Best solution by Database Administrators
Can I create a second filestream container on an existing SQL Server 2008 database without going offline?Best solution by Database Administrators
How to connect Sql Server Database from android app?Best solution by Stack Overflow
How to upgrade sql server express 2005 to 2008R2?Best solution by Server Fault
How Do I Configure SQL Server 2005 Backend?Best solution by Server Fault

Just Added Q & A:

How many active mobile subscribers are there in China?Best solution by Quora
How to find the right vacation?Best solution by bookit.com
How To Make Your Own Primer?Best solution by thekrazycouponlady.com
How do you get the domain & range?Best solution by ChaCha
How do you open pop up blockers?Best solution by Yahoo! Answers

For every problem there is a solution! Proved by Solucija.

Got an issue and looking for advice?
Ask Solucija to search every corner of the Web for help.
Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.