Interesting question, thank you Andy.

Developer need to check...

Thanks for interesting question Andy.

Yes it is fine.

I usually do not change the model database size and preafer to keep it as default size. I never encounter any issue keeping model size as default.

You have to declare missing variables

Missed today as I went back to my old days SQL 2000 🙂

What would be the error message in SQL 2000? If error message is same points should be...

It is normal during the reindex your log grow hence your database size grow and depending on the database design and activities on the database.

If you do not want...

Did you get a chance to find out any error in SQL OR WINDOW log?

pmadhavapeddi22 (6/17/2014)

I have tried taking the backup with the following t-sql commands

case I

-----------------------------------------------------

backup database XTEST_DB to disk

='c:\XTEST_DB.bak' with compression

backup database XTEST_DB to disk

='c:\XTEST_DB.bak'

-----------------------------------------------------

Both the backups are successful. first backup is...

Thanks Gail,

Agreed; it do not have to do anything with respect to checkpoints.

Maintenance plan may avoid such duplicate entry.

Extract from BOL for (Drop Table):

Large tables and indexes that use more than 128 extents are dropped in two separate phases: logical and physical. In the logical phase, the existing...

On a safer side you can create similar virtual envoronment and perform the task before touching live environment.

You can generate script of the existing replication and execute it on your test environment. If required you can change the database name.