Forum Replies Created

Viewing 15 posts - 181 through 195 (of 196 total)

  • RE: Transaction log size up to 1.5 GB in 3 hours

    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...

  • RE: Transaction log size up to 1.5 GB in 3 hours

    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,...

  • RE: Transaction log size up to 1.5 GB in 3 hours

    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

  • RE: RBS folders are reaching 200GB

    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

  • RE: statistics to collect database growth

    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

  • RE: Transaction logs arent being truncated after backups

    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

  • RE: Transaction logs arent being truncated after backups

    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...

  • RE: Transaction logs arent being truncated after backups

    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...

  • RE: sql server still consuming memory even after setting max server setting

    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...

  • RE: sql server still consuming memory even after setting max server setting

    Memory_usedby_Sqlserver_MBLocked_pages_used_Sqlserver_MBTotal_VAS_in_MBprocess_physical_memory_lowprocess_virtual_memory_low

    6313 0 8388607 0 0

  • RE: summation of a calculated time difference field

    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...

  • RE: Hiding the security folder from contractors using SMSS

    Ill test it and get back to you

    K.

  • RE: Hiding the security folder from contractors using SMSS

    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...

  • RE: Is temporary table creation and dropping logged anywhere in SQL SERVER?

    Thanks thats actually a great idea 🙂

  • RE: Is temporary table creation and dropping logged anywhere in SQL SERVER?

    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...

Viewing 15 posts - 181 through 195 (of 196 total)