Now i requested client to

1)run dbcc checkdb

2)enable torn page detection

and then take a full backup.

Is that ok

What happens if i enable torn page detection???

Will it affect performance or any other issues if it is enable in a LIVE Database??

When i run sp_helpdb 'db_name' on database which i restored i got the following message

Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=FULL, Version=611, Collation=SQL_Latin1_General_CP1_CI_AS, SQLSortOrder=52, IsAutoCreateStatistics, IsAutoUpdateStatistics

Client took the backup from a live database.

No idea about torn page detection ..how to check that???

I got backup from client only.

1)Its a full backup

2)Compatability level 80

No idea about partitioned tables and other file groups,But i think if there is some other filegroup then at...

Hi ,

I found 'sp_helpsrvrole' which gives all server roles and description(full name):D

If you are using SQL Server 2005 ,

import using wizard and there is one option "write query to specify the data transfer" use that.:)

Try giving INSTANCE_NAME\SQLEXPRESS,1433..Make sure your SQL Server service is up and running.

vote vote vote.......................:P

Select profiler and you can run new trace from there...

OR

DBCC TRACEON (trace_flag_no,-1)

Restart the service to take effect of changes

OR

You can enable trace flag using command prompt.

net stop mssqlserver

net start mssqlserver -Tflag_no

Thanks Again 😀

Thanks JWOL,

The problem now is the column datatype...

Deepak thanks for replying..

The problem is that the issue occured 3 days back and i checked the error logs and server logs but didnt find anything unusual.

My finding when...

Its a java application which fetches the data from MS ACCESS and imports to SQL server database.