Learning about backups and restores

Question

Post reply

Learning about backups and restores

fminns-1058143

Default port

Points: 1404
More actions
April 7, 2009 at 4:57 am

#130361

Hi all
I'm wondering if someone can explain something to me.
I am going through my microsoft course material and am confused about something.
The nature of this lab is that I'm meant to:-
backup the aw database
stop the instance
corrupt a page
start the instance
restore the 'torn' page
backup the log
restore the log
.. but this doesn't quite work for me, instead I have to:-
backup the aw database
stop the instance
corrupt the page
start the instance
do a tail log backup 'no recovery' ( e.g to awtail.bak )
restore the 'torn' page
restore the awtail.bak with recovery
Any ideas why I have to follow a different procedure to get the same result?
Many thanks
Farren

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323518 More actions · Answer 1

oops bad info removed. I'll read up and come back.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

fminns-1058143 Default port Points: 1404 More actions · Answer 2

Well, I thought it was something like that too, BUT if I try to do the same exercise in Simple mode, I get the following error.

RESTORE PAGE is not allowed with databases that use the simple recovery model.

Grant Fritchey SSC Guru Points: 398882 More actions · Answer 3

Can't you use WITH REPLACE just like you would with a regular full backup restore when the tail hasn't been backed up?

"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

maechismo_8514 SSCoach Points: 17510 More actions · Answer 4

fminns (4/7/2009)
Well, I thought it was something like that too, BUT if I try to do the same exercise in Simple mode, I get the following error.
RESTORE PAGE is not allowed with databases that use the simple recovery model.

Yes, if the database is accessible then you should always backup the tail of the log and also if you are Simple Recovery model you would not be able to do a page restore as you would have to backup the log after the page restore.

Before doing this all you should run DBCC and check the pages that have been corrupted, since its an exercise for you may be they did not want you to do it.

fminns-1058143 Default port Points: 1404 More actions · Answer 5

Hi

Yes, I guess the WITH REPLACE would be the way foeward here. It's not what the course materials are telling me though which is just bound to confuse me 🙂

Thanks

Farren

Grant Fritchey SSC Guru Points: 398882 More actions · Answer 6

fminns (4/7/2009)
Hi
Yes, I guess the WITH REPLACE would be the way foeward here. It's not what the course materials are telling me though which is just bound to confuse me 🙂
Thanks
Farren

I have not gone through the courses, so I'm speaking from hear-say, but it's my understanding that the course materials from MS have a very long errata page somewhere on the web. You might want to track that down & check it out before you try going forward.

"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

fminns-1058143 Default port Points: 1404 More actions · Answer 7

Hi

I think I will do that 🙂

Won't help the learning process if the course materials are dodgy.

Regards

Farren