Hi,

Point in time recovery is only supported in Full recovery model. So NO, Bulk logged recovery model does not support point in time recovery.

http://msdn.microsoft.com/en-IN/library/ms189275.aspx

Hope it helps...!!!

Dear Pradeep,

Output of DBCC Loginfo shows the number VLF's you have in your Log File (ldf), From what i can see you have WAY TOO MANY...!!

too many VLF's create substantial...

Hi,

This seems like an environment issue to me. Sql server is able to make connection but it is not able to sustain them.

Have some network guy look at your network.

Sorry...

Dear Arooj,

Check out this link.

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/2d216af4-6586-4619-b8aa-56f05cbd8239/the-request-failed-with-http-status-401-unauthorized-in-ssrs?forum=sqlreportingservices">

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/2d216af4-6586-4619-b8aa-56f05cbd8239/the-request-failed-with-http-status-401-unauthorized-in-ssrs?forum=sqlreportingservices

Hi Pradeep,

Couple of questions...

What is the size of you Database? (mdf , ldf).

Auto Growth settings for your database (mdf and ldf)

Also share the output of the DBCC Loginfo for...

Hi,

There could be a number of reason for High memory utilization. Lets start with the obvious:

Update Stats Task: You are using the default values for Update Stats Task i.e. For...

OOps-- Duplicate Answer

OOps-- Duplicate Answer

Hi,

Tsql to Disable CDC:

USE <Name of the database>

GO

EXEC sys.sp_cdc_disable_db

GO

You dont have to delete the jobs or manually disable the CDC from tables. Running the above statement would automatically remove all...

Apparently... "Good things come to those who WAIT" 😀

How did you resolve it?

Hi,

I have not worked in HAG as well, Just trying to help.

Read this article once, You will have a fair idea.

http://www.mssqltips.com/sqlservertip/2573/monitor-sql-server-alwayson-availability-groups/

Regards

Shafat Husain

Dear Arooj,

Do you have any scheduled reports running on the server? Scheduled reports takes up a lot of memory, setting up the WorkingSetMaximum,WorkingSetMinimum value in RsReportServer.config file will help setting...

Dear Jude,

The message occurs when you include ApplicationIntent=ReadOnly (AlwaysOn Availability Groups properties) in your connection string. And the server does not recognize the property.

To resolve this issue you will...

Hi,

Their could be a wide variety of issues it is not possible to share the resolution for all of them.

Let us try to narrow down our issue first.

Go to...