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