locked
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 RRS feed

  • 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 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 

    •  


      .

      .

      .

       

    • Sunday, August 14, 2011 8:57 AM
      Avatar of Nag Pal
       
       675
       
       

       

      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" />
    Need Help with Forums? (FAQ)
     

    Statistics

    • Started: 8/13/2011
    • Last Reply: 8/14/2011
    • Helpful Votes: 0
    • Replies: 3
    • Views: 172
    <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

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
    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
    Tuesday, August 16, 2011 3:43 AM
  • hello,

    Thanks  very much MR Jeff Wharton

    johan


    h.david
    Wednesday, August 17, 2011 12:23 PM