Hello Rudy,

Sorry, DBCC in both the situations is running on the user database 'PRD'.

Try the shrinkfile with TRUNCATEONLY argument:

DBCC SHRINKFILE('DATAFILE', TRUNCATEONLY).

Try the DBCC SHRINKFILE without the argument during off business hours as it can result in lot of data\pages movement.

DBCC SHRINKFILE('DATAFILE')

I have checked the T-SQL of the Check Database Integrity task and it doesn't have the "with PHYSICAL_ONLY". This is the T-SQL of the task:

USE [PRD]

GO

DBCC CHECKDB WITH NO_INFOMSGS

GO

Hi All,

          Thank you for all your advice.

I have implemented replication.

Ravi

Thanks Greg!

Ravi

Thanks Sreejith.

                I kind of had a similiar thought of having a datetime stamp column, but having an indicator in all the tables to identify the changes would be...

When you rerun the SQL Setup, you can choose whether to use a default or another named instance.

Thanks Ken!

Hi,

      Me too.

             I would need the output to a text file. The end user wants to see a neatly formatted output.

Regards

Ravi

Hi Kenneth,

                   I have updated my initial post with the missing info. Please advice.

Thanks

Ravi

Hi Karl,

        I have the log restore job disabled, so i think i can rule that out.

And also this setup is on my test(Lab) machine, so, i am the...