Everything for SAP Hana / Basis /Technology / BO / BW

SELECT  sdb.Name  AS  DatabaseName , COALESCE ( CONVERT ( VARCHAR ( 12 ),  MAX ( bus.backup_finish_date ),  101 ), '-' ) AS  LastBackUpTime FROM  sys.sysdatabases sdb LEFT  OUTER  JOIN  msdb.dbo.backupset bus  ON  bus.database_name  = sdb.name GROUP BY  sdb.Name

First install the apache with this command: (optional) apt-get install apache2 Now use locate to find if the  mod_rewrite.so  is availble on your server: updatedb locate mod_rewrite.so it will found in  “/usr/lib/apache2/modules” New apache follow some folders to enable and disable mods so now do this: cd /etc/apache2/mods-enabled touch rewrite.load vim rewrite.load  (you may use any editor to edit this file) Now paste this following line: LoadModule rewrite_module /usr/lib/apache2/modules/mod_rewrite.so Then edit: /etc/apache2/sites-available/default Find the following: Options Indexes FollowSymLinks MultiViews AllowOverride  None Order allow,deny allow from all and change it to Options Indexes FollowSymLinks MultiViews AllowOverride  all Order allow,deny allow from all and finally restart Apache: /etc/init.d/apache2 restart OK, you done