SQL Q+A Preventing Reboots, Installing Multiple Updates, and More
That said, there are reasons to segregate data into multiple databases:
- A subset of data has different backup requirements from other data.
- Certain data needs a separate security context, that is, a different database owner.
- Sometimes data exists for historical purposes and needs to be kept in read-only mode.
Edited by Nancy Michell
© 2008 Microsoft Corporation and CMP Media, LLC. All rights reserved; reproduction in part or in whole without permission is prohibited.