quarta-feira, 13 de maio de 2015

AlwaysOn Availability Groups and SQL Server Jobs, Part 23: Maintenance Plan Backups and SSIS Packages

http://ift.tt/1AXnBle

In my last post, we took a look at some of the details involved in actually implementing backups against databases being hosted in AlwaysOn Availability Groups. In addition to providing a high-level overview of how sys.fn_hadr_backup_is_preferred_replica() works, I also mentioned that integrating it into backups managed by SQL Server Maintenance Plans isn’t as easy as what you’ll run into with other types of backups.

read more



from SQL Server Pro http://ift.tt/1kCjeYg

Nenhum comentário:

Postar um comentário

Leave your comment here!