How do you restore a SQL database that is using full recovery mode?

Question

Post reply

How do you restore a SQL database that is using full recovery mode?

eba.seller

SSC Rookie

Points: 37
More actions
February 25, 2012 at 8:15 am

#265227

General Question, How do you restore a SQL database that is using full recovery mode?

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

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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Same way you restore any database.

RESTORE DATABASE <db name> FROM DISK = <location>

specify WITH NORECOVERY if there are additional backups (differential or log backups)

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

sengeet86 Ten Centuries Points: 1252 More actions · Answer 2

Impact of the Recovery Model on Backup and Restore :-

http://msdn.microsoft.com/en-us/library/ms191239.aspx

java programming

eba.seller SSC Rookie Points: 37 More actions · Answer 3

I have read several articles and still haven't found the answer to this. Can anymore give me a step by step answer to my problem?

Jeff Moden SSC Guru Points: 1004360 More actions · Answer 4

eba.seller (2/26/2012)
I have read several articles and still haven't found the answer to this. Can anymore give me a step by step answer to my problem?

Search for "how to restore a database in sql server 2008" in Google. The first link should do it for you.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

baabhu SSCertifiable Points: 6205 More actions · Answer 5

Before getting into the technical points.

What is the error you are getting?

I suggest you to please google and get some scripts to restore the database. if you encounter any issues with the restore let us know we can help you out.

--- babu

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 6

eba.seller (2/26/2012)
I have read several articles and still haven't found the answer to this. Can anymore give me a step by step answer to my problem?

Sure, 2 posts above yours I listed the command. Now, what exactly is the problem?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Divine Flame SSCoach Points: 15943 More actions · Answer 7

eba.seller (2/25/2012)
General Question, How do you restore a SQL database that is using full recovery mode?

As you said, its just a general question not a problem. Please let us know the exact problem that you are facing (if any).

Sujeet Singh