I have two servers- sql 2005 configured in log shipping configuration. Today I found that my log shipping confiuration is broken, so I have to reconfigure it again with the wizard - this means that new backup will be performed and restored on the second server. The primary database need to be online constantly and accept the request from the users. Is this possible? DB is around 100Gb and backup/restore process takes more than 1hr.
More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.
SQL Server Integration Services can read XML files, that’s known by every BI developer. (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.)
But how far can you go? When does the XML Source component become …