Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.
Course Of The Month
Become a Premium Member and unlock a new, free course in leading technologies each month.
Solved
How to attach the database files to the database with No Recovery Option?
Posted on 2014-12-30
Hi,
Need some expert advice here ....
Are there anyway to attach database files to the database with No Recovery Option?
Need some expert advice here ....
Are there anyway to attach database files to the database with No Recovery Option?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2 Comments
Active today
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.
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.
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month5 days, 10 hours left to enroll
627 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.