IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'ecdbsub') BEGIN BACKUP DATABASE [ecdbsub] TO DISK = N'D:\fes\ecsql\backup\instsqlbackup_sub.bak' WITH INIT , NOUNLOAD , NAME = N'ecdbsub バックアップ', NOSKIP , STATS = 10, NOFORMAT DROP DATABASE [ecdbsub] END IF NOT EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'ecdbsub') CREATE DATABASE [ecdbsub] ON (NAME = N'ecdbsub_Data', FILENAME = N'D:\fes\ecsql\data\ecdbsub_Data.MDF' , SIZE = 100, FILEGROWTH = 10%) LOG ON (NAME = N'ecdbsub_Log', FILENAME = N'D:\fes\ecsql\data\ecdbsub_Log.LDF' , SIZE = 50, FILEGROWTH = 10%) GO