I have an idea!!!!!

i would link to split the job.

I will mention only 1step in restore job--- it will do only restoration.

Then i will try to do insertion by batches...

Try to increase Virtual Memory

Thanks for posting and for your advices

I Hope it will helping me....

thanks for posting..

one more question: what exactly happen when we use With Truncate only option when we are backing up log

BACKUP LOG ... WITH TRUNCATE...

we are using this DB for monitoring Application and we are having less disk space.

So that we are planing to run every 6 hours.

When i issue DBCC Opentran() -- it...

Earlier it was Simple.... i was just changed to Full and implemented Log backup

it was around 45gb

It was happening every day .

--we are uploading CSV files to database and we are using this db for monitoring purpose.

Hi.....

Try to rebuild and reorganize the index in off peak hours.

Check min and max memory settings

Thanks for providing...

i will go through it....

Thanks alot

we have fix the issue.

we have space with column name before and after.

it was enclosing after including braces

We got permanent solution for this

Ans : Use CODEPAGE = ACP. to resolve.

Desc :

ACP

Columns of char, varchar, or text data type are converted from the ANSI/Microsoft Windows...

Thanks

i will try it

its 2003