• Steve beat me to it - I just thought of the same. If you restore the DB with standby, you can use bcp or probably SSIS to pull the data out. Presumably you already have a copy of the schema in your QA environment. If not, easy enough to use SSMS to generate scripts from the production server.



    Scott Duncan

    MARCUS. Why dost thou laugh? It fits not with this hour.
    TITUS. Why, I have not another tear to shed;
    --Titus Andronicus, William Shakespeare