Viewing 13 posts - 1 through 13 (of 13 total)
Would someone help me out over here.. Thanks!
September 10, 2013 at 9:19 pm
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...
December 20, 2011 at 12:35 pm
The issue has been resloved thanks for your prompt help... 🙂
I really appriciate your prompt and helpful response....
December 20, 2011 at 11:01 am
Can you please help me out how I remove log_reuse_wait_desc = Replication to Active_Transcation.
Thanks in advanace for help me out ...
December 20, 2011 at 7:13 am
I just figure out the idea where I can reslove the issue.
log_reuse_wait_desc = REPLICATION
December 20, 2011 at 4:10 am
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...
December 20, 2011 at 3:43 am
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?
December 20, 2011 at 3:10 am
Thanks for you prompt reply...
Is anyway we can bind SQL Server memory which will not exceed configured value.... in 64-bit environment..
October 28, 2011 at 9:47 am
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.
October 28, 2011 at 5:49 am
Hearty congragulations for the one million banchmark......... 🙂
January 29, 2009 at 4:35 am
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...
December 21, 2008 at 10:53 pm
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
December 21, 2008 at 10:11 pm