SQL Server数据库创建中的疑问 [英] Doubts in SQL Server Database Creation

问题描述

当我创建数据库时，它存储在默认位置"C:\ Program Files \ Microsoft SQL Server \ MSSQL.1 \ MSSQL> DATA>数据库名称"


我想在自己想要的路径中创建数据库....

[edit]虚假粗体已删除-OriginalGriff [/edit]

When i create a database, it stored in default location"C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL>DATA>database name"


I want to create my database in my own desired path....

[edit]Spurious bold removed - OriginalGriff[/edit]

推荐答案

您可以使用

Hi ,
You can use

USE master
GO
CREATE DATABASE Pay
ON
( NAME = Pay_dat,
   FILENAME = 'D:\docs\paydat.mdf',
   SIZE = 20MB,
   MAXSIZE = 70MB,
   FILEGROWTH = 5MB )
LOG ON
( NAME = 'Pay_log',
   FILENAME = 'D:\docs\pay.ldf',
   SIZE = 10MB,
   MAXSIZE = 40MB,
   FILEGROWTH = 5MB )
GO

http://msdn.microsoft.com/en-us/library/ms176061.aspx [ ^ ]
最好的问候
M.Miwalli

http://msdn.microsoft.com/en-us/library/ms176061.aspx[^]
Best regards
M.Miwalli

1)运行SQL Server Management Studio，然后正常登录.
2)在对象资源管理器"窗格中右键单击SqlServer实例，然后选择属性"
3)在出现的对话框中，选择数据库设置"页面.
4)数据"和日志"位置在底部附近.

1) Run SQL Server Management Studio, and log in as normal.
2) Right click your SqlServer instance in the Object Explorer pane, and select "Properties"
3) In the resulting dialog, select the "DataBase Settings" page.
4) The "Data" and "Log" locations are near the bottom.

这篇关于SQL Server数据库创建中的疑问的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！