You can use DTS to import the CSV files one by one.

Ok..Thanks Ramesh!!! I performed the activity.It has succeeded.

Hi Ramesh,

Thanks for your reply.I planning to use Data Transformation services.If i import the table in server B from Server A will the...

Yes rebuilding indexes happens every week..

The diskspace where the log file is present getting low sometimes.I'm getting alerts such as the drive has low space where the log file cannot grow upto the space specified.

The...

Yes log files is also present on the same drive.

The Auto Shrink database option is not enabled.

I need to check the last replication time.I cant insert anythg as it is a production server.How can i check whether the replication is happening or not?

Thanks a lot Gail Shaw

Oh ok now i can understand that it is CPU time not the utilization.

I checked in Taskmanager->Performance->cpu.Is that the exact cpu utilization?

[Dont mistake me for my childish questions]

A single SPID has 1714526 Cpu.Was this a normal one?

Thanks Creazyman.

But how can i check the CPU Utilization.Is that correct that i'm checking in Sysprocesses CPU column?

No..I could not find any sql error logs.

I have one more log

Event Type:Error

Event Source:MSSQLSERVER

Event Category:(3)

Event ID:17052

Date:18/12/2008

Time:00:00:24

User:N/A

Computer:A

Description:

[sqsrvres] CheckServiceAlive: Service is dead

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Thanks for ur immediate reply.

The user from database(A) differs from users of database(B).so when i restored the database i need to execute the sciript so that the users must exists as previous.And also if...

Yes,I have installed Express.So what can i do now to get agent?