Home Forums Database Design Design Ideas and Questions Multiple Apps in one Database RE: Multiple Apps in one Database

  • May 22, 2015 at 5:48 am

    #1799966

    GilaMonster (5/22/2015)

    Brandie Tarvin (5/22/2015)

    That being said... Yes, you could do backups for individual subsets of tables, assuming you put each applications schema on a different file. But as has been mentioned, backups and restores will be infinitely more complicated.

    You can do *backups* of subsets of tables. You cannot however do restores of subsets of tables.

    A filegroup restore has to be followed by log restores to bring the newly restored filegroup back up to the same point in time as the rest of the database.

    Hence, if all apps are in the same database, the question "Can you restore App3's data to yesterday 4pm as there was a mistake in the overnight processing" has the answer "No."

    All good points. Thank you for the clarification.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.