Thank you everyone for your help. I made some modifcation based on your suggestions and am having much sucess.

Thanks again.

Yes, I did and I'm still seing the same thing.

Cool, I wasn't sujre if that reset to the highest Value. Thank you very much.

I still see this

Checking identity information: current identity value 'NULL', current column value '64'.

Versus...

Research these.

Try truncating the log

placing in simple recovery OR

backing up the transaction log

Yah man. I tell them how many disk per luns I need and that my stuff gets isolated. If the dont like it I tell them that I need Direct...

Thanks for replying. I am currently looking at role option. I do want to do this only to specific databases on the server. Thanks for all your help.

Kathleen,

Are you wanting ideas on how to update or sychronize a prod to dev enviornment or are you wanting to simulate/replicate the transaction volume from a prod to a DEv...

No, nothing like a rycycle bin exists. Backups and how there handled always seems to be lesson one. Good luck Brother.

Lesson learned...

Disregard, It ended up being the Locakl Temp Variable.

Sorry, I meant to say 'o'

I'm checking these suggestion out now.

Thank you all for your help!

Probably correct. Is the a transaction log file or a .mdb?

I would suggest expanding that file via alter database or through enterprise manager. Then, if its feasable, do not shrink...

So, Why would you not just restore the data? Thats what we do. I'm sure it would save you time.  

thank you.

The shipto datatype is nvarchar