Good to know that it helped you.

Suggestions:

1. Read the link suggested by Gila

2. Always remember that you should backup your transaction log regurarily which helps to manage your TLog space...

mind well..its dangerous to shift from Full to Simple if its PROD database...Read explanation on database recovery models on BOL.

Check your job what it is doing..mostly it must be inserting some data and data in some source column may be of more length than the column in table you...

Hi Ram,

As suggested in error check log_reuse_wait_desc column in the sys.databases for 'abc' database.

Your logfile growth is restricted to 46964 MB. There could be transaction running which requires size more...

Good question..simple one if basics are clear...

hey Clive...good catch..:blink::cool:

Very helpful arcticle..thanks a lot. Wish I should not come across this situation. 🙂

it looks like PartID is Identity column and is NOT NULL and PK also..

so below statement in your SP will always return some PartID depending upon where condition...and will always...

Assuming you do not have transaction log backup after 3 AM, at which you are saying you have incremental backup (it must be differential I guess)...then you can restore your...

Can you give us structure of 'Part' table?

Are below SPs are replicated

Ins_CreatePartFromDataStrings

Ins_CreatePart --- What does this SP doing?

MS Internet Explorer...however we do have other options to surf the net I still prefer IE as it is avlbl on any Windows box.

Search Engine -- Of course Google

I am just the second one from India....

Born in Nashik, Maharashtra

Brought up, Educated and Working in Mumbai (then known as Bombay)..

I think whole world is familiar about this city Mumbai....

Cheers...

Shailendra

Thanks Drikus for this gr8 doc.

very simple..but good Q for beginers

Initially thought it would be (0,1) then I was in dual mind in (0,1) and (1,1) finally I executed in Fresh Query Window in 2008 and got (1,1).

Amit,

Can you share...