<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by vinaykumar
»
Create Database
56 posts, Page 6 of 6
««
«
2
3
4
5
6
Create Database
Rate Topic
Display Mode
Topic Options
Author
Message
valley3969
valley3969
Posted Friday, June 12, 2009 12:14 AM
SSC Rookie
Group: General Forum Members
Last Login: Friday, July 10, 2009 2:05 AM
Points: 29,
Visits: 12
得行的哈
我又自己做了哈测试的
create database test
--创建主库
on primary
(
--数据库逻辑名
name='test _lj',
--数据库路径
filename='D:\Develop_Files\Database\ test.mp3',
--数据库初始大小
size=3MB,
--数据库最大容量
Maxsize=10MB,
--增长幅度
filegrowth=1MB
)
--创建日志文件
log on
(
--数据库日志名
name=' test _log',
--数据库日志路径
filename='D:\Develop_Files\Database\ test.doc',
--日志文件初始大小
size=3MB,
--日志文件最大容量
Maxsize=10MB,
--增长幅度
filegrowth=1MB
)
Post #733532
Dugi
Dugi
Posted Friday, June 12, 2009 12:25 AM
Ten Centuries
Group: General Forum Members
Last Login: Tuesday, April 02, 2013 1:48 AM
Points: 1,252,
Visits: 3,367
wow what a chines DB creation ...and the problem is !?
============================================================
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #733535
valley3969
valley3969
Posted Sunday, June 14, 2009 11:22 PM
SSC Rookie
Group: General Forum Members
Last Login: Friday, July 10, 2009 2:05 AM
Points: 29,
Visits: 12
谢了哈，黄毛。你看来是论坛的元老级了哈，有问题问你哈，以后。
Thanks,man. It seems that you r a senior in the forum. if I have any qus. in the future, ask you OK?
Post #734795
Steve Jones - SSC Editor
Steve Jones - SSC Editor
Posted Monday, June 15, 2009 7:54 AM
SSC-Dedicated
Group: Administrators
Last Login: Today @ 11:20 AM
Points: 31,437,
Visits: 13,752
Please post questions in the appropriate forum. This forum is for author comments. Moving to 2005-admin.
If you have questions, just post in a forum, someone will see it and try to answer.
Follow me on Twitter:
@way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
Post #735019
jghali
jghali
Posted Friday, June 04, 2010 9:45 AM
SSC-Addicted
Group: General Forum Members
Last Login: Friday, November 09, 2012 12:51 AM
Points: 429,
Visits: 187
I have a question... I've changed the script to use C:\ for both files as follows:
Create Database Mytestdb
on
( name ='Mytest_1', Filename= 'C:\MyTEST.mp3', size = 2000 KB
)log on(
name ='MyTest_2', Filename= 'C:\MYTEST.doc', size= 512 kb)
and get the following error:
Msg 5123, Level 16, State 1, Line 1
CREATE FILE encountered operating system error 5(Access is denied.) while attempting to open or create the physical file 'C:\MyTEST.mp3'.
Msg 1802, Level 16, State 4, Line 1
CREATE DATABASE failed. Some file names listed could not be created. Check related errors.
I am administrator of my machine and the DB is installed locally and I'm sysadmin....
When I change the files to C:\temp\filenames... (with temp folder being existant)... it works!!!
Can someone explain if this behavior is normal?? I'm suspecting that it's some type of setting on my account...
Post #932905
Tao Klerks
Tao Klerks
Posted Friday, June 04, 2010 10:01 AM
Ten Centuries
Group: General Forum Members
Last Login: Sunday, April 14, 2013 8:55 AM
Points: 1,383,
Visits: 1,212
jghali (6/4/2010)
...
Create Database Mytestdb
on
( name ='Mytest_1', Filename= 'C:\MyTEST.mp3', size = 2000 KB
)log on(
name ='MyTest_2', Filename= 'C:\MYTEST.doc', size= 512 kb)
...
CREATE FILE encountered operating system error 5(Access is denied.) while attempting to open or create the physical file 'C:\MyTEST.mp3'.
...
Can someone explain if this behavior is normal?? I'm suspecting that it's some type of setting on my account...
The permissions required are for the account that SQL Server is running under, not your account.
To see what account that is, open the services panel (services.msc) for example, and find the MSSQL Service.
http://poorsql.com
for T-SQL formatting: free as in speech, free as in beer, free to run in SSMS or on your version control server - free however you want it.
Post #932921
« Prev Topic
|
Next Topic »
56 posts, Page 6 of 6
««
«
2
3
4
5
6
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
