Viewing 15 posts - 181 through 195 (of 196 total)
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...
November 21, 2016 at 12:06 am
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,...
November 20, 2016 at 9:08 am
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
November 20, 2016 at 5:22 am
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
November 14, 2016 at 6:20 am
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
October 6, 2016 at 5:05 am
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
October 5, 2016 at 7:17 am
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...
October 5, 2016 at 7:02 am
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...
October 5, 2016 at 6:41 am
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...
June 9, 2016 at 8:27 am
Memory_usedby_Sqlserver_MBLocked_pages_used_Sqlserver_MBTotal_VAS_in_MBprocess_physical_memory_lowprocess_virtual_memory_low
6313 0 8388607 0 0
June 9, 2016 at 5:08 am
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...
August 26, 2015 at 4:59 am
Ill test it and get back to you
K.
August 20, 2015 at 6:53 am
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...
August 20, 2015 at 6:38 am
Thanks thats actually a great idea 🙂
April 19, 2015 at 12:24 am
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...
April 18, 2015 at 11:24 pm
Viewing 15 posts - 181 through 195 (of 196 total)