Sql Server 2012 如何创建数据库

1、启动Sql Server 2012

https://exp-picture.cdn.bcebos.com/ac45306817e951e16dd9bce55e3da824d9e9cfb4.jpghttps://exp-picture.cdn.bcebos.com/0fb94656d53da824bfc82861306651598440cbb4.jpg

2、启动sql server2012后 登陆数据库账户

https://exp-picture.cdn.bcebos.com/ba274f598540102a69c3da11b142a07aa110c5b4.jpg

3、登陆成功后在左侧找到数据库

https://exp-picture.cdn.bcebos.com/a13bbe10bc33ec38409afd5c295f0c14c37b3cb5.jpg

4、右键选择数据库 找到新建数据库选项

https://exp-picture.cdn.bcebos.com/0d55dc7bd2828689da67530265f97fbd4d7c37b5.jpg

5、打开 新建数据库窗口

https://exp-picture.cdn.bcebos.com/35f2224133bad341875c0584427622bc7cc52cb5.jpg

6、填入要新增的数据库名称

https://exp-picture.cdn.bcebos.com/ce26355fd5460596353510633e03c8d247fe25b5.jpg

7、并设定 数据库文件与日志文件的存放位置

https://exp-picture.cdn.bcebos.com/47bf594ec28333bfaeced1fcdbb8b43ea9db1db5.jpghttps://exp-picture.cdn.bcebos.com/92dd32f7dfb2dc196e0dbfa895def4dca13910b5.jpg

8、同样还可以 设定 选项和文件组

https://exp-picture.cdn.bcebos.com/d2987775f2c4ec99f262e0b2c3fe1e425c6b07b5.jpghttps://exp-picture.cdn.bcebos.com/9bc92713e8e5ecee1b9d5a9ccc704618deda7ab5.jpg

9、设定完成后 选择 ok就创建成功了

https://exp-picture.cdn.bcebos.com/de9bfa3b3b860221f17677e5d8bbf82065fb72b5.jpg