Video Screencast Help
Search Video Help Close Back
to help

sql restore

Created: 20 Dec 2012 | Updated: 31 Jan 2013 | 4 comments
Arun K's picture
Arun K
0 0 Votes
Login to vote
This issue has been solved. See solution.

Difference between restore when recovery mode and not recovered mode in SQL restore

Discussion Filed Under:
, ,

Comments 4 Comments • Jump to latest comment

Marianne van den Berg's picture
Marianne van den Berg Trusted Advisor Partner Accredited Certified
sql restore - Comment:20 Dec 2012 : Link

NBU for Microsoft SQL Server Admin Guide  http://www.symantec.com/docs/DOC3670

Tell us what you read there.

Talk to your SQL dba - tell us what he says.

PLEASE don't expect to be spoon-fed? The answers can EASILY be found.

We are happy to assist with REAL issues - not theoretical stuff.

Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows
Handy NBU Links

SOLUTION
+1
Login to vote
  • Actions
Arun K's picture
Arun K
sql restore - Comment:20 Dec 2012 : Link

Any type of hint can be useful here

-1
Login to vote
  • Actions
Marianne van den Berg's picture
Marianne van den Berg Trusted Advisor Partner Accredited Certified
sql restore - Comment:21 Dec 2012 : Link

Hint: p.22 of the manual & p.66. 

 

Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows
Handy NBU Links

0
Login to vote
  • Actions
captain jack sparrow's picture
captain jack sparrow Partner Accredited
sql restore - Comment:25 Jan 2013 : Link

Snippets from admin guide

 

About database recovery
During the restore process, a database goes into "loading mode" until the restore
command is executed against the database using the "recovery" option. Before
you place the database into recovery mode all of the restore commands will have
been executed using the "Not recovered" option. This way it is possible to continue
to stage additional restore statements to bring the database up to the state you
want. The database becomes usable again after the last restore statement has
been applied the "Recovered" option.
You can choose the recovery option you want when you perform restores
 
Seems you are least interested in reading Admin Guides, But wants same to be put here in connect. It's matter of few mins to surf through guides,, Make them best friend it'll always help you and would reduce your questionaire
 
 

 Cheers !!!

 

EV Outlook Client Add-ins

+1
Login to vote
  • Actions