thanks,but we need script to shrink it every night in small shunks as we already have a reorg/rebuild job running every night

we want to shrink it down from it's enormous size now

i understand it will grow again

we need to look at those numbers and start to pre-grow the file

we have scheduled...

we have a PROD DB which is about 300Gig, however we are only using 50%.

Shrinking the DB will probably have some slight benefit to our backup process, but more...

the db is online no probs with the db

the tables have identity colums

from jobhistory

This is the actual error message.

- Validating (Error)

Messages

•Error 0xc0202049: Data Flow Task: Failure inserting into the read-only column "GId".

(SQL Server Import and Export Wizard)

•Error 0xc0202045: Data Flow Task:...

any update...

this was output of the file for the job that has executed successfully on saturday&sunday and failed today.

yes........

gail,i have attached the output to a text file but i dont see any error messages on the outputfile,i have attached a copy of it hear can you check it.

this is a prod server and dbcc checkdb dosent gave any errors all dbs have executed with out errors and it is failing once in two or three days in...

Iam performing the database integrity task and the update statistics task in it

this was a cluster server,when i execute the maintenanceplan ,i cant see the error log details on the history of maintenanceplan it displays nothing,neither in the error log,and in the...

iam able to perform the logbackup manually