cancel
Showing results for 
Search instead for 
Did you mean: 

Back up Status in sql server.

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (6)

Answers (6)

Former Member
0 Kudos

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.

Former Member
0 Kudos

Hello,

Where you initiated the backup?

Inside SAP, SQL management studio...?

best regards

Joao Vagarinho

Former Member
0 Kudos

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

Former Member
0 Kudos

Dear Contributors,

Thanks for the suggestions.

But Is It possible to check the Back up start time and end time. also  last successful back up is incremental or Full back up. like the information we usually got from the DB12 tcode..

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

Can you please explain this clearly.

Regards

Shathishkumar

former_member193518
Active Participant
0 Kudos

Just look at the logs for the jobs which are on the file system.

Former Member
0 Kudos

I got the solution for this.

Thanks

Shathishkumar

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Sriram2009
Active Contributor
0 Kudos

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

former_member193518
Active Participant
0 Kudos

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