use master go if exists(select * from sysdatabases where name='TEST_DB') drop database TEST_DB go create database TEST_Db on primary ( name='TEST_DB_data', filename='C:\DB\TestDB\TEST_DB_data.mdf', size=10MB, filegrowth=5MB ) log on ( name='TEST_DB_log', filename='C:\DB\TestDB\TEST_DB_log.ldf', size=5MB, filegrowth=2MB ) go