Database restore commands

Question

Post reply

Database restore commands

M&M

SSC-Insane

Points: 21699
More actions
March 17, 2010 at 9:14 pm

#216683

Comments posted to this topic are about the item Database restore commands
M&M

Viewing 15 posts - 1 through 14 (of 14 total)

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

SQLRNNR SSC Guru Points: 281324 More actions · Answer 1

Thank you.

This is a good refresher and important topic.

Good question

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Joy Smith San SSC-Insane Points: 24877 More actions · Answer 2

Basic question on restore. Helpfull to beginners especialy.

ziangij SSCertifiable Points: 7794 More actions · Answer 3

thanks 🙂

glad to get 2 points... however had to read the msdn to get the correct answer!

ogsendmarged Grasshopper Points: 19 More actions · Answer 4

Yaaaaa,i am agree.nice

[url= http://www.articlesbase.com/health-articles/livea-diet-supplement-review-where-to-get-free-trial-of-livea-1970816.html%5DLivea%5B/url%5D

Arjun SreeVastsva SSCertifiable Points: 7137 More actions · Answer 5

Normally there are 3 types while performing restoration,

1.Leave the database ready to use by rolling back the uncommitted transactions. Additional transaction logs cannot be restored. (RESTORE WITH ----)

2.Leave the database non-operational, and do not roll back the uncommitted transactions. Additional transaction logs can be restored. (RESTORE WITH ----)

3.Leave the database in read-only mode. Undo uncommitted transactions, but save the undo actions in a standby file so that recovery effects can be reverted. (RESTORE WITH ----)

Chris Houghton SSCrazy Points: 2497 More actions · Answer 6

Easy 2 points today! Good question though and a topic that every DBA should be familiar with.

george sibbald SSC Guru Points: 104210 More actions · Answer 7

Thanks for the 2 points!

Only 54% correct so far, there's too many devs on this site! So its good they learnt something important 😀 😉

---------------------------------------------------------------------

Toby White SSCertifiable Points: 6187 More actions · Answer 8

2 points 2 easy. One complaint - your language in the question and for the answer was imprecise. In your answer you said something about basically waiting for a log restore, but you might also want to restore with norecovery on the full backup because you want to apply a differential restore.

SQLRNNR SSC Guru Points: 281324 More actions · Answer 9

george sibbald (3/18/2010)
Thanks for the 2 points!
Only 54% correct so far, there's too many devs on this site! So its good they learnt something important 😀 😉

LOL

Thanks George

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

M&M SSC-Insane Points: 21699 More actions · Answer 10

Toby White (3/18/2010)
2 points 2 easy. One complaint - your language in the question and for the answer was imprecise. In your answer you said something about basically waiting for a log restore, but you might also want to restore with norecovery on the full backup because you want to apply a differential restore.

Thanks, I agree. Even I got confused when I read the question today 😀

I will try next time, to present more clearly.

M&M

OCTom SSChampion Points: 11785 More actions · Answer 11

george sibbald (3/18/2010)
Thanks for the 2 points!
Only 54% correct so far, there's too many devs on this site! So its good they learnt something important 😀 😉

You wouldn't have anything to do without us "devs". :w00t:

Paul White SSC Guru Points: 150467 More actions · Answer 12

Define 'developer'...:-P

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

george sibbald SSC Guru Points: 104210 More actions · Answer 13

Paul White NZ (3/30/2010)
Define 'developer'...:-P

people what code but can't restore databases! :-):-D;-)

---------------------------------------------------------------------

Paul White SSC Guru Points: 150467 More actions · Answer 14

george sibbald (3/30/2010)
Paul White NZ (3/30/2010)
Define 'developer'...:-P
people what code but can't restore databases! :-):-D;-)

I called myself a Database Developer for many years...:-P

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi