Answered by:
the error is still existing to create a dabase partitiontest in excersise of exam book 70-432 sql2008 after MR.Nag Pal gave me an answer

Question
-
hello,
first I asked a question about error in my excersise
<script type="text/javascript">// <![CDATA[ function doWebSearch() { var searchBoxElement = document.getElementById('MastHeadSearchTextBox'); var url = 'http://search.microsoft.com/results.aspx?q='; if (!searchBoxElement || !searchBoxElement.value || searchBoxElement.value.length < 1) { return; } if (searchBoxElement.value.toLowerCase() != 'search microsoft with bing') { TrackEvent('WebSearch', url + searchBoxElement.value, 'CommunityPlatform','Microsoft','en-US',''); window.location = url + searchBoxElement.value; } } // ]]></script>
I got answer from MR Nag Pal with this answer below-
Use This below Syntax
-
USE master GO CREATE DATABASE partitiontest ON PRIMARY (NAME=primary_data, FILENAME='C:\test\db.mdf',SIZE=2MB), FILEGROUP FG1 (NAME=FG1_data, FILENAME='C:\test\FG1.ndf',SIZE=2MB), FILEGROUP FG2 (NAME=FG2_data, FILENAME='C:\test\FG2.ndf',SIZE=2MB), FILEGROUP FG3 (NAME=FG3_data, FILENAME='C:\test\FG3.ndf',SIZE=2MB), FILEGROUP FG4 (NAME=FG4_data, FILENAME='C:\test\FG4.ndf',SIZE=2MB), FILEGROUP FG5 (NAME=FG5_data, FILENAME='C:\test\FG5.ndf',SIZE=2MB), FILEGROUP FG6 (NAME=FG6_data, FILENAME='C:\test\FG6.ndf',SIZE=2MB), FILEGROUP FG7 (NAME=FG7_data, FILENAME='C:\test\FG7.ndf',SIZE=2MB), FILEGROUP FG8 (NAME=FG8_data, FILENAME='C:\test\FG8.ndf',SIZE=2MB), FILEGROUP FG9 (NAME=FG9_data, FILENAME='C:\test\FG9.ndf',SIZE=2MB), FILEGROUP FG10 (NAME=FG10_data, FILENAME='C:\test\FG10.ndf',SIZE=2MB), FILEGROUP FG11 (NAME=FG11_data, FILENAME='C:\test\FG11.ndf',SIZE=2MB), FILEGROUP FG12 (NAME=FG12_data, FILENAME='C:\test\FG12.ndf',SIZE=2MB), FILEGROUP FG13 (NAME=FG13_data, FILENAME='C:\test\FG13.ndf',SIZE=2MB) LOG ON (NAME=db_log, FILENAME='C:\test\log_ldf' ,SIZE=2MB, FILEGROWTH=10%); GO
It may fail withError : Msg 1803, Level 16, State 1, Line 1
The CREATE DATABASE statement failed. The primary file must be at least 50 MB to accommodate a copy of the model database.
Change the Primary File to 50MBCREATE DATABASE partitiontest
ON PRIMARY
(NAME=primary_data, FILENAME='C:\test\db.mdf',SIZE=50MB),
FILEGROUP FG1 -
I did exactly wat MR Nag Pal told me and I am still getting this error mesage
-
Msg 102, Level 15, State 1, Line 32
Incorrect syntax near 'LOG'. and he is giving me also an error with incorect syntax near NAME expecting
SELECT,or' (', when I stand on NAME.ase
-
I looked In the book and I see by LOG ON you have give the name of database wich is in this case partitiontest,I don't understand either why by lLOG ON (NAME db_log is been used in place of partitiontest. can somebody help me to solve this problem
-
thanks
-
johan
-
..
.
-
I missed it thanks jeff
Nag Pal MCTS/MCITP (SQL Server 2005/2008) :: Please Mark Answer/vote if it is helpful ::
Need Help with Forums? (FAQ)My Forum Links
Statistics
- Started: 8/13/2011
- Last Reply: 8/14/2011
- Helpful Votes: 0
- Replies: 3
- Views: 172
h.davidMonday, August 15, 2011 11:01 AM -
Answers
-
Did you remove the comma?
(NAME=FG13_data, FILENAME='C:\test\FG13.ndf',SIZE=2MB), <----------
LOG ON
Jeff Wharton
MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCITP, MCDBA
Blog: Mr. Wharty's Ramblings
MC ID: Microsoft Transcript
Please mark answered if I've answered your question and vote for it as helpful to help other user's find a solution quicker- Marked as answer by hovhannes david Wednesday, August 17, 2011 12:23 PM
Tuesday, August 16, 2011 3:43 AM
All replies
-
Did you remove the comma?
(NAME=FG13_data, FILENAME='C:\test\FG13.ndf',SIZE=2MB), <----------
LOG ON
Jeff Wharton
MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCITP, MCDBA
Blog: Mr. Wharty's Ramblings
MC ID: Microsoft Transcript
Please mark answered if I've answered your question and vote for it as helpful to help other user's find a solution quicker- Marked as answer by hovhannes david Wednesday, August 17, 2011 12:23 PM
Tuesday, August 16, 2011 3:43 AM -
hello,
Thanks very much MR Jeff Wharton
johan
h.davidWednesday, August 17, 2011 12:23 PM