|
Home > Archive > Microsoft SQL Server forum > August 2005 > Backup question
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
|
| Hello All,
I have a database that I am currently performing backup and incremental
backups.
If I were to add an extra table to the database or modify an existing table
with a few columns, would that imply that I would need to perform a full
back.
Thanks
| |
| Simon Hayes 2005-08-25, 3:36 am |
| Only if you don't want to wait for the next backup - modifying a table
is like making any other change in the database. If you've made a large
number of changes which would take some time to redo manually, and if
your database isn't very big, it might be worth making a backup so that
in the worst case you don't have to reapply the changes by hand. But
apart from that there are no special considerations.
Simon
|
|
|
|
|