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