Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

sql restore

Created: 20 Dec 2012 • Updated: 31 Jan 2013 | 4 comments
This issue has been solved. See solution.

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

Comments 4 CommentsJump to latest comment

Marianne's picture

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
Arun K's picture

Any type of hint can be useful here

Marianne's picture

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

captain jack sparrow's picture

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

CJS