Question

用sql 在sqlserver新建数据库

CREATE DATABASE Epiphany ON ( NAME = Epiphany, FILENAME = 'E:Epiphany_data.mdf', SIZE = 5MB, MAXSIZE = 20, FILEGROWTH = 20 ) LOG ON ( NAME = Epiphany, FILENAME = 'E:\Epiphany_log.ldf', SIZE = 2MB, MAXSIZE = 10MB, FILEGROWTH = 1MB )（网上得到）
请问： 执行后，在E盘没有该数据库，该如何操作？谢谢！

Answer 1

CREATE DATABASE [Epiphany]
ON PRIMARY
( NAME = N'Epiphany', FILENAME = N'E:\Epiphany.mdf' , SIZE = 5120KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
LOG ON
( NAME = N'Epiphany_log', FILENAME = N'E:\Epiphany_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO