Errors creating database with SQL Server 2008 I&M Training Manual

20 pts.
Tags:
CREATE DATABASE statement
SQL Server 2008
SQL Server 2008 error messages
SQL Server 2008 R2
SQL Server administration
I'm going through the SQL Server 2008 I&M self-paced training manual, and when I do the exercise for creating a database, here's what happens:
CREATE DATABASE TK432 ON PRIMARY
( NAME = N'TK432_Data', FILENAME = N'c:testTK432.mdf',
SIZE = 8MB, MAXSIZE = UNLIMITED, FILEGROWTH = 16MB ),
FILEGROUP FG1
( NAME = N'TK432_Data2', FILENAME = N'c:testTK432.ndf',
SIZE = 8MB, MAXSIZE = UNLIMITED, FILEGROWTH = 16MB ),
FILEGROUP Documents CONTAINS FILESTREAM DEFAULT
( NAME = N'Documents', FILENAME = N'c:testTK432Documents' )
LOG ON
( NAME = N'TK432_Log', FILENAME = N'c:testTK432.ldf',
SIZE = 8MB, MAXSIZE = 2048GB, FILEGROWTH = 16MB )
GO

Msg 5133, Level 16, State 1, Line 1
Directory lookup for the file "c:testTK432.mdf" failed with the operating system error 2(The system cannot find the file specified.).
Msg 1802, Level 16, State 1, Line 1
CREATE DATABASE failed. Some file names listed could not be created. Check related errors.
I'm not sure what I'm doing wrong - I copied it right from the book. Thanks!

Answer Wiki

Thanks. We'll let you know when a new response is added.

You’ll need to create the folder C:\Test for this script to work.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    Have you created the 'test' directory in your C: drive root directory ? Do you have write permissions on it ?
    70,200 pointsBadges:
    report
  • Elziz
    Doh!!! I just spent ages trying to resolve this. Thank you so much
    15 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following