Saturday, June 30, 2007

New SQL Server 2005 Video Tutorial: Pt. 4 - How to Set Up Log Shipping Using SQL Server Management Studio's Properties Window

Pt. 4 - How to Set Up Log Shipping Using SQL Server Management Studio's Properties Window - view details
Finally - the lecture is finished and it's time to actually get your hands dirty by creating your first log shipping database.

Highlights from this video:
  • Using the SSMS tool to create and manage log shipping
  • Explanations of what tools you will use to manage log shipping
  • Setting up primary (a.k.a. the production) database for log shipping
  • Best practices for remote locations
  • Security concerns regarding proxies, credentials and the SQL Server Agent Service account
and much more


To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video


Keywords Associated with this video: standby servers, warm standby servers, disaster recovery, clusters, witness