SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Mohammed Moinudheen / Database restore commands / Latest Posts

RE: Database restore commands

Paul White — Tue, 30 Mar 2010 11:07:05 GMT

[quote][b]george sibbald (3/30/2010)[/b][hr][quote][b]Paul White NZ (3/30/2010)[/b][hr]Define 'developer'...:-P[/quote]people what code but can't restore databases! :-):-D;-)[/quote]I called myself a Database Developer for many years...:-P

RE: Database restore commands

george sibbald — Tue, 30 Mar 2010 08:17:01 GMT

[quote][b]Paul White NZ (3/30/2010)[/b][hr]Define 'developer'...:-P[/quote]people what code but can't restore databases! :-):-D;-)

RE: Database restore commands

Paul White — Tue, 30 Mar 2010 08:05:18 GMT

Define 'developer'...:-P

RE: Database restore commands

OCTom — Thu, 18 Mar 2010 15:23:35 GMT

[quote][b]george sibbald (3/18/2010)[/b][hr]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 :-D ;-)[/quote]You wouldn't have anything to do without us "devs". :w00t:

RE: Database restore commands

mohammed moinudheen — Thu, 18 Mar 2010 11:26:13 GMT

[quote][b]Toby White (3/18/2010)[/b][hr]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.[/quote]Thanks, I agree. Even I got confused when I read the question today :-DI will try next time, to present more clearly.

RE: Database restore commands

SQLRNNR — Thu, 18 Mar 2010 09:15:55 GMT

RE: Database restore commands

Toby White — Thu, 18 Mar 2010 06:44:38 GMT

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.

RE: Database restore commands

george sibbald — Thu, 18 Mar 2010 05:51:51 GMT

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 :-D ;-)

RE: Database restore commands

Chris Houghton — Thu, 18 Mar 2010 05:12:16 GMT

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

RE: Database restore commands

Sree Arjun Div — Thu, 18 Mar 2010 00:47:52 GMT

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 ----)

RE: Database restore commands

ogsendmarged — Wed, 17 Mar 2010 22:48:08 GMT

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]Livea[/url]

RE: Database restore commands

ziangij — Wed, 17 Mar 2010 22:36:06 GMT

thanks :-)glad to get 2 points... however had to read the msdn to get the correct answer!

RE: Database restore commands

Joy Smith San — Wed, 17 Mar 2010 22:35:20 GMT

Basic question on restore. Helpfull to beginners especialy.

RE: Database restore commands

SQLRNNR — Wed, 17 Mar 2010 21:15:51 GMT

Thank you.This is a good refresher and important topic.Good question

Database restore commands

mohammed moinudheen — Wed, 17 Mar 2010 21:14:56 GMT

Comments posted to this topic are about the item [B]Database restore commands[/B]