Last post Dec 30, 2010 05:09 AM by Rahul Trivedi
Mar 05, 2009 05:54 AM|oguzkaygun|LINK
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 ?
Mar 05, 2009 07:00 AM|Naom|LINK
I posted this link before
You can upgrade your MDF to SQL Server 2008, but you would not be able to downgrade.
Mar 05, 2009 08:13 AM|oguzkaygun|LINK
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 ?
Mar 10, 2009 02:34 AM|Jian Kang - MSFT|LINK
For more information about SQL Server index, please refer to the links below:
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
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
ALTER DATABASE Compatibility Level (Transact-SQL)
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.
Mar 26, 2009 05:19 PM|oguzkaygun|LINK
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)
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.
Mar 26, 2009 10:25 PM|Jian Kang - MSFT|LINK
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.
How to: Attach a Database (SQL Server Management Studio)
Mar 27, 2009 05:35 AM|oguzkaygun|LINK
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:
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:
Mar 27, 2009 05:51 AM|Jian Kang - MSFT|LINK
Please refer to the links below:
Mar 27, 2009 08:27 AM|oguzkaygun|LINK
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 ?
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.
Mar 28, 2009 05:50 AM|oguzkaygun|LINK
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 ?
Mar 28, 2009 07:38 AM|oguzkaygun|LINK
i have solved error 26
i have write in web.config
<add name="LocalSqlServer" connectionString="your connection string"/>
Dec 30, 2010 05:09 AM|Rahul Trivedi|LINK
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 :