Riley Waterhouse Limited
Skip to content
  • Home
  • Blog
  • About

Month: April 2021

Where is the standby file?

Posted on April 19, 2021April 28, 2021 by Kev Riley

If you are using log shipping to keep a warm copy of a database ready for anything, or even using it to offload reporting, it is common to use the WITH STANDBY option of the RESTORE statement. By specifying this option you can bring a log-shipped database online in a read-only state, that you can Read more about Where is the standby file?[…]

Posted in SQL Server, TSQLLeave a comment

Recent Posts

  • JSONTABLE – Shredding JSON data into a relational structure
  • Where is the standby file?
  • SQL Monitor Alerts in Microsoft Teams
  • New home for session content
  • Closed answer technical tests and when ‘it depends’ isn’t an option

Recent Comments

    Archives

    • January 2022
    • April 2021
    • June 2019
    • October 2018
    • September 2018
    • March 2017
    • February 2017
    • December 2016
    • October 2016
    • June 2016
    • January 2015
    • November 2014
    • October 2014
    • April 2013
    • March 2013
    • May 2012

    Categories

    • Career
    • Community
    • Database Development
    • Monitoring
    • Powershell
    • Productivity
    • SQL Server
    • SSDT
    • SSRS
    • TSQL
    • Uncategorized

    Recent Posts

    • JSONTABLE – Shredding JSON data into a relational structure
    • Where is the standby file?
    • SQL Monitor Alerts in Microsoft Teams

    Search

    Strawberry Fields Digital Hub, Euxton Lane, Chorley, Lancashire PR7 1PS
    [email protected]
    +44(0)7808721595
    • Facebook link
    • Twitter link
    • LinkedIn link

    © Riley Waterhouse Limited 2018
    Icons by icons8.com

    Zelle Lite Developed by ThemeIsle