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

• 

  

  0

  Sign in to vote

   

  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 with  

    Error : 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 50MB

    CREATE 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 

  •  

    
    .

    .

    .

     

  • • Reply
    • Quote

     
  • Sunday, August 14, 2011 8:57 AM

    Nag Pal

     

     675

     

     
    

    0

    Sign In to Vote

     

    I missed it thanks jeff

    ---

    Nag Pal MCTS/MCITP (SQL Server 2005/2008) :: Please Mark Answer/vote if it is helpful ::

    <input id="aed66f4e-4362-4aef-a594-7d3e98df883a_attachments" type="hidden" />
    • Reply
    • Quote

     

  Need Help with Forums? (FAQ)

  My Forum Links

  • Sign In To Forums
  • Forums Home
  • Browse Forums Users

   

  Statistics

  • Started: 8/13/2011
  • Last Reply: 8/14/2011
  • Helpful Votes: 0
  • Replies: 3
  • Views: 172

   

  © 2011 Microsoft Corporation. All rights reserved.

  Terms of Use

  |

  Trademarks

  |

  Privacy Statement

  <script type="text/javascript">// <![CDATA[ var railItems = ["/Forums/en-US/user/mylinks?forumId=deb34d70-4c37-48cc-bad0-28ab643244c3&forumName=CertGeneral","/Forums/en-US/search/RelatedThreadsByThread?threadTopic=error%20mesage%20when%20I%20am%20excersising%20to%20create%20database%20partitiontable%20in%20exam%20book%2070%2F432%20of%20sql2008&threadId=54b9a493-8402-4364-8b8e-61e9dbc604d3","/Forums/en-US/CertGeneral/thread/54b9a493-8402-4364-8b8e-61e9dbc604d3/stats"]; // ]]></script> <script type="text/javascript">// <![CDATA[ var pageData = {"validUser":false,"autoSubscribe":false}; // ]]></script> <script type="text/javascript">// <![CDATA[ var userEmailConfigured = false; // ]]></script> <script type="text/javascript">// <![CDATA[ var gDomain='m.webtrends.com'; var gDcsId = 'dcsour5e80000008ybade4ttg_1i1l'; var gTrackEvents=1; var gFpc = 'WT_FPC'; if(document.cookie.indexOf(gFpc+'=') == -1) { document.write("<script type='text/javascript' src="http://m.webtrends.com/dcsour5e80000008ybade4ttg_1i1l/wtid.js" _mce_src="http://m.webtrends.com/dcsour5e80000008ybade4ttg_1i1l/wtid.js"><\\/script>"); } // ]]></script> <noscript></noscript> <script type="text/javascript">// <![CDATA[ document.domain="microsoft.com" // ]]></script> <script type="text/javascript">// <![CDATA[ loadJavaScript('http://i3.social.s-msft.com/Forums/GlobalResources/Scripts/omni_rsid_msdn_current_wedcs2_min.js?cver=1864.923%0d%0a'); // ]]></script> <noscript></noscript>

   

  ---

  h.david

  Monday, August 15, 2011 11:01 AM