Skip to Content
avatar image
Former Member

Back up Status in sql server.

Dear All Contributors,

Good day!

Currently for solution manager system we are using the Sql server database.

How to check the status of  start time and end time  of the Sql server in OS level. If I do not have access to use db12 in the sap system.

Regards

Shathishkumar

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • avatar image
    Former Member
    Jan 24, 2014 at 02:11 PM

    Log onto the DB server with Remote Desktop.

    Start the Event Viewer, in the "Application Logs", look for event source MSSQLSERVER (or your instance service name), then filter for event 17137.

    Regards,

    Darryl

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 26, 2014 at 10:32 AM

    Hi Sathish

    In your "Application Log" sort the "Task Category" you can find the backup status as mention in the below screen reference

    Regards

    Ram


    Capture.JPG (17.5 kB)
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 27, 2014 at 06:55 PM

    Hi Satish Kumar

    If yuo have access to Databse Server Please login and look for MS Sqlserver management studio in windows start menu.

    select appropriate database server, if you schedule Backups as job shown below, right click on it and select "View History"

    See below screen shot to check backup time line

    If jobs are not scheduled in SQL Server and you want to check status go to "SQL Server Logs" and look for below in SQL Server logs for backup status

    Hope this helps, if you need further help feel free to post details, we will try our best to help you out.

    if this helps please mark this as "Answered" so that some one can find this helpfull.

    -G


    1.jpg (21.6 kB)
    2.jpg (22.3 kB)
    3.jpg (21.0 kB)
    4.jpg (6.7 kB)
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 28, 2014 at 05:50 AM

    If I do not have access to use db12 in the sap system.

    What is the logic behind this? Sorry, really not able to understand.

    DB12 is just a monitoring tcode, you do not have authorization. But it seems you have authorization to access your database directly using SSMS!

    *You can follow the above steps to get the details (as mentioned by other techies).

    Regards,

    Nick Loy

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      Also I am not much aware of this sentence  (But it seems you have authorization to access your database directly using SSMS!)

      Point is - You do not have access to monitor your backups, but you have access to manage your database (using SQL server management studio, SSMS)!

      Ask your controls/security team and request DB12 access which shows you all the required details from SAP screen it self.

      Regards,

      Nick Loy

  • avatar image
    Former Member
    Feb 12, 2014 at 10:20 AM

    Hello,

    Where you initiated the backup?

    Inside SAP, SQL management studio...?

    best regards

    Joao Vagarinho

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 04, 2014 at 11:07 AM

    Hello,

    You can run the following script in SQl management studio:

    SELECT      command, percent_complete,

                'elapsed' = total_elapsed_time / 60000.0,

                'remaining' = estimated_completion_time / 60000.0

    FROM        sys.dm_exec_requests

    WHERE       command like 'BACKUP%'

    Refresh the script manualy in button.

    Add comment
    10|10000 characters needed characters exceeded