Page Restore Error - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Other SQL Server Topics (2005)

Page Restore Error

Author

Topic

raguyazhin
Posting Yak Master

105 Posts

Posted - 2010-12-21 : 03:39:19

Hi

In My Database Page was Corrupted.I Tried to restore page from
old Backups of the same database.

First I Tried to restore a Full Backup the Error Occurred.

Use master
go

RESTORE DATABASE [Annotator]
PAGE = '1:158' FROM
DISK = 'C:\Backup\Annotator.bak';
GO

Error :-

Msg 3154, Level 16, State 4, Line 1
The backup set holds a backup of a database other than the existing 'Annotator' database.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

i Want to restore the Particular page only.Not Full database
Please help me to solve this problem.

Thanks
Ragu Thangavel

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-12-21 : 05:31:41

It's saying that the backup you are restoring from is not from the same database. Where does that backup come from? Is it a backup of the same database that has the corrupt page, prior to the page becoming corrupt?

--
Gail Shaw
SQL Server MVP

raguyazhin
Posting Yak Master

105 Posts

Posted - 2010-12-22 : 02:09:41

Dear Gail Shaw

Thanks for your reply.Your judgement was correct.the backups are taken from another server,but the backup was previous one week backup of the corrupted database.

Thanks
Ragu Thangavel

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-12-22 : 03:27:17

The backup has the exact same database that you're restoring to. Not same database name, different server, but exactly the same database.

--
Gail Shaw
SQL Server MVP

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources