In Oracle there a way to 'freeze' a tablespace when doing a backup. Does SQL Server have a way to 'freeze' the tables or the database?Jorge,
I don't quite understand what you are trying to do. If you can
ALTER database SET Read_Only
before the backup, then you will ensure that no changes are being made
during the backup. (But a backup picks up the transaction log changes made
during the backup as well, so your data would be complete as of the
completion of the backup.) I suspect that this is not what you are after.
Russell Fields
"Jorge" <anonymous@.discussions.microsoft.com> wrote in message
news:1C6E1130-BCBB-4E0D-A7EC-86DFA941B9B7@.microsoft.com...
> In Oracle there a way to 'freeze' a tablespace when doing a backup. Does
SQL Server have a way to 'freeze' the tables or the database?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment