Power by


SAP Transport Request "Running" status "Hang" "Stuck"


** Myself

1)Delete this request from STMS.
STMS->
 import overview->
  select system(DEV,QAS,PRD) ->
   import monitor -> 
     select running -> delete entry

2)Check /usr/sap/trans/tmp  and find XX.LOC (Transport Lock file)
in /usr/sap/trans/tmp rename XX.LOC to XX.LOC.old 


3)Check tables TMSTLOCKR and TMSTLOCKP in SE16.
Delete record if not 0

MS SQL server Restore multiple device files

** Myself
## Query Tools
## Restore to QAS database  multiple file of B1.bak,B2,bak,B3.bak,B4.bak


RESTORE DATABASE QAS
FROM
DISK='F:\Backup\B1\B1.bak',
DISK='F:\Backup\B2\B2.bak',
DISK='F:\Backup\B3\B3.bak',
DISK='F:\Backup\B4\B4.bak'
WITH
MOVE 'PRDDATA1' TO 'E:\SAPDATA\QASDATA\QASDATA1.mdf',
MOVE 'PRDDATA2' TO 'E:\SAPDATA\QASDATA\QASDATA2.ndf',
MOVE 'PRDDATA3' TO 'G:\SAPDATA\QASDATA\QASDATA3.ndf',
MOVE 'PRDLOG1' TO 'G:\SAPDATA\QASDATA\QASLOG1.ldf'

MS SQL server Backup multiple device files


** Myself

Pros
-          Backup fasters
-          Each files small and can be separate drive letter (average db size to multiple file size)

Cons
-          Restore slow than single

Add Drive B1,B2,B3,and B4 to D:E:F:








Select & Add Drive B1,B2,B3,and B4 to Backup master DB



Loading