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

  • SSDT Warning SQL72038: The object already exists in database with a different definition and will not be altered.
  • JSONTABLE – Shredding JSON data into a relational structure
  • Where is the standby file?
  • SQL Monitor Alerts in Microsoft Teams
  • New home for session content

Recent Comments

  • Philip Thomas on JSONTABLE – Shredding JSON data into a relational structure
  • Philip Thomas on JSONTABLE – Shredding JSON data into a relational structure
  • Deron on JSONTABLE – Shredding JSON data into a relational structure

Archives

  • November 2024
  • 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

  • SSDT Warning SQL72038: The object already exists in database with a different definition and will not be altered.
  • JSONTABLE – Shredding JSON data into a relational structure
  • Where is the standby file?

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