Thankyou very much-- Gail Shaw.. I got the point Now..

Still I have lot of confustion and lot my friends as all as we are new to database part

1)When...

__ I got this answer from Books Online

NO_LOG | TRUNCATE_ONLY

Removes the inactive part of the log without making a backup copy of it and truncates the log by discarding...

Sorry for that font size my intention is to stress that point thats it..

Thankyou verymuch for replies..

Here is the result when the run DBCC command

Database Name Log Size (MB) Log Space Used (%) Status

xxxxxxxxxxxxxx 9697.867 96.01259 ...

database_name database_size unallocated space

XXXXXXX 14399.06 MB 4652.36 MB

reserved data index_size unused

50000 KB 45568 KB 1128 KB 3304 KB

Thankyou verymuch

In the job you mentionted output file as c:\test_outputfile.txt..,and job will run successfully for the first time only ...after that job(2nd attempt) will fail with error.. file already exists ...

I...

Thankyou all

this step will call job on another server

EXEC servername.msdb.dbo.sp_jobname 'jobname'

In order to run one job from another both the servers should be linked servers .Then we can run the job from another server.

Is there any other way except running...

We have all the inforamtion about the servers in reporting server.

I have to write queries on reporting servers and I have full access to reporting server.

It worked .

Thanks Gil.

The columns in the table a ,b ,c are already using aggregate functions like max(duration) ,min(perf),avg(proc)

is that neccessary to have joining column from both the tables

check the verify option while taking the backup..