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:

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 Security Tip: Protect your backups! Many DBAs often do not realize that anyone that can get to your SQL Server database backups can also restore those backups on their own SQL Server. One additional layer of file-based security that you can add in is to put a password on your backup file. This can only be done with Transact-SQL but it cannot be bypassed during the restore Performance Tip: Don't apply the "Auto Shrink" database option for a production database. Auto Shrink is very expensive and can negatively impact the performance of your live system