I just checked the table

select name, log_reuse_wait_desc from sys.databases

The maintenance job ran and i still get the following:

aspnetdbLOG_BACKUP

Dolphin DBLOG_BACKUP

Dolphin_MMSLOG_BACKUP

Dolphin_Search_Service_App_AnalyticsReportingStoreDB_d5a531f8dc9343fab5f0f7fa54b74e6eLOG_BACKUP

Dolphin_Search_Service_App_CrawlStoreDB_dda8f4bab4d74df6925b88c0cc8d0bd2LOG_BACKUP

Dolphin_Search_Service_App_DB_c68ad9a984524ac1a8b88b79e3d5a986NOTHING

Dolphin_Search_Service_App_LinksStoreDB_f9a88fa42cea497190f4ebb7a1bcae22LOG_BACKUP

DOLPHIN_TEMPLOG_BACKUP

FolderPath1LOG_BACKUP

JobsReportLOG_BACKUP

masterNOTHING

modelLOG_BACKUP

msdbNOTHING

Profile DBLOG_BACKUP

QatarQualityDBLOG_BACKUP

QualityDBLOG_BACKUP

Search_Service_Application_AnalyticsReportingStoreDB_07129d8661584988a3a6905afb53b78bLOG_BACKUP

Search_Service_Application_CrawlStoreDB_1fd745340cb04fc7bae61913e3f66596LOG_BACKUP

Search_Service_Application_DB_19d4aeec110247289b6cdc8aea78d399LOG_BACKUP

Search_Service_Application_LinksStoreDB_571567afba0943e096ab209ffa051d9aLOG_BACKUP

Secure_Store_Service_DB_01a549a9-0209-4b37-a08e-cd3bb2825fecLOG_BACKUP

SharePoint_AdminContent_2c10eee8-b4d9-4ce5-8c91-5419a25b185dNOTHING

SharePoint_ConfigNOTHING

Social DBLOG_BACKUP

SPSSDBLOG_BACKUP

State Service DatabaseLOG_BACKUP

Sync DBLOG_BACKUP

tempdbNOTHING

UaequalitydataLOG_BACKUP

UAEQualityDBLOG_BACKUP

WF_History_QatarLOG_BACKUP

WF_History_UAELOG_BACKUP

WSS_ContentLOG_BACKUP

WSS_Content_871370154a914bcf82b62d4b80811a3cLOG_BACKUP

WSS_Content_FinanceLOG_BACKUP

WSS_Content_QatarNOTHING

WSS_Content_QatarBusinessSupportNOTHING

WSS_Content_QatarCorporateCommunicationsLOG_BACKUP

WSS_Content_QatarDelcomProjectsLOG_BACKUP

WSS_Content_QatarERPAndApplicationsNOTHING

WSS_Content_QatarHRALOG_BACKUP

WSS_Content_QatarITLOG_BACKUP

WSS_Content_QatarOperationsNOTHING

WSS_Content_QatarOperationsManagementLOG_BACKUP

WSS_Content_QatarProcurementsAndContractsLOG_BACKUP

WSS_Content_QOPSLOG_BACKUP

WSS_Content_QProjectsLOG_BACKUP

WSS_Content_RasLaffanLOG_BACKUP

WSS_Content_TESTNOTHING

WSS_Content_UAELOG_BACKUP

WSS_Content_UAECEOLOG_BACKUP

WSS_Content_UAECorporateCommunicationsLOG_BACKUP

WSS_Content_UAECorporateRiskAndQualityLOG_BACKUP

WSS_Content_UAEDelcomProjectsLOG_BACKUP

WSS_Content_UAEERPAndApplicationsNOTHING

WSS_Content_UAEGMLOG_BACKUP

WSS_Content_UAEHRALOG_BACKUP

WSS_Content_UAEHSEAndSLOG_BACKUP

WSS_Content_UAEInternalAuditLOG_BACKUP

WSS_Content_UAEITLOG_BACKUP

WSS_Content_UAELegalAdvisorLOG_BACKUP

WSS_Content_UAEManagingDirectorLOG_BACKUP

WSS_Content_UAEMarketingAndCommercialLOG_BACKUP

WSS_Content_UAEOperationsManagementNOTHING

WSS_Content_UAEProcurementsAndContractsNOTHING

WSS_Content_UAEStrategicAndCorpPlanningLOG_BACKUP

WSS_Content_UProjectsNOTHING

WSS_UsageApplicationNOTHING

Why isnt the value being...

Our RTO is 5 days but they are using EMC backup so the dbs have to stay in full backup mode.

The issue I have is sharepoint has enabled auditing,...

Recovery mode is full

Frequency of the TL backups is hourly between 7am and 4pm yet i am getting the size of the TL to increase

The biggest RBS folder is 700GB and the database file is 300 GB. Something is wrong with the setup. Right?

Are these sizes normal?

Kal

Dear Brahma

Where can I find the standard reports?

I'll google it also but it'll be faster from someone who's used this feature.

Thanks

Kal

Last question

When backing up TLs every say hour is it best practice to append the files into one TL file or keep them as separate files?

Kal

It's done once a day due to space limitations at work

Ill discuss it with management to run them every hour.

If I setup the backups to run every hour...

Thanks for the reply Gail

I have 3 txn logs which have reached 3 GB.

What's the recommended route?

I know shrinking isn't advisable but in scenarios like this shall I shrink...

Using resource monitor we found that from the total memory (12gb) that 91% was being used and it was locked by SQL server even though we set max memory to...

Memory_usedby_Sqlserver_MBLocked_pages_used_Sqlserver_MBTotal_VAS_in_MBprocess_physical_memory_lowprocess_virtual_memory_low

6313 0 8388607 0 0

I see so you used a derived table with two sums.

Do you mind explaining why you would use two sums?

What is the logic so i can understand for next time?

thanks...

Ill test it and get back to you

K.

Thanks for the reply everyone. The contractor requested to have db owner privs hence was the reason I asked about hiding the security folder. When I tried it with a...

Thanks thats actually a great idea 🙂

Just to clear the water

I am not referencing 2 sessions, i run a script daily and create/drop a local temporary table daily hence my original question was concerning if...