How to ensure dbs are all in sync when restored?
Posted
by blade
on Server Fault
See other posts from Server Fault
or by blade
Published on 2010-06-15T22:46:39Z
Indexed on
2010/06/15
22:53 UTC
Read the original article
Hit count: 102
Hi,
In large server environments, how do you handle the issue of backing up SQL Server dbs which may not be in sync with other dbs they rely on?
So if I back up DB1 from a server, and it uses another db which is not backed up, doing a restore when the dbs are in differing state could cause problems? It seems like all dependent DBs should be backed up, regardless of size etc, but in my current job (where we're a datacentre company and I'm a .NET Developer), I only backup some of several dependent DBs on a SQL Server instance.
Thanks
© Server Fault or respective owner