xp_cmdshell 'copy \\existingfilepath\dbname.mdf \ewfilepath\dbname.mdf'

go

Correct, if you are shrinking down to smallest possible size -- not a good idea. But you can set your parameter to best-fit, so in case there is a...

oberhardt is correct.

A maintenance plan should be set up to truncate, shrink, and backup the transaction log -- nightly, if necessary.

taulpall,

Unfortunately, there "ain't no way", easily. The simplistic DTS package will convert, but I haven't seen but a handful that would -- most take advantage of activex and other...

You can use separate INI files that follow with the DTS package, or you can utilize global variables that are fed by the dtsrun command using the /A switch, or...

I have always used dbcc shrinkfile along with backup (truncate log) to get the most out of it. But if the DB is going to become a read only,...