Backup - How to exclude one object

Is there any way to exclude one object or table or view from the backup?
Or is there any work around?
Is Object level backup still exists? 
Tagged:

Answers

  • The usual way to backup parts of the database separately is to use filegroups, which can be backed up independently.

    You are probably thinking of Object Level Recovery, which basically inspects a backup file to retrieve the schema and data without needing to restore the database.  This is still a feature of SQL Compare, although some newer SQL Server features are not supported.
    Software Developer
    Redgate Software
Sign In or Register to comment.