Browse by Tags

Log Shipping error "Unable to copy the initialization file"

Published 3 October 7 6:49 AM | SSQA.net

When configuring log shipping on a highly transactional environment (with SQL Clustering setup), we were hit by above error. All the Logins and their privileges are intact within the primary and standby servers along with Local server policies & group...

Filed under: sql server, high availability, server, login, cluster, log shipping, service account, firewall, unable, filecopy

SP_HELP_REVLOGIN for SQL Server 2005

Published 4 September 7 8:54 AM | SSQA.net

SP_HELP_REVLOGIN stored procedure helps you to generate a script that can be used to recreate the logins that exist on a server at a specific point in time script the logins along with password. I'm not sure how many DBA are aware of this Stored Procedure...

Filed under: sql server, security, server, login, self, copy, sp_help_revlogin