Make Your Microsoft Dynamics Investment Count & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.
Course Of The Month
8 days, 11 hours left to enrollBecome 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
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied?
You can use SQL Server Initialize from Backup…
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 combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Suggested Courses
Course of the Month8 days, 11 hours left to enroll
734 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.