Take backup of MS SQL server tables

Posted on 2007-07-25
Medium Priority
Last Modified: 2010-03-19
I have many tables in the master database of MS SQL Server in my local PC.

I need to take a copy of these as I have to move it to the SERVER. and also take backup..

Please let me know the steps involved
Question by:jawahar_prasad
  • 2
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 19567349
backing up the individual tables are not possible in sql, you can take the full backup

Accepted Solution

sabeesh earned 2000 total points
ID: 19567362
You can use DTS Import export wizard for this.
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 19567365

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article, we’ll look at how to deploy ProxySQL.
What we learned in Webroot's webinar on multi-vector protection.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question