on 01-24-2014 1:10 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
Where you initiated the backup?
Inside SAP, SQL management studio...?
best regards
Joao Vagarinho
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.