IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'sjshigishodb')
BEGIN
BACKUP DATABASE [sjshigishodb] TO  DISK = N'D:\fes\sjshigishosql\backup\instsqlbackup.bak' WITH  INIT ,  NOUNLOAD ,  NAME = N'sjshigishodb バックアップ',  NOSKIP ,  STATS = 10,  NOFORMAT 
DROP DATABASE [sjshigishodb]
END

IF NOT EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'sjshigishodb')
CREATE DATABASE [sjshigishodb] ON (NAME = N'sjshigishodb_Data', FILENAME = N'D:\fes\sjshigishosql\data\sjshigishodb_Data.MDF' , SIZE = 100, FILEGROWTH = 10%) 
LOG ON (NAME = N'sjshigishodb_Log', FILENAME = N'D:\fes\sjshigishosql\data\sjshigishodb_Log.LDF' , SIZE =50, FILEGROWTH = 10%)
GO