How to Set database to NORECOVERY

[djj55]

Hello, SQL 2008.
I mistakenly restored a database with the default RECOVERY.
What I want is to restore log files to this database. As it takes a half hour to restore is there another way to set the database up to take the log files?

I hope this makes sense.

Thank you,

djj
The Lord is My Shepard (Psalm 23) - I need someone to lead me!

 

[mrdenny]

No, you'll need to restore the database again.

A 30 minute restore is nothing. Our database takes 26 hours.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog

 

[djj55]

Thanks Mr. Denny

P.S. I am about to submit a paper (different site) that references your FAQ (here) about manual log shipping you wrote for 2000 and I do give you credit.

djj
The Lord is My Shepard (Psalm 23) - I need someone to lead me!

 

[mrdenny]

No problem.

Cool, let me know where when you get it up there.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog