Post reply

Single Table Backup

  • April 12, 2012 at 9:42 am

    #392010

    Hi Friends

    I am working on Production on SQL Server 2005.

    I wrote a script and before run on that i need to backup first. i test my script on development environment.

    so is it possible in SQL Server 2005 to backup some selected tables or need to backup entire database?

    Thanks

  • April 12, 2012 at 9:48 am

    #1472708

    When I have a script that alters data in a production database, I like to do the following:

    Select *

    Into sometablebackup_date

    From sometable

    I will often also take a full backup - that depends on timing of when the script needs to be run.

    I believe redgate backup now permits you to backup a single table, but native sql backup does not.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

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

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