Post reply

Can I back up part of database?

  • February 7, 2003 at 5:07 pm

    #80281

    Now I have a problem. In a database there's a huge table, I don't have to backup that table, but I have to backup anything else (other tables, SPs) except that table. Everyone can help. Thank you very much.

  • February 8, 2003 at 2:48 am

    #448455

    You could move that table into its own filegroup, then run filegroup backups.

    You will need to test your backup/restore process fully to ensure you can get your database back if needed to.

    Steven

  • February 11, 2003 at 12:06 pm

    #448673

    Thank you very much, I appreciate your help. And another thing is how can I back up all the stored procedures, I can't find any refers to put SPs in a filegroup. Thank.

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

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