70 -432 Exam Book Sylabus - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Administration

70 -432 Exam Book Sylabus

Author

Topic

Johnto
Starting Member

10 Posts

Posted - 2010-06-18 : 03:07:04

Hi if i am in wrong forum can you please redirect me or help me.

CREATE DATABASE TK432 ON PRIMARY
( NAME = N'TK432_Data', FILENAME = N'c:\test\TK432.mdf' ,
SIZE = 8mb , MAXSIZE = UNLIMITED , FILEGROWTH = 16mb ),
FILEGROUP FG1
( NAME = N'TK432_Data2', FILENAME = N'c:\test\TK432.ndf' ,
SIZE = 8mb , MAXSIZE = UNLIMITED , FILEGROWTH = 16mb ),
FILEGROUP Documents CONTAINS FILESTREAM DEFAULT
(NAME = N'Documents', FILENAME = N'c:\test\TK432Documents')
LOG ON
( NAME = N'TK432_Log', FILENAME = N'c:\test\TK432.ldf' ,
SIZE = 8mb , MAXSIZE = 2048 , FILEGROWTH = 16mb )
GO

This is Error reply
Msg 5133, Level 16, State 1, Line 1
Directory lookup for the file "c:\test\TK432.mdf" failed with the operating system error 2(failed to retrieve text for this error. Reason: 1815).
Msg 1802, Level 16, State 1, Line 1
CREATE DATABASE failed. Some file names listed could not be created. Check related errors.

I think this maybe my first of many appearances

Jay Bristol

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-06-18 : 04:52:27

Sounds like the directory C:\test doesn't exist. Check that it does.

--
Gail Shaw
SQL Server MVP

Johnto
Starting Member

10 Posts

Posted - 2010-06-18 : 04:56:12

Gail my learned mighty Yak.

I thank you for this... and also realised what i had done as soon as saw your reply.
Look out for more stupidity from me.
Many thanks

tosscrosby
Aged Yak Warrior

676 Posts

Posted - 2010-06-21 : 16:32:22

Stupidity (otherwise know as SQL challenged) we can tolerate. Laziness, we cannot.

Terry

-- A word to the wise ain't necessary - it's the stupid ones that need the advice. -- Bill Cosby

Johnto
Starting Member

10 Posts

Posted - 2010-06-22 : 08:22:15

Wonder if i can get that on T shirt ... SQL challenged

Thanks for all help

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources