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