May 21, 2009 at 4:04 am
Dear,
I am using S2k5
Whenever I am taking back up Using GUI and restore that on another server it is not restoring and gives error..
Restore failed for server 'MadanB'.
Restore detected an error on page (65535:-1) in database as read from the back up set.
If I take back up from command then it restores successfully.I have run DBCC CheckDB also no error is coming.
Thanx
Thanks
May 21, 2009 at 4:19 am
Just check the backup file using RESTORE VERIFYONLY FROM DISK = 'path of backup file'
May 21, 2009 at 4:49 am
Dear Ratheesh,
I am getting this error:
Attempting to restore this backup may encounter storage space problems. Subsequent messages will provide details.
Directory lookup for the file "S:\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\postal_survey.mdf" failed with the operating system error 3(The system cannot find the path specified.).
Directory lookup for the file "S:\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\postal_survey_log.ldf" failed with the operating system error 3(The system cannot find the path specified.).
Msg 3189, Level 16, State 1, Line 1
Damage to the backup set was detected.
Msg 3013, Level 16, State 1, Line 1
VERIFY DATABASE is terminating abnormally.
Thanks
May 21, 2009 at 6:52 am
Then your backup is corrupted. Nothing you can do with it. Time to go to the previous backup.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 21, 2009 at 7:13 am
Hi,
Please give the complete syntax for DBCC CHECKDB. From the error message you had posted it looks like a page got corrupted. I think you can go for a page restore but not sure because you have to first get a clear idea of the level of corruption in your database. But read about DBCC and different corruptions and how to recover from the below link.
http://sqlskills.com/BLOGS/PAUL/post/CHECKDB-From-Every-Angle-How-long-will-CHECKDB-take-to-run.aspx
Thanks
Chandra Mohan N
[font="Verdana"]Thanks
Chandra Mohan[/font]
May 21, 2009 at 7:15 am
ChandraMohan Nandula (5/21/2009)
Hi,Please give the complete syntax for DBCC CHECKDB. From the error message you had posted it looks like a page got corrupted. I think you can go for a page restore but not sure because you have to first get a clear idea of the level of corruption in your database. But read about DBCC and different corruptions and how to recover from the below link.
http://sqlskills.com/BLOGS/PAUL/post/CHECKDB-From-Every-Angle-How-long-will-CHECKDB-take-to-run.aspx
Thanks
Chandra Mohan N
He wasn't running CHECKDB. He was running VERIFY_ONLY on a backup.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 21, 2009 at 11:36 pm
Hi,
Please select VERIFY option when you take backup using GUI.
Since you dont face any problems in restoring a backup taken using TSQL hope u r DB is perfect..
If u can please post the output of your DBCC CHECKDB.
May 21, 2009 at 11:42 pm
DBCC results for 'postal_survey'.
Service Broker Msg 9675, State 1: Message Types analyzed: 14.
Service Broker Msg 9676, State 1: Service Contracts analyzed: 6.
Service Broker Msg 9667, State 1: Services analyzed: 3.
Service Broker Msg 9668, State 1: Service Queues analyzed: 3.
Service Broker Msg 9669, State 1: Conversation Endpoints analyzed: 0.
Service Broker Msg 9674, State 1: Conversation Groups analyzed: 0.
Service Broker Msg 9670, State 1: Remote Service Bindings analyzed: 0.
DBCC results for 'sys.sysrowsetcolumns'.
There are 1047 rows in 10 pages for object "sys.sysrowsetcolumns".
DBCC results for 'sys.sysrowsets'.
There are 120 rows in 1 pages for object "sys.sysrowsets".
DBCC results for 'sysallocunits'.
There are 141 rows in 2 pages for object "sysallocunits".
DBCC results for 'sys.sysfiles1'.
There are 2 rows in 1 pages for object "sys.sysfiles1".
DBCC results for 'sys.syshobtcolumns'.
There are 1047 rows in 11 pages for object "sys.syshobtcolumns".
DBCC results for 'sys.syshobts'.
There are 120 rows in 1 pages for object "sys.syshobts".
DBCC results for 'sys.sysftinds'.
There are 0 rows in 0 pages for object "sys.sysftinds".
DBCC results for 'sys.sysserefs'.
There are 141 rows in 1 pages for object "sys.sysserefs".
DBCC results for 'sys.sysowners'.
There are 14 rows in 1 pages for object "sys.sysowners".
DBCC results for 'sys.sysprivs'.
There are 120 rows in 1 pages for object "sys.sysprivs".
DBCC results for 'sys.sysschobjs'.
There are 129 rows in 2 pages for object "sys.sysschobjs".
DBCC results for 'sys.syscolpars'.
There are 1095 rows in 16 pages for object "sys.syscolpars".
DBCC results for 'sys.sysnsobjs'.
There are 1 rows in 1 pages for object "sys.sysnsobjs".
DBCC results for 'sys.syscerts'.
There are 0 rows in 0 pages for object "sys.syscerts".
DBCC results for 'sys.sysxprops'.
There are 0 rows in 0 pages for object "sys.sysxprops".
DBCC results for 'sys.sysscalartypes'.
There are 27 rows in 1 pages for object "sys.sysscalartypes".
DBCC results for 'sys.systypedsubobjs'.
There are 0 rows in 0 pages for object "sys.systypedsubobjs".
DBCC results for 'sys.sysidxstats'.
There are 296 rows in 6 pages for object "sys.sysidxstats".
DBCC results for 'sys.sysiscols'.
There are 370 rows in 2 pages for object "sys.sysiscols".
DBCC results for 'sys.sysbinobjs'.
There are 23 rows in 1 pages for object "sys.sysbinobjs".
DBCC results for 'sys.sysobjvalues'.
There are 294 rows in 86 pages for object "sys.sysobjvalues".
DBCC results for 'sys.sysclsobjs'.
There are 14 rows in 1 pages for object "sys.sysclsobjs".
DBCC results for 'sys.sysrowsetrefs'.
There are 0 rows in 0 pages for object "sys.sysrowsetrefs".
DBCC results for 'sys.sysremsvcbinds'.
There are 0 rows in 0 pages for object "sys.sysremsvcbinds".
DBCC results for 'sys.sysxmitqueue'.
There are 0 rows in 0 pages for object "sys.sysxmitqueue".
DBCC results for 'sys.sysrts'.
There are 1 rows in 1 pages for object "sys.sysrts".
DBCC results for 'sys.sysconvgroup'.
There are 0 rows in 0 pages for object "sys.sysconvgroup".
DBCC results for 'sys.sysdesend'.
There are 0 rows in 0 pages for object "sys.sysdesend".
DBCC results for 'sys.sysdercv'.
There are 0 rows in 0 pages for object "sys.sysdercv".
DBCC results for 'sys.syssingleobjrefs'.
There are 133 rows in 1 pages for object "sys.syssingleobjrefs".
DBCC results for 'sys.sysmultiobjrefs'.
There are 320 rows in 2 pages for object "sys.sysmultiobjrefs".
DBCC results for 'sys.sysdbfiles'.
There are 2 rows in 1 pages for object "sys.sysdbfiles".
DBCC results for 'sys.sysguidrefs'.
There are 0 rows in 0 pages for object "sys.sysguidrefs".
DBCC results for 'sys.sysqnames'.
There are 91 rows in 1 pages for object "sys.sysqnames".
DBCC results for 'sys.sysxmlcomponent'.
There are 93 rows in 1 pages for object "sys.sysxmlcomponent".
DBCC results for 'sys.sysxmlfacet'.
There are 97 rows in 1 pages for object "sys.sysxmlfacet".
DBCC results for 'sys.sysxmlplacement'.
There are 17 rows in 1 pages for object "sys.sysxmlplacement".
DBCC results for 'sys.sysobjkeycrypts'.
There are 0 rows in 0 pages for object "sys.sysobjkeycrypts".
DBCC results for 'sys.sysasymkeys'.
There are 0 rows in 0 pages for object "sys.sysasymkeys".
DBCC results for 'sys.syssqlguides'.
There are 0 rows in 0 pages for object "sys.syssqlguides".
DBCC results for 'sys.sysbinsubobjs'.
There are 0 rows in 0 pages for object "sys.sysbinsubobjs".
DBCC results for 'M_Categorymaster'.
There are 29 rows in 4 pages for object "M_Categorymaster".
DBCC results for 'Spec_master'.
There are 1 rows in 1 pages for object "Spec_master".
DBCC results for 'ACCESSRECORD'.
There are 6291 rows in 61 pages for object "ACCESSRECORD".
DBCC results for 'Trans_Month_Price'.
There are 2 rows in 1 pages for object "Trans_Month_Price".
DBCC results for 'SEQ_GEN_Category'.
There are 1 rows in 1 pages for object "SEQ_GEN_Category".
DBCC results for 'SEQ_GEN_Item'.
There are 1 rows in 1 pages for object "SEQ_GEN_Item".
DBCC results for 'old_Circle_Details'.
There are 22 rows in 1 pages for object "old_Circle_Details".
DBCC results for 'old_M_Division'.
There are 2599 rows in 12 pages for object "old_M_Division".
DBCC results for 'old_M_NicCo_Ord'.
There are 670 rows in 5 pages for object "old_M_NicCo_Ord".
DBCC results for 'SEQ_GEN'.
There are 1 rows in 1 pages for object "SEQ_GEN".
DBCC results for 'old_M_Statemaster'.
There are 35 rows in 2 pages for object "old_M_Statemaster".
DBCC results for 'm_villagemaster_17Mar2009'.
There are 1188 rows in 93 pages for object "m_villagemaster_17Mar2009".
DBCC results for 'old_M_postalblock'.
There are 1949 rows in 131 pages for object "old_M_postalblock".
DBCC results for 'phase_dtls'.
There are 3 rows in 1 pages for object "phase_dtls".
DBCC results for 'sys.queue_messages_1317579732'.
There are 0 rows in 0 pages for object "sys.queue_messages_1317579732".
DBCC results for 'sys.queue_messages_1349579846'.
There are 0 rows in 0 pages for object "sys.queue_messages_1349579846".
DBCC results for 'sys.queue_messages_1381579960'.
There are 0 rows in 0 pages for object "sys.queue_messages_1381579960".
DBCC results for 'custodian'.
There are 151611 rows in 1321 pages for object "custodian".
DBCC results for 'arrow_file_dtls'.
There are 1728 rows in 12 pages for object "arrow_file_dtls".
DBCC results for 'PO'.
There are 584 rows in 17 pages for object "PO".
DBCC results for 'old_M_Districtmaster'.
There are 670 rows in 27 pages for object "old_M_Districtmaster".
DBCC results for 'Circle_Details'.
There are 22 rows in 1 pages for object "Circle_Details".
DBCC results for 'M_DistrictMaster'.
There are 610 rows in 10 pages for object "M_DistrictMaster".
DBCC results for 'M_Division'.
There are 462 rows in 3 pages for object "M_Division".
DBCC results for 'M_NicCo_Ord'.
There are 610 rows in 4 pages for object "M_NicCo_Ord".
DBCC results for 'M_Postalblock'.
There are 152282 rows in 9929 pages for object "M_Postalblock".
DBCC results for 'm_regionmaster'.
There are 72 rows in 1 pages for object "m_regionmaster".
DBCC results for 'm_statemaster'.
There are 35 rows in 1 pages for object "m_statemaster".
DBCC results for 'Taluk'.
There are 12985 rows in 73 pages for object "Taluk".
DBCC results for 'PO_M_Postalblock_Notused'.
There are 151264 rows in 7372 pages for object "PO_M_Postalblock_Notused".
DBCC results for 'PO_M_Postalblock'.
There are 151264 rows in 7405 pages for object "PO_M_Postalblock".
DBCC results for 'Final_table'.
There are 1188 rows in 18 pages for object "Final_table".
DBCC results for 'tt'.
There are 88 rows in 2 pages for object "tt".
DBCC results for 'tt1'.
There are 44 rows in 1 pages for object "tt1".
DBCC results for 'Item_tmp'.
There are 458 rows in 6 pages for object "Item_tmp".
DBCC results for 'Specifications_tmp'.
There are 458 rows in 14 pages for object "Specifications_tmp".
DBCC results for 'Item_Master'.
There are 467 rows in 14 pages for object "Item_Master".
DBCC results for 'Arrow_dtp'.
There are 0 rows in 0 pages for object "Arrow_dtp".
DBCC results for 'Item_State_Map'.
There are 471 rows in 11 pages for object "Item_State_Map".
DBCC results for 'Monthly_Price'.
There are 1 rows in 1 pages for object "Monthly_Price".
DBCC results for 'Trans_Spec_Shop_Dtls'.
There are 38 rows in 1 pages for object "Trans_Spec_Shop_Dtls".
DBCC results for 'Spec_Shop_Dtls'.
There are 25366 rows in 133 pages for object "Spec_Shop_Dtls".
DBCC results for 'm_villagemaster'.
There are 1188 rows in 150 pages for object "m_villagemaster".
DBCC results for 'old_m_regionmaster'.
There are 55 rows in 1 pages for object "old_m_regionmaster".
DBCC results for 'dtproperties'.
There are 0 rows in 0 pages for object "dtproperties".
CHECKDB found 0 allocation errors and 0 consistency errors in database 'postal_survey'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Thanks
May 21, 2009 at 11:52 pm
Hi Ajay,
Please try taking backup by checking the verify backup option in GUI.
Also please verify you are giving the right path to take the backup
May 21, 2009 at 11:54 pm
The error that you're getting through the GUI is "Path not found". When you try to restore through the GUI it assumes the database is being restored to the same location (drive and directory) on which the original database resided. If the server that you're trying to restore it to doesn't have an S: drive or the S: drive doesn't have a directory called S:\Microsoft SQL Server\MSSQL.1\MSSQL\DATA then the restore will fail.
Presumably you're using the "with move" option when restoring the database from the command line, which is why it's working when you do it that way.
I've never used the GUI to do backups or restores, but I would imagine there's an option when restoring to specify the drive/directory to restore the files to. If so make sure that you use that to specify the location for the restored database files.
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply