Attach database without log file and rename database

Assuming the database was detached successfully, this t-sql code will attach a mdf file without a log file. It will also reattach the database with a new database name. USE [master] GO CREATE DATABASE [myTestDatabase] ON ( FILENAME = N'E:\Program...