Post reply

Table level backup

  • April 30, 2010 at 4:32 pm

    #222082

    Does SQL Server 2008 supports Table level backup?

    As we can do individual table level backups in ORACLE, I'm looking for the same option in SQL Server. I know that SQL Server 2005 did not support table level backup. But I'm not sure about SQL Server 2008.

    Thanks

  • April 30, 2010 at 4:55 pm

    #1160809

    not directly from MS, no table level backups.

    I believe some of the RedGate stuff does it, and i know you can script out the table and the data right from the SSMS GUI with SQL 2008, and send the results to a file.

    you'd just have to be careful about scripting out one table that had dependencies...you might save a snapshot of a table, and then potentially some data would be invalid due to foreign keys, with data dropped or updated.

    it's easy to make your own script to save the table structure and also a bcp format file and the data so you can quickly recover a table backed up via a script.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply