附加到SQL2012的数据库就不能再附加到低于SQL2012的数据库版本
- WBOY原創
- 2016-06-07 15:00:191085瀏覽
附加到SQL2012的数据库就不能再附加到低于SQL2012的数据库版本 昨天我只是将数据库附加到SQL2012，然后各个数据库都做了收缩事务日志的操作 兼容级别这些都没有改 再附加回SQL2005的时候就报错 在SQL2012里附加，确实是90级别，但是在SQL2005死活附加不上 备
附加到SQL2012的数据库就不能再附加到低于SQL2012的数据库版本
昨天我只是将数据库附加到SQL2012，然后各个数据库都做了收缩事务日志的操作
兼容级别这些都没有改
再附加回SQL2005的时候就报错
在SQL2012里附加，确实是90级别，但是在SQL2005死活附加不上
备份数据库再还原也是一样
重建事务日志也是一样
然后我做了一个实验，检查一下附加到SQL2012的数据库和附加到SQL2005的数据库，两个数据库的文件头有什么不同
注意：两个数据库的兼容级别都是90，附加到SQL2012之后我也没有动过兼容级别！！
我们用同一个数据库，分别附加到SQL2005上和SQL2012上，看一下附加之后数据库的文件头有没有改变
这个数据库的兼容级别是90的
附加到SQL2012之后，我也不改变他的兼容级别
查看文件头的SQL语句如下，实际上就是数据库的第0页：
<span>1</span> <span>DBCC</span> TRACEON(<span>3604</span>,<span>-</span><span>1</span><span>) </span><span>2</span> <span>DBCC</span> PAGE(dlgpos,<span>1</span>,<span>0</span>,<span>3</span>)
在SQL2012里和SQL2005里都执行一下
将结果复制粘贴到一个新建的记事本里，命名好
SQL2005文件头
<span> 1</span> <span>DBCC</span> 执行完毕。如果 <span>DBCC</span><span> 输出了错误信息，请与系统管理员联系。 </span><span> 2</span> <span> 3</span> PAGE: (<span>1</span>:<span>0</span><span>) </span><span> 4</span> <span> 5</span> <span> 6</span> <span>BUFFER: </span><span> 7</span> <span> 8</span> <span> 9</span> BUF <span>@0x035D7380</span> <span>10</span> <span>11</span> bpage <span>=</span> <span>0x05BC0000</span> bhash <span>=</span> <span>0x00000000</span> bpageno <span>=</span> (<span>1</span>:<span>0</span><span>) </span><span>12</span> bdbid <span>=</span> <span>5</span> breferences <span>=</span> <span>0</span> bUse1 <span>=</span> <span>8142</span> <span>13</span> bstat <span>=</span> <span>0xc00009</span> blog <span>=</span> <span>0x59ca2159</span> bnext <span>=</span> <span>0x00000000</span> <span>14</span> <span>15</span> <span>PAGE HEADER: </span><span>16</span> <span>17</span> <span>18</span> Page <span>@0x05BC0000</span> <span>19</span> <span>20</span> m_pageId <span>=</span> (<span>1</span>:<span>0</span>) m_headerVersion <span>=</span> <span>1</span> m_type <span>=</span> <span>15</span> <span>21</span> m_typeFlagBits <span>=</span> <span>0x0</span> m_level <span>=</span> <span>0</span> m_flagBits <span>=</span> <span>0x208</span> <span>22</span> m_objId (AllocUnitId.idObj) <span>=</span> <span>99</span> m_indexId (AllocUnitId.idInd) <span>=</span> <span>0</span> Metadata: AllocUnitId <span>=</span> <span>6488064</span> <span>23</span> Metadata: PartitionId <span>=</span> <span>0</span> Metadata: IndexId <span>=</span> <span>0</span> Metadata: ObjectId <span>=</span> <span>99</span> <span>24</span> m_prevPage <span>=</span> (<span>0</span>:<span>0</span>) m_nextPage <span>=</span> (<span>0</span>:<span>0</span>) pminlen <span>=</span> <span>0</span> <span>25</span> m_slotCnt <span>=</span> <span>1</span> m_freeCnt <span>=</span> <span>7636</span> m_freeData <span>=</span> <span>2844</span> <span>26</span> m_reservedCnt <span>=</span> <span>0</span> m_lsn <span>=</span> (<span>132</span>:<span>328</span>:<span>1</span>) m_xactReserved <span>=</span> <span>0</span> <span>27</span> m_xdesId <span>=</span> (<span>0</span>:<span>0</span>) m_ghostRecCnt <span>=</span> <span>0</span> m_tornBits <span>=</span> <span>1431739479</span> <span>28</span> <span>29</span> <span>Allocation Status </span><span>30</span> <span>31</span> GAM (<span>1</span>:<span>2</span>) <span>=</span> ALLOCATED SGAM (<span>1</span>:<span>3</span>) <span>=</span> <span>NOT</span> ALLOCATED PFS (<span>1</span>:<span>1</span>) <span>=</span> <span>0x44</span><span> ALLOCATED 100_PCT_FULL </span><span>32</span> DIFF (<span>1</span>:<span>6</span>) <span>=</span> CHANGED ML (<span>1</span>:<span>7</span>) <span>=</span> <span>NOT</span><span> MIN_LOGGED </span><span>33</span> <span>34</span> <span>File</span><span> Header Data: </span><span>35</span> <span>36</span> Record Type <span>=</span> PRIMARY_RECORD Record Attributes <span>=</span><span> NULL_BITMAP VARIABLE_COLUMNS </span><span>37</span> <span>38</span> Memory <span>Dump</span> <span>@0x5D95C952</span> <span>39</span> <span>40</span> <span>00000000</span>: <span>30000800</span> <span>00000000</span> 2d000000 <span>00000000</span> ?<span>0</span>.......<span>-</span><span>....... </span><span>41</span> <span>00000010</span>: 2c007a00 7a007c00 7e008200 86008a00 ?,.z.z.<span>|</span>.<span>~</span><span>....... </span><span>42</span> <span>00000020</span><span>: 8e009800 a200ac00 ac00b000 b400b800 ?................ </span><span>43</span> <span>00000030</span><span>: bc00c600 e200ec00 f6000001 10011a01 ?................ </span><span>44</span> <span>00000040</span>: 2a012e01 <span>38013801</span> <span>44015401</span> <span>54015401</span> ?<span>*</span>...<span>8.8</span><span>.D.T.T.T. </span><span>45</span> <span>00000050</span>: <span>54015401</span> <span>54015401</span> <span>64016401</span><span> 64016e01 ?T.T.T.T.d.d.d.n. </span><span>46</span> <span>00000060</span>: <span>78019401</span><span> 9e01ae01 ca019eb2 1d7874c9 ?x............xt. </span><span>47</span> <span>00000070</span>: 5d4d85b9 d1422e77 c1620100 <span>01008002</span><span> ?]M...B.w.b...... </span><span>48</span> <span>00000080</span>: 0000ffff ffff8000 <span>00000000</span> <span>00000000</span><span> ?................ </span><span>49</span> <span>00000090</span>: <span>00000000</span> <span>00000000</span> <span>00000000</span> <span>00000000</span><span> ?................ </span><span>50</span> 000000A0: <span>00000000</span> <span>00000000</span> <span>00000000</span> <span>80010000</span><span> ?................ </span><span>51</span> 000000B0: <span>00000000</span> ffffffff <span>00020000</span> 7e000000 ?............<span>~</span><span>... </span><span>52</span> 000000C0: c6000000 01007e00 0000c600 <span>00000100</span> ?......<span>~</span><span>......... </span><span>53</span> <span>000000D0: 0000355a f94bc493 9149ac29 044140d0 ?..5Z.K...I.).A@. </span><span>54</span> 000000E0: 3b1f7e00 0000b100 <span>00002500</span> <span>00000000</span> ?;.<span>~</span>.......<span>%</span><span>..... </span><span>55</span> 000000F0: <span>00000000</span> <span>00008400</span> <span>00003601</span> <span>00002500</span> ?..........<span>6</span>...<span>%</span><span>. </span><span>56</span> <span>00000100</span>: 0567c9fb b5520346 853c86ad b3f47661 ?.g...R.F.<span><span>....va </span><span>57</span> <span>00000110</span>: <span>00000000</span> <span>00000000</span><span> 0000018e a4cb618f ?..............a. </span><span>58</span> <span>00000120</span>: 414c90c3 68f1a4fd 0d810800 00007e00 ?AL..h.........<span>~</span><span>. </span><span>59</span> <span>00000130</span>: 0000c600 <span>00000100</span> 44004c00 <span>47005000</span><span> ?........D.L.G.P. </span><span>60</span> <span>00000140</span>: 4f005300 cf6c06e9 4b9b3649 a11c2b70 ?O.S..l..K.6I..<span>+</span><span>p </span><span>61</span> <span>00000150</span><span>: dbebb977 355af94b c4939149 ac290441 ?...w5Z.K...I.).A </span><span>62</span> <span>00000160</span>: 40d03b1f <span>00000000</span> <span>00000000</span> <span>00000000</span><span> ?@.;............. </span><span>63</span> <span>00000170</span>: <span>00000000</span> <span>00000000</span> <span>00000000</span> <span>00000000</span><span> ?................ </span><span>64</span> <span>00000180</span>: <span>00000000</span> <span>00000000</span> <span>00000000</span> <span>00000000</span><span> ?................ </span><span>65</span> <span>00000190</span>: <span>00000000</span> 7e000000 b1000000 <span>25003804</span> ?....<span>~</span>.......<span>%</span>.<span>8</span><span>. </span><span>66</span> <span>000001A0: 48829a28 104c95f3 4b9d6a91 ab480000 ?H..(.L..K.j..H.. </span><span>67</span> 000001B0: <span>00000000</span> <span>00000000</span> <span>00000000</span> <span>00000000</span><span> ?................ </span><span>68</span> 000001C0: <span>00000000</span> <span>00000000</span> <span>0000</span><span>???????????????.......... </span><span>69</span> BindingID <span>=</span> 781db29e<span>-</span>c974<span>-</span>4d5d<span>-</span>85b9<span>-</span>d1422e77c162 FileGroupId <span>=</span> <span>1</span> <span>70</span> FileIdProp <span>=</span> <span>1</span> Size <span>=</span> <span>640</span> MaxSize <span>=</span> <span>65535</span> <span>71</span> Growth <span>=</span> <span>128</span> Perf <span>=</span> <span>0</span> BackupLsn <span>=</span> (<span>0</span>:<span>0</span>:<span>0</span><span>) </span><span>72</span> MaxLsn <span>=</span> (<span>126</span>:<span>198</span>:<span>1</span>) FirstLsn <span>=</span> (<span>126</span>:<span>177</span>:<span>37</span>) OldestRestoredLsn <span>=</span> (<span>0</span>:<span>0</span>:<span>0</span><span>) </span><span>73</span> FirstUpdateLsn <span>=</span> (<span>0</span>:<span>0</span>:<span>0</span>) FirstNonloggedUpdateLsn <span>=</span> <span>[</span><span>NULL</span><span>]</span> CreateLsn <span>=</span> (<span>0</span>:<span>0</span>:<span>0</span><span>) </span><span>74</span> DifferentialBaseLsn <span>=</span> (<span>132</span>:<span>310</span>:<span>37</span>) DifferentialBaseGuid <span>=</span> fbc96705<span>-</span>52b5<span>-</span><span>4603</span><span>-</span>853c<span>-</span><span>86adb3f47661 </span><span>75</span> MinSize <span>=</span> <span>384</span> Status <span>=</span> <span>0</span> UserShrinkSize <span>=</span> <span>65535</span> <span>76</span> <span>77</span> <span>78</span> <span>DBCC</span> 执行完毕。如果 <span>DBCC</span> 输出了错误信息，请与系统管理员联系。</span>
SQL2012文件头
<span> 1</span> <span>DBCC</span> 执行完毕。如果 <span>DBCC</span><span> 输出了错误信息，请与系统管理员联系。 </span><span> 2</span> <span> 3</span> PAGE: (<span>1</span>:<span>0</span><span>) </span><span> 4</span> <span> 5</span> <span> 6</span> <span>BUFFER: </span><span> 7</span> <span> 8</span> <span> 9</span> BUF <span>@0x0456ACA8</span> <span>10</span> <span>11</span> bpage <span>=</span> <span>0x187CA000</span> bhash <span>=</span> <span>0x00000000</span> bpageno <span>=</span> (<span>1</span>:<span>0</span><span>) </span><span>12</span> bdbid <span>=</span> <span>9</span> breferences <span>=</span> <span>0</span> bcputicks <span>=</span> <span>0</span> <span>13</span> bsampleCount <span>=</span> <span>0</span> bUse1 <span>=</span> <span>8145</span> bstat <span>=</span> <span>0x9</span> <span>14</span> blog <span>=</span> <span>0x21215a7a</span> bnext <span>=</span> <span>0x00000000</span> <span>15</span> <span>16</span> <span>PAGE HEADER: </span><span>17</span> <span>18</span> <span>19</span> Page <span>@0x187CA000</span> <span>20</span> <span>21</span> m_pageId <span>=</span> (<span>1</span>:<span>0</span>) m_headerVersion <span>=</span> <span>1</span> m_type <span>=</span> <span>15</span> <span>22</span> m_typeFlagBits <span>=</span> <span>0x0</span> m_level <span>=</span> <span>0</span> m_flagBits <span>=</span> <span>0x208</span> <span>23</span> m_objId (AllocUnitId.idObj) <span>=</span> <span>99</span> m_indexId (AllocUnitId.idInd) <span>=</span> <span>0</span> Metadata: AllocUnitId <span>=</span> <span>6488064</span> <span>24</span> Metadata: PartitionId <span>=</span> <span>0</span> Metadata: IndexId <span>=</span> <span>0</span> Metadata: ObjectId <span>=</span> <span>99</span> <span>25</span> m_prevPage <span>=</span> (<span>0</span>:<span>0</span>) m_nextPage <span>=</span> (<span>0</span>:<span>0</span>) pminlen <span>=</span> <span>0</span> <span>26</span> m_slotCnt <span>=</span> <span>1</span> m_freeCnt <span>=</span> <span>7636</span> m_freeData <span>=</span> <span>3302</span> <span>27</span> m_reservedCnt <span>=</span> <span>0</span> m_lsn <span>=</span> (<span>141</span>:<span>733</span>:<span>159</span>) m_xactReserved <span>=</span> <span>0</span> <span>28</span> m_xdesId <span>=</span> (<span>0</span>:<span>0</span>) m_ghostRecCnt <span>=</span> <span>0</span> m_tornBits <span>=</span> <span>426768658</span> <span>29</span> DB Frag ID <span>=</span> <span>1</span> <span>30</span> <span>31</span> <span>Allocation Status </span><span>32</span> <span>33</span> GAM (<span>1</span>:<span>2</span>) <span>=</span> ALLOCATED SGAM (<span>1</span>:<span>3</span>) <span>=</span> <span>NOT</span> ALLOCATED PFS (<span>1</span>:<span>1</span>) <span>=</span> <span>0x44</span><span> ALLOCATED 100_PCT_FULL </span><span>34</span> DIFF (<span>1</span>:<span>6</span>) <span>=</span> CHANGED ML (<span>1</span>:<span>7</span>) <span>=</span> <span>NOT</span><span> MIN_LOGGED </span><span>35</span> <span>36</span> <span>File</span><span> Header Data: </span><span>37</span> <span>38</span> Record Type <span>=</span> PRIMARY_RECORD Record Attributes <span>=</span><span> NULL_BITMAP VARIABLE_COLUMNS </span><span>39</span> Record Size <span>=</span> <span>458</span> <span>40</span> Memory <span>Dump</span> <span>@0x1019CB1C</span> <span>41</span> <span>42</span> <span>00000000</span>: <span>30000800</span> <span>00000000</span> 2d000000 <span>00000000</span> 2c007a00 <span>0</span>.......<span>-</span><span>.......,.z. </span><span>43</span> <span>00000014</span>: 7a007c00 7e008200 86008a00 8e009800 a200ac00 z.<span>|</span>.<span>~</span><span>............... </span><span>44</span> <span>00000028</span><span>: ac00b000 b400b800 bc00c600 e200ec00 f6000001 .................... </span><span>45</span> 0000003C: 10011a01 2a012e01 <span>38013801</span> <span>44015401</span> <span>54015401</span> ....<span>*</span>...<span>8.8</span><span>.D.T.T.T. </span><span>46</span> <span>00000050</span>: <span>54015401</span> <span>54015401</span> <span>64016401</span> 64016e01 <span>78019401</span><span> T.T.T.T.d.d.d.n.x... </span><span>47</span> <span>00000064</span><span>: 9e01ae01 ca019eb2 1d7874c9 5d4d85b9 d1422e77 .........xt.]M...B.w </span><span>48</span> <span>00000078</span>: c1620100 <span>01000003</span> 0000ffff ffff8000 <span>00000000</span><span> .b.................. </span><span>49</span> 0000008C: <span>00000000</span> <span>00000000</span> <span>00000000</span> <span>00000000</span> <span>00000000</span><span> .................... </span><span>50</span> 000000A0: <span>00000000</span> <span>00000000</span> <span>00000000</span> <span>80010000</span> <span>00000000</span><span> .................... </span><span>51</span> 000000B4: ffffffff <span>00020000</span> 7e000000 c6000000 01007e00 ........<span>~</span>.........<span>~</span><span>. </span><span>52</span> 000000C8: 0000c600 <span>00000100</span><span> 0000355a f94bc493 9149ac29 ..........5Z.K...I.) </span><span>53</span> 000000DC: 044140d0 3b1f7e00 0000b100 <span>00002500</span> <span>00000000</span> .A@.;.<span>~</span>.......<span>%</span><span>..... </span><span>54</span> 000000F0: <span>00000000</span> <span>00008400</span> <span>00003601</span> <span>00002500</span> 0567c9fb ..........<span>6</span>...<span>%</span><span>..g.. </span><span>55</span> <span>00000104</span>: b5520346 853c86ad b3f47661 <span>00000000</span> <span>00000000</span> .R.F.<span><span>....va........ </span><span>56</span> <span>00000118</span><span>: 0000018e a4cb618f 414c90c3 68f1a4fd 0d810800 ......a.AL..h....... </span><span>57</span> 0000012C: 00007e00 0000c600 <span>00000100</span> 44004c00 <span>47005000</span> ..<span>~</span><span>.........D.L.G.P. </span><span>58</span> <span>00000140</span>: 4f005300 cf6c06e9 4b9b3649 a11c2b70 dbebb977 O.S..l..K.6I..<span>+</span><span>p...w </span><span>59</span> <span>00000154</span>: 355af94b c4939149 ac290441 40d03b1f <span>00000000</span><span> 5Z.K...I.).A@.;..... </span><span>60</span> <span>00000168</span>: <span>00000000</span> <span>00000000</span> <span>00000000</span> <span>00000000</span> <span>00000000</span><span> .................... </span><span>61</span> 0000017C: <span>00000000</span> <span>00000000</span> <span>00000000</span> <span>00000000</span> <span>00000000</span><span> .................... </span><span>62</span> <span>00000190</span>: <span>00000000</span> 7e000000 b1000000 <span>25003804</span> 48829a28 ....<span>~</span>.......<span>%</span>.<span>8</span><span>.H..( </span><span>63</span> 000001A4: 104c95f3 4b9d6a91 ab480000 <span>00000000</span> <span>00000000</span><span> .L..K.j..H.......... </span><span>64</span> 000001B8: <span>00000000</span> <span>00000000</span> <span>00000000</span> <span>00000000</span> <span>0000</span><span> .................. </span><span>65</span> BindingID <span>=</span> 781db29e<span>-</span>c974<span>-</span>4d5d<span>-</span>85b9<span>-</span>d1422e77c162 FileIdProp <span>=</span> <span>1</span> <span>66</span> FileGroupId <span>=</span> <span>1</span> Size <span>=</span> <span>768</span> MaxSize <span>=</span> <span>65535</span> <span>67</span> Growth <span>=</span> <span>128</span> Perf <span>=</span> <span>0</span> BackupLsn <span>=</span> (<span>0</span>:<span>0</span>:<span>0</span><span>) </span><span>68</span> FirstUpdateLsn <span>=</span> (<span>0</span>:<span>0</span>:<span>0</span>) OldestRestoredLsn <span>=</span> (<span>0</span>:<span>0</span>:<span>0</span>) FirstNonloggedUpdateLsn <span>=</span> <span>[</span><span>NULL</span><span>]</span> <span>69</span> MinSize <span>=</span> <span>384</span> Status <span>=</span> <span>0</span> UserShrinkSize <span>=</span> <span>65535</span> <span>70</span> SectorSize <span>=</span> <span>512</span> MaxLsn <span>=</span> (<span>126</span>:<span>198</span>:<span>1</span>) FirstLsn <span>=</span> (<span>126</span>:<span>177</span>:<span>37</span><span>) </span><span>71</span> CreateLsn <span>=</span> (<span>0</span>:<span>0</span>:<span>0</span>) DifferentialBaseLsn <span>=</span> (<span>132</span>:<span>310</span>:<span>37</span><span>) </span><span>72</span> DifferentialBaseGuid <span>=</span> fbc96705<span>-</span>52b5<span>-</span><span>4603</span><span>-</span>853c<span>-</span>86adb3f47661 FileOfflineLsn <span>=</span> (<span>0</span>:<span>0</span>:<span>0</span><span>) </span><span>73</span> FileIdGuid <span>=</span> cba48e01<span>-</span>8f61<span>-</span>4c41<span>-</span>90c3<span>-</span>68f1a4fd0d81 RestoreStatus <span>=</span> <span>8</span> <span>74</span> RestoreRedoStartLsn <span>=</span> (<span>126</span>:<span>198</span>:<span>1</span>) RestoreSourceGuid <span>=</span> e9066ccf<span>-</span>9b4b<span>-</span><span>4936</span><span>-</span>a11c<span>-</span><span>2b70dbebb977 </span><span>75</span> HardenedSkipLsn <span>=</span> <span>[</span><span>NULL</span><span>]</span> ReplTxfTruncationLsn <span>=</span> <span>[</span><span>NULL</span><span>]</span> TxfBackupLsn <span>=</span> <span>[</span><span>NULL</span><span>]</span> <span>76</span> FstrContainerSize <span>=</span> <span>[</span><span>NULL</span><span>]</span> MaxLsnBranchId <span>=</span> 4bf95a35<span>-</span>93c4<span>-</span><span>4991</span><span>-</span>ac29<span>-</span><span>044140d03b1f </span><span>77</span> SecondaryRedoStartLsn <span>=</span> <span>[</span><span>NULL</span><span>]</span> SecondaryDifferentialBaseLsn <span>=</span> <span>[</span><span>NULL</span><span>]</span> <span>78</span> ReadOnlyLsn <span>=</span> (<span>0</span>:<span>0</span>:<span>0</span>) ReadWriteLsn <span>=</span> (<span>0</span>:<span>0</span>:<span>0</span><span>) </span><span>79</span> RestoreDifferentialBaseLsn <span>=</span> (<span>126</span>:<span>177</span>:<span>37</span><span>) </span><span>80</span> RestoreDifferentialBaseGuid <span>=</span> <span>82480438</span><span>-</span>289a<span>-</span>4c10<span>-</span>95f3<span>-</span><span>4b9d6a91ab48 </span><span>81</span> <span>RestorePathOrigin </span><span>82</span> <span>83</span> hex (<span>dec</span>) <span>=</span> <span>0x00000000</span>:<span>00000000</span>:<span>0000</span> (<span>0</span>:<span>0</span>:<span>0</span><span>) </span><span>84</span> m_guid <span>=</span> <span>00000000</span><span>-</span><span>0000</span><span>-</span><span>0000</span><span>-</span><span>0000</span><span>-</span><span>000000000000</span> <span>85</span> DatabaseEncryptionFileState <span>=</span> <span>[</span><span>NULL</span><span>]</span>FCBFileDEK <span>=</span> <span>[</span><span>NULL</span><span>]</span> <span>86</span> <span>87</span> <span>88</span> <span>DBCC</span> 执行完毕。如果 <span>DBCC</span> 输出了错误信息，请与系统管理员联系。</span>
可以用Beyond Compare这个软件比较一下两者的文件头的差异
Beyond Compare这个软件会把两个txt文件中的相同点用蓝色标记出来，不同点用红色标记出来
当附加到SQL2012之后，数据库的文件头已经走样了，就算你没有动过兼容级别，这也是造成曾经附加到SQL2012的数据库
再也附加不上SQL2005上的原因
可以看到SQL2012的数据库记录的信息比SQL2005详细多了，多了很多内容
也可以用下面的SQL语句看文件头的内容，不过信息比较少
<span>1</span> <span>DBCC</span> fileheader(<span>'</span><span>DLGPOS</span><span>'</span>)
总结
上面的实验证明了，当你将一个SQL2005的数据库附加到SQL2012上的时候，SQL2012马上改变数据库的文件头
就算你不动数据库兼容级别，实际上数据库的信息已经改变了（这里指文件头信息）
所以你死活附加不回去SQL2005了
以后不要轻易附加数据库到SQL2012上，不然的话。。。。。。
补充一下
http://www.cnblogs.com/lyhabc/archive/2013/01/20/2869057.html
如有不对的地方，欢迎大家拍砖o(∩_∩)o
陳述：
本文內容由網友自願投稿，版權歸原作者所有。本站不承擔相應的法律責任。如發現涉嫌抄襲或侵權的內容，請聯絡admin@php.cn