How to Synchronize Logins Across Multiple Servers - Video Series Video Category: Database Creation, Management and Best Practices Skill Level: 400 (Intermediate - Advanced) Versions/Editions Covered: SQL Server 2005 , SQL Server 2000 , SQL Server 2008 One common task is to copy a database (or move) from one instance/server to another. This is used extensively by admins worldwide whenever they take a backup of production and deploy it to a test or development server or whenever they implement disaster recovery techniques like database mirroring, log shipping, or transactional replication. This series helps you understand the core architecture of SQL Server's login system - while showing you the common problems you face in your need to synchronize logins across multiple SQL Servers.

Videos in this Series:

Title Skill Length Download Pt. 1 - How to Synchronize Logins Between Two Servers     400 9 mins. Download Pt. 2 - Understanding How Logins in SQL Server Work (SQL Logins, Windows Logins)   400 12 mins. Download Pt. 3 - A Field Guide to Synchronizing Logins Between SQL Servers   400 10 mins. Download Pt. 4 - Issues With SIDs, Server Logins, Principals and Users   400 7 mins. Download Pt. 5 - Understanding the Different Ways to Synchronize Logins Between Servers   400 8 mins. Download

< Return to list of all videos

Miscellaneous Bits & Pieces:

Keyboard Shortcut for SQL Server Management Studio: CTRL+O opens a file You can use the "SQL Server 2000 Management Pack Guide" is a helpful guide to managing your SQL Server in the enterprise. Check out Microsoft's Download page and search for "SQL Server 2000 Management Pack Guide" for more Book You Should Probably Own: Kalen Delaney's "Inside SQL Server 2005"