Definitions
Sorry, no definitions found. Check out and contribute to the discussion of this word!
Etymologies
Sorry, no etymologies found.
Support
Help support Wordnik (and make this page ad-free) by adopting the word tail-log.
Examples
-
The option to back up the tail-log and leave the database in a NO RECOVERY state This new ability to leave the database in a NO RECOVERY state after backing up the tail - log may seem like a relatively insignificant change, but I've seen far too many tail-logs destroyed by accident (usually followed by the question, "So how do I get those changes back?").
-
As Figure A-1 shows, you now have the option within the GUI of backing up the tail-log and leaving the database in a NO RECOVERY state.
-
Had the company been running SQL Server 2005 or higher, the following features would have helped significantly: • Tail-log: If the tail-log had been available for backup, SQL Server 2005 would have given the server staff a warning to back up the tail-log before proceeding.
-
Slide 366: 340 sINDEX overview, 321 SUSPECT_PAGE table, 31, 64, 73 tail-log backups, 322 sys. database_mirroring_endpoints table, 208 Change Tracking feature,
-
Step 2: Restore Any Remaining Log Backups It's possible that you still have log backups and perhaps even a tail-log backup that you can restore.
-
The option to back up the tail-log and leave the database in a NO RECOVERY state This new ability to leave the database in a NO RECOVERY state after backing up the tail - log may seem like a relatively insignificant change, but I've seen far too many tail-logs destroyed by accident (usually followed by the question, "So how do I get those changes back?").
-
Anything that raises awareness of the need to perform a tail-log backup is good, to my mind.
-
Anything that raises awareness of the need to perform a tail-log backup is good, to my mind.
-
The option to back up the tail-log and leave the database in a NO RECOVERY state This new ability to leave the database in a NO RECOVERY state after backing up the tail - log may seem like a relatively insignificant change, but I've seen far too many tail-logs destroyed by accident (usually followed by the question, "So how do I get those changes back?").
-
If you only want to bring the PRIMARY filegroup back online, you can simply follow your normal restore procedure but include the PARTIAL clause-for example: -- Always backup the tail-log!
Comments
Log in or sign up to get involved in the conversation. It's quick and easy.