Forum Replies Created

Viewing 5 posts - 1 through 5 (of 5 total)

  • RE: TSQL to check database backup status

    SELECT r.session_id AS [Session_Id]
      ,r.command AS [command]
      ,CONVERT(NUMERIC(6, 2), r.percent_complete) AS [% Complete]
      ,GETDATE() AS [Current Time]
      ,CONVERT(VARCHAR(20), DATEADD(ms, r.estimated_completion_time, GetDate()), 20) AS [Estimated Completion Time]

  • RE: SQL Server 2016 AlwaysOn and MSDTC

    JasonClark - Thursday, January 26, 2017 9:43 PM

    chewychewy - Wednesday, January 25, 2017 10:38 PM

  • RE: Log shipping VS Mirroring

    • How many destination servers do you require?

      If you require only a single destination database, database mirroring is...

  • RE: Log shipping VS Mirroring

    89netanel - Monday, January 23, 2017 10:21 AM

    Hello All,
    What is the main different between those HADR solution:
    1) Log shipping
    2) Mirroring

    Why should i choose Log...

  • RE: Upgrading from SQL Server 2008 R2 to SQL Server 2016

    The first step you have check your applications compatibility with 2016 So in this situation mirroring is best option because with this in minimum down time you check all applications...

Viewing 5 posts - 1 through 5 (of 5 total)