Attach a DB with No Recover

[qsac]

Is there a way to attach a dabase, with the No Recovery option?

Long story short, I have a MDF and LDF file from yesterday, and have TRN log file backups from today, but I have no dump files.

any ideas?

thanks,
Q

 

[mrdenny]

Nope.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[SQLBill]

Since you aren't restoring a database, you can't set it to no recovery. You also can't apply transaction log backups to a database that has been attached...that is only for RESTOREd databases.

-SQLBill

Posting advice: FAQ481-4875

 

[qsac]

This is what i thought.

This is for a client of mine, and i have warned them multiple time to make sure dumps are always working.

You guys are the best, thanks for all the info.

Q