Would someone help me out over here.. Thanks!

Add new drive in my system and create new log file on new added drive....

remove replicaiton ....

clean distributor log....

... shrink log file with empty....

.... and get it done...

The issue has been resloved thanks for your prompt help... 🙂

I really appriciate your prompt and helpful response....

Thanks,

Hello,

Can you please help me out how I remove log_reuse_wait_desc = Replication to Active_Transcation.

Thanks in advanace for help me out ...

Regards,

I just figure out the idea where I can reslove the issue.

log_reuse_wait_desc = REPLICATION

Thanks,

I have 2 TB SAN Drive and now t-log size reach this much size there is no disk space.

There are no open transaction....

I stopped replication and other source which...

SQL Server has been restarted and also issue the checkpoint... means all uncommited transaction should be go in mdf... than do you think data present in t-log file?

Thanks,

Thanks for you prompt reply...

Is anyway we can bind SQL Server memory which will not exceed configured value.... in 64-bit environment..

Regards,

No there is only single instance and I bind memory in database level I means in property -> Memroy -> Max Memory setting.

Thanks for your prompt response.

Regards,

Hearty congragulations for the one million banchmark......... 🙂

You select XML configration and in XML file create two variable startdate and EndDate

Then declare two gobel varicable in variable penel and mapping these variable to xml file variable in...

Hi Sunil,

I don't know ur business requirment, but u can help below example query:

Select U.Asso_Id, U.Prj_Id, U.Available_Bill_Hr - T.TotalHr as Hr

From (Utilization U Inner Join (Allocation Al Inner Join

(Select...

Hi Sunil,

I don't know ur business requirment, but u can help below example query:

Select U.Asso_Id, U.Prj_Id, U.Available_Bill_Hr - T.TotalHr as Hr

From (Utilization U Inner Join (Allocation Al Inner Join

(Select...