Member of the LearnItFirst.com Video Training Network Related Video Training Sites: · SQL Programming Training Videos · SQL Server DBA Tutorials
   
SQL Server 2005 Database Administration Training Videos
SQL Server 2005 Videos in Series Home  Subscriber Videos  

How to Synchronize Logins Across Multiple Servers (Video Series)

Video Image Video Category: Security in SQL Server 2005

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:


Miscellaneous Bits & Pieces:
Want to see something cool? Run SELECT cacheobjtype, objtype, pagesused, sql FROM master.dbo.syscacheobjects ORDER BY pagesused DESC
Helpful Keyboard Shortcuts: "Windows key" + "D" shows the desktop
Tracert ("trace route") is a great command-line tool that you can use to trace the path that an Internet Protocol (IP) packet takes from the source to the destination. Tracert is a great tool for determining if a hub/router/switch is down or having problems

Other Websites We Offer
LearnSharePoint.com
Don't Forget!
100% Money Back Guarantee
 
   
 
About Us Video Playback Subscriptions More Video Training More
 
© Copyright 2004-2008 LearnItFirst.com LLC. All rights reserved. All trademarks remain the property of their respective owners. This site is not affiliated in any way with the Microsoft Corporation. Refer a Friend and Get a Free Subscription!
 
1/6/2009 1:26:07 AM