Thank You Cath.

I t was collation issue.

Other databases has a collation "SQL_Latin1_General_CP1256_CI_AS" same as the database where i have a problem.

Server Collation is SQL_Latin1_General_CP1256_CS_AS

Same implies for the column.

I have several databases in the same server.

I have a table name "Testmenu" in another database and it perfectly works if i query...

let me make it clear.

When i query with tblPopulation - i get the results

When i query with tblpopulation - i get the error

Table exists and the schema is dbo

Yes Sure...........Have a Nice Day Ahead

Hi Gail,

I had taken backup of transaction log and reduced the size of transaction log through alter command.

Thanx.

Recovery Model is Full.

The two log files total size is 300 GB and i want to reduce this size.

The usage shown is 99% according to DBCC SQLPERF.

One interesting thing is i cannot find my login ID in sysusers table whereas it is available in syslogins.

Will this help in solving the issue.

Status is ONLINE

Part of all your replies helped me to analyse the issue.

There is an update statement running since yesterday.

Thank You to all

The above is my restore statement and it gets terminated abnormally..please help me

restore database JDE_PRODUCTION

from disk='\\baupsrv\d$\JDE_PROD\JDE_PROD_DB_FULL_BKUP'

with move

'JDE_PRODUCTION_Data' to 'C:\JDE_PRODUCTION\JDE_PRODUCTION_Data.MDF',

Move

'JDE_PRODUCTION_Data_1' to 'C:\JDE_PRODUCTION\JDE_PRODUCTION_Data_1.NDF',

Move

'JDE_PRODUCTION_Data_2' to 'C:\JDE_PRODUCTION\JDE_PRODUCTION_Data_2.NDF',

Move

'JDE_PRODUCTION_Data_3' to 'C:\JDE_PRODUCTION\JDE_PRODUCTION_Data_3.NDF',

Move

'JDE_PRODUCTION_Data_4' to 'C:\JDE_PRODUCTION\JDE_PRODUCTION_Data_4.NDF',

Move

'JDE_PRODUCTION_Data_5' to 'C:\JDE_PRODUCTION\JDE_PRODUCTION_Data_5.NDF',

Move

'JDE_PRODUCTION_Data_6' to...

The above is my restore statement and it gets terminated abnormally..please help me

restore database JDE_PRODUCTION

from disk='\\baupsrv\d$\JDE_PROD\JDE_PROD_DB_FULL_BKUP'

with move

'JDE_PRODUCTION_Data' to 'C:\JDE_PRODUCTION\JDE_PRODUCTION_Data.MDF',

Move

'JDE_PRODUCTION_Data_1' to 'C:\JDE_PRODUCTION\JDE_PRODUCTION_Data_1.NDF',

Move

'JDE_PRODUCTION_Data_2' to 'C:\JDE_PRODUCTION\JDE_PRODUCTION_Data_2.NDF',

Move

'JDE_PRODUCTION_Data_3' to 'C:\JDE_PRODUCTION\JDE_PRODUCTION_Data_3.NDF',

Move

'JDE_PRODUCTION_Data_4' to 'C:\JDE_PRODUCTION\JDE_PRODUCTION_Data_4.NDF',

Move

'JDE_PRODUCTION_Data_5' to 'C:\JDE_PRODUCTION\JDE_PRODUCTION_Data_5.NDF',

Move

'JDE_PRODUCTION_Data_6' to...

The above is my restore statement and it gets terminated abnormally..please help me

restore database JDE_PRODUCTION

from disk='\\baupsrv\d$\JDE_PROD\JDE_PROD_DB_FULL_BKUP'

with move

'JDE_PRODUCTION_Data' to 'C:\JDE_PRODUCTION\JDE_PRODUCTION_Data.MDF',

Move

'JDE_PRODUCTION_Data_1' to 'C:\JDE_PRODUCTION\JDE_PRODUCTION_Data_1.NDF',

Move

'JDE_PRODUCTION_Data_2' to 'C:\JDE_PRODUCTION\JDE_PRODUCTION_Data_2.NDF',

Move

'JDE_PRODUCTION_Data_3' to 'C:\JDE_PRODUCTION\JDE_PRODUCTION_Data_3.NDF',

Move

'JDE_PRODUCTION_Data_4' to 'C:\JDE_PRODUCTION\JDE_PRODUCTION_Data_4.NDF',

Move

'JDE_PRODUCTION_Data_5' to 'C:\JDE_PRODUCTION\JDE_PRODUCTION_Data_5.NDF',

Move

'JDE_PRODUCTION_Data_6' to...

Thank You Very Much Mr. Gail Shaw

I really got the source of concern now about this database.

I m checking my database but Can You guess something regading this database like...