Thank you for giving Reply me sir,

As i am very new to this Rebuild and reorganize Tasks.

Can you Please help me how to find "What Exactly Running at that time",

Here...

Thank you All for sharing your valuable Knowledge .....

Thank u All.....

is there any Video Links for that Query Tuning...

Thank you all,

In my system SQL server was installed,

My DB Log size is 32GB now ,DB is in Full Recovery model.

Day to Day Log size is getting increasing.

If I...

Thank you all,

In my system SQL server was installed,

My DB Log size is 32GB now ,DB is in Full Recovery model.

Day to Day Log size is getting increasing.

If I...

Thank you one and All my Dears.....

Thank you so much Grant..

Now am very much clear on that.

Still i am Expecting the Replies from Other Experts...

Thanks In Adv...

Is this good to set the database recovery model to Simple,

Because if we want to recover the Data Point_In_Time ,its not possible in that Simple Recovery Model.

If suppose Daily 6AM...

Thank you all,

From your replies i came to know 2 main things to clear the Log File those are below

1> Need to take the Log Backup Frequently

2>...

Thank you Verbeeck,

Actually i want to know the reasons for that growing,

Is there any particular reasons or anything else... for that Log File Growing .

We are having enough Space...

am having the database in External Drive ,That was locked by that local system.

Now i want to restored that Locked Database from that Exte Drive to New System...

Note:Both Systems are...

:-):-):-):-):-)

If the Database is in Suspect mode then follow the below steps to recover ur DB

>Stop the SQL Service

>>Copy the MDF and LDF file and place in other safe location

>>>Then...

Hi Sir,

Can please Elaborate the above Step.

I have observed that restore job is not running and showing the following error message but when i checked that all the transaction getting...

Thnak U So Much Sir....