Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

regarding backups Expand / Collapse
Author
Message
Posted Wednesday, November 27, 2013 3:59 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, June 27, 2014 6:36 AM
Points: 37, Visits: 86

Hi All,

I have 500 tables in a database. i want to take the backup and restore the 3 tables along with its data and properties. how can i take back up and restore those tables can anyone tell me about that process.

Thanks,
Avinash
Post #1517984
Posted Wednesday, November 27, 2013 4:03 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, November 28, 2013 10:20 PM
Points: 45, Visits: 309
You can use Export/Import Wizard to achieve this task. You can also use bcp to achieve this.
can also try: select * into new_table from old_table
Post #1517986
Posted Wednesday, November 27, 2013 6:08 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 29, 2014 11:29 PM
Points: 147, Visits: 587
Hi,
i too go for export table option rather than backup/restore just for few tables.




Praveen D'sa
MCITP - Database Administrator 2008
http://sqlerrors.wordpress.com
Post #1518038
Posted Wednesday, November 27, 2013 8:03 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 7:33 AM
Points: 1,361, Visits: 15,264
How big are the tables? If the are each several GB each then I'd consider going with backup/restore then drop the extra tables.

If they are relatively small I would go with export/import.

You need to weigh up the pros and cons of both.

You cannot natively restore single tables.

Post #1518088
Posted Wednesday, November 27, 2013 8:11 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 8:52 AM
Points: 980, Visits: 1,324
I see several options. Import/Export is one option, so is Bulk Copy. I use a Red-Gate tool SQL Data Compare which may be a bit more than what you are looking to do, but will do the trick as well.

Good luck.

Kurt


Kurt W. Zimmerman
SR DBA
Lefrak Organization
New York, NY

http://www.linkedin.com/in/kurtwzimmerman
Post #1518092
Posted Wednesday, November 27, 2013 8:33 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 5:17 AM
Points: 5,230, Visits: 9,457
Also, some third-party backup utilities, such as Litespeed, include object-level restore. I've never used that feature so I don't know how well it works.

John
Post #1518099
Posted Thursday, November 28, 2013 12:00 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, June 27, 2014 6:36 AM
Points: 37, Visits: 86

Thank you all.
Post #1518263
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse