The goal of the DBA Virtual Group is to provide a PASS community for the DBA. It provides a forum for open discussion and education on issues that face SQL Server database administrators.

Setting up log shipping with DBA tools

Wed, Jun 27 2018 16:00 UTC

Setting up log shipping with DBA tools

Have you ever tried to setup log shipping for one or more databases? You probably noticed the wide array of settings that have to be made for just one database. In most cases the settings only differentiate by the name of the database and some locations. Did you know you need about 40 clicks to setup log shipping for a single database? When it's finally setup, how do you check if the databases are in-sync? Have you setup log shipping as a warm stand-by? How do you recover the databases to get them online? We'll talk about the log shipping in general, applications for log shipping, third party solutions and possible competitors of log shipping. I'll show you how to use dba tools to setup a database for log shipping within minutes as well as how to test the status and how to recover to a functional database. If you’re interested in knowing more about log shipping and/or how to make your life easier, come to my session and I'll show you.


Sander Stad

Sander Stad is a SQL Server DBA and an MCSE Data Platform. Sander has worked with SQL Server since version 2000 and has over 15 years’ experience as a DBA. He has worked for a wide range of industries from financial institutes to agriculture.

Interested in Presenting to the DBA VG?

We can always use people to give a talk at one of our bi-monthly events. If you are interested in giving a presentation, please send your title, a brief abstract and a brief bio to Sharon Dooley.

Want to become a member of the DBA VG Leadership team?

Members of this team moderate meetings and interact with the speakers during the Q&A sessions. Contact Sharon Dooley, if you'd like to become part of the team.

Have a speaker to recommend?

Send the email address of the proposed speaker together with any relevant information about the speaker to Sharon Dooley.

 

Meeting Recordings

The DBA Virtual Group presentations are recorded. On the Meeting Archive page, you will find  .WMV files that can be viewed on-line. Select the event you are interested in, click the Show More button if it is visible, and the recording and any associated files will be visible.

Regular Meeting Schedule

The DBA Virtual Group holds two regular webinars each month. The first one is on the second Wednesday at noon, Mountain time and the second one is on the fourth Wednesday at noon, Eastern time. These 1 - 1¼ hour presentations include slides, demos and a time for questions and answers. The meetings are recorded and archived.

 

Follow us on Twitter: @PASS_DBA_VC

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids