How to attach the database files to the database with No Recovery Option?

Hi,

Need some expert advice here ....

Are there anyway to attach database files to the database with No Recovery Option?
Keng0499Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
Advertise Here
 
Scott PletcherConnect With a Mentor Senior DBACommented:
No, sadly not.  Best would be a backup of the original db rather than individual files.  But that's probably not available and can't be obtained.

If the version you're attaching to is the same as the original db's version, you could try this:

Attach the db, allowing SQL to recover it (since you can't prevent it).  Be sure to use the same name as the original db.

Backup the db.  Drop the db.  Restore the db from the new backup with "NORECOVERY".  Then, still using NORECOVERY, try applying the differential and/or log file(s).

When you've applied all the files, do a final:
RESTORE DATABASE <db_name> WITH RECOVERY

to make the db operational.
0
 
Vikas GargBusiness Intelligence DeveloperCommented:
Hi,

You can attach you database and then can change the recovery mode to Simple
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.