Ninja's post definitely helps to u...

Yes u r absolutely rite,

I'll follow all the suggestions made by u.

Thanks a lot for ur kind support buddy...

Some extent,

This job was created long back, previously this job runs fine and only on that particular day this kind of problem i faced. so later i told the user...

hey Ninja,

I automated the job as per the user requirement which calls this SP and this job runs on 24*7 Basis.

Once again thanks for your kind support..

Hi folks,

This is the SP. am facing the problem.

USE [ABC]

GO

/****** Object: StoredProcedure [dbo].[usp_update_fruits]

******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

--select id,mygod from pqr

ALTER procedure [dbo].[usp_update_fruits]

as

begin

begin try

create table #my...

hi,

might be problem with your windows installer, and have u noticed at the time of installation u got any error regarding ur installer?.

And let me know windows installer is installed...

Hi folks,

Thanks for your replies,

For temporarily i created certain indices, so that queries are performing not bad. But, still am not satisfied with that moreover i'd like to improve the...

Adding to above post, there are more than 20 Jobs which runs on 24/7 basis and they are running absolutely fine from past 2 years.

And after restarting the services only...

Hi Sateesh,

I want to know why this happens?

Restart job is a scheduled job by windows team, and that job as well as SQL server is working fine from past two...

Hi Satish,

Thanks for your kind response..

After sometime database recovered from In Recovery mode...

Thank you one and all....

🙂

Regards,

-----------------

Sreenath....

Before services restarting, database backup happened, and there is a approx. 90gb of free space on the disk.

Is there any alternate to fix this issue. am in a critical situation...

My problem is one database gone to Inrecovery mode.

so how much time it takes to come into recovery mode its size is 100 gb above.

Yes john, i agree with u, here the post is about .mdf and .ndf sizes,

we can merge the objects into the new file group .

Hi,

This is not at all a problem, if there is a free disk space u can un-restrict the file growth of .mdf, and restrict the file growth of .ndf ....

Hi Jayanth_kurup thanks for your warm response,

Actually i didn't understood what you said, Can u please let me know the step by step process.

That should be very helpful to me..