Thank you everyone for your input, turns out there was another transaction log backup being done... guess as they say, to many hands in the cookie jar?

after i turned that...

Hey Richard,

thanks for the info, i will make sure transaction log backups are disabled on primary, i dont think there is any on the secondary, but i will double check......

Hello Everyone,

hope this error message helps to narrow down what might be wrong, sadly it doesnt help me, i am not sure what to do 🙁

Message

2016-12-27 13:00:02.10*** Error: The log...

ahh yes big thank you 🙂

Thanks Gila for the reply back, just wondering, why would we ignore any page count under 1000? again this for the info.

thanks JustMarie for your input, what and how do i create the configuration file so i can tell it the says FALSE for the "Run64Bit" thing? again its got to...

Hey Spiff, thanks for helping 🙂

Yes this is an actual local drive, its not a mapped drive or anything. The only thing that frustrates me more than anything about my...

hmm, so I think i am catching what you are throwing, I can loop all the ID's, then later add the descriptions to it, after the explode part... will removing...

You are correct SQLGuru, sorry a little background, this is a Exploded BOM Tsql statment that i loop through, finding on the parent child etc. for all parts related to...

Hello,

sorry but here is an update, so i am inserting 1014193 rows, and it made a 175gig temp db data files grow, i am trying to figure out if there...

Thanks for the reply Eric,

we ran into an issue were the store procedure that gets used a lot, was causing the SQL server to peak performance, only after our sr...

Got ya thank you Luis and sorry for the late reply,

so here is another question then, not sure if I should open another forum, but its related to the same,...

Cool thanks Manual, that almost has it, except for the Last parent, parent 3, the parent shows up after the child, so its:

Child 3, 1

Parent 3, 3

need it

Parent 3,...

sorry luis and everyone, here it is below:

create table #InformationStuff

(

ID int,

ParentID int,

DescriptionInfo varchar(200)

)

insert into #InformationStuff(ID,ParentID,DescriptionInfo)

values(1,null,Parent1)

insert into #InformationStuff(ID,ParentID,DescriptionInfo)

values(2,null,Parent2)

insert into...

Jason, thank you, and no prob, any help or assistance would be great, no matter how long it takes, if anything, you and everyone on this forum have been a...