[dba-SQLServer] Copy a database using James example code

Gustav Brock Gustav at cactus.dk
Thu Mar 27 17:51:55 CDT 2008

Hi John

Always read my gems carefully!

Also, there seems to be several ways to name the data and log files. Some use a suffix of _data and _log, some only _log, and some nothing. As the file extension, .mdf or .ldf, tells it all I see no reason to use a suffix at all. However, my example base used _log.

>>> jwcolby at colbyconsulting.com 27-03-2008 19:47 >>>

Logical file 'IRGeneric_Data' is not part of database 'IRTest'. ..

More information about the dba-SQLServer mailing list