locked
Sql 2005 mdf files uprage to Sql 2008 mdf files ? RRS feed

  • Question

  • User-1418772296 posted

    hi
    what is different between SQL 2008 Server and SQL 2005 Server ?
    SQL 2008 Server is more fast for searching ?
    i created my *.mdf at Sql 2005. does it work at SQL 2008 ? does it work same performance with *.mdf that created with SQL 2008 ?

    can i uprage my *.mdf for sql 2008 ?

    what should i do ?


    Thanks

    Thursday, March 5, 2009 5:54 AM

Answers

All replies

  • User1096912014 posted

    I posted this link before

    http://www.angryhacker.com/blog/archive/2008/06/20/10-reasons-why-sql-server-2008-is-going-to-rock.aspx

    You can upgrade your MDF to SQL Server 2008, but you would not be able to downgrade.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, March 5, 2009 7:00 AM
  • User-1418772296 posted

    hi

    i have read 10 reasons why 2008 more good.

    my first question is that there is something about index for more fast selecting.. can u give me a example about this issue ? what should i do related to index for SQL 2008 ?

    my second question is that how can i uprage my *.mdf files as SQL2008 *. mdf files ?

    Thanks

    Thursday, March 5, 2009 8:13 AM
  • User2011918074 posted

    Hi,

    For more information about SQL Server index, please refer to the links below:

    http://www.odetocode.com/Articles/70.aspx

    http://www.sqlteam.com/article/sql-server-indexes-the-basics

    http://www.mssqltips.com/tip.asp?tip=1206

    http://www.sql-server-performance.com/articles/per/index_data_structures_p1.aspx

    In SQL Server 2008, there is a new feature named Filtered Index, which is an optimized nonclustered index and used to index a portion of rows.

    Filtered Index Design Guidelines
    http://technet.microsoft.com/en-us/library/cc280372.aspx

    SQL SERVER - 2008 - Introduction to Filtered Index - Improve performance with Filtered Index
    http://blog.sqlauthority.com/2008/09/01/sql-server-2008-introduction-to-filtered-index-improve-performance-with-filtered-index/

    I think we can attach the database files in SQL Server 2008 SSMS directly and change the compatibility level to “SQL Server 2008 (100)”.

    1. In SSMS, right-click the database, select Properties.
    2. Go to the Options Page.
    3. In the dropdown at right labeled Compatibility Level choose "SQL Server 2008 (100)".
    4. Press OK to save.

    Database Compatibility Level Option
    http://technet.microsoft.com/en-us/library/ms191137.aspx

    ALTER DATABASE Compatibility Level (Transact-SQL)
    http://msdn.microsoft.com/en-us/library/bb510680.aspx

     

     

    This response contains the reference to the third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, March 10, 2009 2:34 AM
  • User-1418772296 posted

    hi

    my mdf files have been created SQL 2005. now i use sql 2008.. i try to uprage my mdf files  of 2005 to 2008.

    but when i open SSMS, i cant see my mdf files. my mdf files in same path with mdf files that i created sql 2008..

    how can i uprage my mdf files to 2008 ?

    can u give me example ?

    i have tried below at SSMS (New Query)

    ALTER DATABASE vitrin

    SET COMPATIBILITY_LEVEL = 100

    but i see error message that

    Msg 5011, Level 14, State 5, Line 1

    User does not have permission to alter database 'vitrin', the database does not exist, or the database is not in a state that allows access checks.

    Msg 5069, Level 16, State 1, Line 1

    ALTER DATABASE statement failed.

    Thanks

    Thursday, March 26, 2009 5:19 PM
  • User2011918074 posted

    Have you attached the SQL Server 2005 databases in SQL Server 2008 Management Studio? If not, please attach them and then we can modify the Compatibility Level.

    Related document:

    How to: Attach a Database (SQL Server Management Studio)
    http://msdn.microsoft.com/en-us/library/ms190209.aspx

    Thursday, March 26, 2009 10:25 PM
  • User-1418772296 posted

    hi

    in SSMS 2008, i have clicked attache of right click of database. but error message that below.

    TITLE: Microsoft SQL Server Management Studio
    ------------------------------

    Attach database failed for Server 'JET-PC'.  (Microsoft.SqlServer.Smo)

    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.1600.22+((SQL_PreRelease).080709-1414+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476

    ------------------------------
    ADDITIONAL INFORMATION:

    An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

    ------------------------------

    Database 'vitrin' cannot be upgraded because it is read-only or has read-only files. Make the database or files writeable, and rerun recovery. (Microsoft SQL Server, Error: 3415)

    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.00.1600&EvtSrc=MSSQLServer&EvtID=3415&LinkId=20476

    ------------------------------
    BUTTONS:

    OK
    ------------------------------

    Friday, March 27, 2009 5:35 AM
  • User-1418772296 posted

    hi

    i have read below. but when i click this account in step 3), there is no system account.. there is account name and password. when i enter account name and password.. it give me error.

    what can i do ?

    Solution:

    1) Open Tools Admin (into Start Menu of Windows) and run Services. Look for service named "SQL SERVER (SQL EXPRESS)" and stop it.

    2) Double-click it and go to LOGON flap

    3) You'll se clicked "THIS ACCOUNT" pointing to that user. Click onto SYSTEM ACCOUNT, then OK

    4) Star this service again

    or how can i do below solution.. how can i log in like below ?

    meanwhile i hvae found a solution for the problem attaching a DB. I run the SQL2005 database module service onn the local systemaccount NT AUTHORITY\NETWORKSERVICE. This user is not in the user list for the director where the .mdf file is placed. After adding tis user with full access to the user list of the directory including all subdirectories everthing works fine.

    Friday, March 27, 2009 8:27 AM
  • User-1418772296 posted

    hi

    i have upraged 2005 mdf files to 2008 mdf files.

    i only change propertious of path that mdf files in it.

    i can run my website and i can use when my website need mdf files now.

    but when i log in, there is error that error :26. (sql2005 provider cant be found etc..)

    What can i do ?

    Thanks

    Saturday, March 28, 2009 5:50 AM
  • User-1418772296 posted

    hi

    i have solved error 26

    i have write in web.config

    <configuration>     <connectionStrings>        <remove name=”LocalSqlServer”/>        <add name="LocalSqlServer" connectionString="your connection string"/>    </connectionStrings> </configuration>

    Thanks

    Saturday, March 28, 2009 7:38 AM
  • User693641382 posted

    Hi  

    i got same error message that you received as given below while attaching a mdf file to sql server 2008.

    i simply went ahead  right clicked on mdf file removed check from read only property, and tried to attach the file once again.

    But it did some process and attached the file but the name of database file had changed from

    eg, ASPNETDB to  c:/[source path]/ASPNETDB

    and also creates a cheklog file with same name at source path

    -----------------------------------------------------------------------------------------------------

    error message :

     

    ADDITIONAL INFORMATION:

    An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

    ------------------------------

    Database 'vitrin' cannot be upgraded because it is read-only or has read-only files. Make the database or files writeable, and rerun recovery. (Microsoft SQL Server, Error: 3415)

    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.00.1600&EvtSrc=MSSQLServer&EvtID=3415&LinkId=20476

    ------------------------------

    Thursday, December 30, 2010 5:09 AM