Ms Sql Error 602
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: Cannot attach database to SQL server error 602 SQL Server > Transact-SQL Question 0 Sign in to vote Hi, I created a database in SQL server 2008(language : United states English) on one machine , dettached the .mdf and .ldf files and tried them attaching them on SQL server 2008(language : Spanish) on different machine. But i got the following error: Attach database failed..... (Microsoft SQL Server , Error : 602) Would the language difference be the problem. If no , what would be it? Friday, February 11, 2011 6:54 AM Reply | Quote Answers 0 Sign in to vote The language has nothing to do with it. Error 602 is typically an error you get when you try to attach the database on a lower version. Double check @@version on both servers. Keep in mind that if the database comes from SQL 2008 R2, you cannot attach it on R1. Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se Links for SQL Server Books Online: SQL 2008, SQL 2005 and SQL 2000. (Just click the link you need.) Marked as answer by Kalman TothModerator Thursday, February 17, 2011 6:00 AM Friday, February 11, 2011 1:33 PM Reply | Quote 0 Sign in to vote Hi, from error 602, 602 21 Yes Could not find an entry for table or index with partition ID %I64d in database %d. This error can occur if a stored procedure references a dropped table, or metadata is corrupted. Drop and re-create the stored procedure, or execute DBCC CHECKDB. do you have the full string of the error? if the GUI doesnt give you much, you can always run sp_attach_db from query windows and get the detailed output. If you think my suggestion is useful, please rate it as helpful. If it has helped you to resolve the problem, please Mark it as Answer. Sevengiants.com Marked as answer by Kalman TothModerator Thursday, February 17, 2011 6:00 AM Saturday, February 12, 2011 11:50 AM Reply | Quote All replies 0 Sign in to vote How about the @@version? Are they the same? Can
360 games PC games Windows games Windows phone games Entertainment All Entertainment Movies & TV Music Business & Education Business Students & educators Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet https://social.msdn.microsoft.com/Forums/sqlserver/en-US/9ea43d69-b16a-4862-86ed-d88956640fd2/cannot-attach-database-to-sql-server-error-602?forum=transactsql Explorer Microsoft Edge Skype OneNote OneDrive Microsoft Health MSN Bing Microsoft Groove Microsoft Movies & TV Devices & Xbox All Microsoft devices Microsoft Surface All Windows PCs & tablets PC accessories Xbox & games Microsoft Lumia All https://support.microsoft.com/en-us/kb/269282 Windows phones Microsoft HoloLens For business Cloud Platform Microsoft Azure Microsoft Dynamics Windows for business Office for business Skype for business Surface for business Enterprise solutions Small business solutions Find a solutions provider Volume Licensing For developers & IT pros Develop Windows apps Microsoft Azure MSDN TechNet Visual Studio For students & educators Office for students OneNote in classroom Shop PCs & tablets perfect for students Microsoft in Education Support Sign in Cart Cart Javascript is disabled Please enable javascript and refresh the page Cookies are disabled Please enable cookies and refresh the page CV: {{ getCv() }} English (United States) Terms of use Privacy & cookies Trademarks © 2016 Microsoft
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack http://stackoverflow.com/questions/13358630/attach-a-mdf-file-created-by-sql-server-2008-in-sql-server-2000 Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Attach a .MDF file created by SQL Server 2008 in SQL Server 2000 up vote 0 ms sql down vote favorite I created a database in SQL Server 2008. I detached the database and I copied the .mdf over to the server, which is running SQL Server Enterprise Manager (SQL Server 2000). When I try to attach the MDF I get... Microsoft SQL-DMO (ODBC SQL State: HY000) Error 602: Could not find row in sysindexes for database ID 13, object ID 1, index ID 1. Run DBCC CHECKTABLE on ms sql error sysindexes. What does this mean? Is this because the db was created in a newer version? sql-server sql-server-2000 mdf share|improve this question edited Nov 13 '12 at 10:09 marc_s 454k938701033 asked Nov 13 '12 at 9:56 younes faqri 313 1 You CANNOT under any circumstances re-attach or restore a database created on SQL Server 2008 to an earlier version of SQL Server. It's just not possible - no trick, no workaround, no tool - just cannot be done. –marc_s Nov 13 '12 at 10:09 You will need to (1) create that new database in SQL Server 2000, (2) script out all database objects to SQL scripts in your 2008 database, (3) run those scripts in your 2000 version, and (4) also move the data using scripts or a SQL Data Diff tool like Red-Gate SQL Data Compare from the SQL Server 2008 to 2000. –marc_s Nov 13 '12 at 10:18 add a comment| 2 Answers 2 active oldest votes up vote 0 down vote accepted From the documentation on the (I believe depreciated, but used in SQL Server 2000) sp_attach_db stored proc: A database created by a more recent version of SQL Server cannot be attached in earlier versions. I think you'll have to script the schema and dat