March 17, 2010 at 9:14 pm
Comments posted to this topic are about the item Database restore commands
M&M
March 17, 2010 at 9:15 pm
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
March 17, 2010 at 10:35 pm
Basic question on restore. Helpfull to beginners especialy.
March 17, 2010 at 10:36 pm
thanks
glad to get 2 points... however had to read the msdn to get the correct answer!
March 17, 2010 at 10:48 pm
March 18, 2010 at 12:47 am
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 ----)
March 18, 2010 at 5:12 am
Easy 2 points today! Good question though and a topic that every DBA should be familiar with.
March 18, 2010 at 5:51 am
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
---------------------------------------------------------------------
March 18, 2010 at 6:44 am
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.
March 18, 2010 at 9:15 am
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
March 18, 2010 at 11:26 am
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
March 18, 2010 at 3:23 pm
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:
March 30, 2010 at 8:05 am
Define 'developer'...:-P
March 30, 2010 at 8:17 am
Paul White NZ (3/30/2010)
Define 'developer'...:-P
people what code but can't restore databases! :-):-D;-)
---------------------------------------------------------------------
March 30, 2010 at 11:07 am
george sibbald (3/30/2010)
Paul White NZ (3/30/2010)
Define 'developer'...:-Ppeople what code but can't restore databases! :-):-D;-)
I called myself a Database Developer for many years...:-P
Viewing 15 posts - 1 through 14 (of 14 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy