Error On Page 0 0 In Database
Contents |
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Asked by: backup detected an error on page RESTORE detected error on page (0:0) SQL Server > SQL backup detected an error on page in file Server Database Engine Question 1 Sign in to vote Hi I am battling to restore damage to the backup set was detected a database, and keep getting this error. System.Data.SqlClient.SqlError: RESTORE detected an error on page (0:0) in database "xxxxxxx" as read from the backup set. (Microsoft.SqlServer.Smo) restore verifyonly Source Machine is running SQL2008R2 Enterprise (10.50.2500) (32 bit), on Windows XP. Target Machine is running SQL2008R2 Enterprise (10.50.2500) (64 bit) on Windows 7. I have no problem restoring the .bak file on the source machine, but cannot get past that message ont he target system.I was under the impression
Continue_after_error
that the 32 and 64 bit versions of SQL were compatible, and that I am using the same version (service pack) on both machines. What am I missing. Thanks in Advance, Wednesday, September 21, 2011 9:09 AM Reply | Quote All replies 1 Sign in to vote Hi, I'm pretty sure there's no problem restoring between different versions. I would try taking a fresh copy of your .bak file to see if that restores. Have you tried a RESTORE VERIFYONLY to see if you get more information about the backup failure? You could try using the CONTINUE_AFTER_ERROR with the backup command, then run a DBCC CHECKDB on the database. http://msdn.microsoft.com/en-us/library/ms190952.aspx Thanks, Andrew Bainbridge SQL Server DBA Please click "Propose As Answer" if a post solves your problem, or "Vote As Helpful" if a post has been useful to you Edited by Andrew Bainbridge Wednesday, September 21, 2011 10:28 AM
Start 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 Overflow the company Business Learn more
System.data.sqlclient.sqlerror Restore Detected An Error On Page
about hiring developers or posting ads with us Server Fault Questions Tags Users Badges Unanswered Ask restore verifyonly command in sql server Question _ Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute: Sign dbcc checkdb up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top RESTORE detected an error on page (0:0) in database
SERVICES Services Overview Education Services Business Critical Services Consulting Services Managed Services Appliance Services CUSTOMER CENTER Customer https://www.veritas.com/support/en_US/article.TECH63983 Center Support Community MyVeritas Customer Success Licensing Programs Licensing http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=132368 Process ABOUT About Corporate Profile Corporate Leadership Newsroom Research Exchange Investor Relations Careers Legal Contact Us English 中文(简体) English Français Deutsch Italiano 日本語 한국어 Português Español USA Site: Veritas Veritas PartnerNet SQL RESTORE fails with error on Error 'RESTORE detected an error on page (10244:1799427905) in database "
SQL Server experts to answer whatever question you can come up with. Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums. SQL Server Forums Profile | ActiveTopics | Members | Search | ForumFAQ Register Now and get your question answered! Username: Password: Save Password Forgot your Password? All Forums SQL Server 2005 Forums SQL Server Administration (2005) RESTORE FAILED - error on page (0:0) Reply to Topic Printer Friendly Author Topic Mathias Posting Yak Master France 119 Posts Posted-09/07/2009: 05:26:22 Everyday, I restore the Production database on a staging server. For the last 3 days, I am unable to do it. I have the following error:Msg 3183, Level 16, State 2, Line 57RESTORE detected an error on page (0:0) in database "G_Restore" as read from the backup set.Msg 3013, Level 16, State 1, Line 57RESTORE DATABASE is terminating abnormally.What should I do?This is the command I use:RESTORE DATABASE G_Restore FROM DISK = @Backup_File_PathWITH MOVE 'G_DB_Data' TO @DataBasePhysical,MOVE 'G_DB_Log' TO @LogPhysicalIt runs on SQL Server 2005 and the database is in Full recovery mode with transaction LOG Edited by - Mathias on 09/07/2009 05:49:38 RickD Slow But Sure Yak Herding Master United Kingdom 3608 Posts Posted-09/07/2009: 05:39:29 Sounds like your backups are corrupted or you are trying to restore over the wrong database.Do you verify your backups after taking them? Is your @Backup_File_Path correctly set?Are your paths correct? Edited by - RickD on 09/07/2009 05:40:29 Mathias Posting Yak Master France 119 Posts Posted-09/07/2009: 05:41:06 I don't verify the backup after taking them. The path is correct. I have the errors after 2hours 30 minutes of restore.I have DBCC CHECKDB on the original db and it reported no error:CHECKDB found 0 allocation errors and 0 c