Restore/re-attach of MSDB to a recovered server
We had a major disaster and have to fully recover a server from scratch. The original database server had been running for some years. Now users are very interested in retaining existing SQL packages.
The server will be re-initialized with new copy of OS (Windows 2K Enterprise), and SQL Server 7.0 Enterprise re-installed (it's an older server).
Q:
Once that is done, can I take a copy of the old MSDB .MDF and .LDF files, retained from the original server, and use them to replace the MSDB that gets built when SQL is installed. I hope to detach and re-attach MSDB. Will that work? Will that cause errors? Can I do this just long enough to extract copies of the packages?
I will award at least 750 points for a sound resolution, but it won't let me put that many points directly only the question.
The server will be re-initialized with new copy of OS (Windows 2K Enterprise), and SQL Server 7.0 Enterprise re-installed (it's an older server).
Q:
Once that is done, can I take a copy of the old MSDB .MDF and .LDF files, retained from the original server, and use them to replace the MSDB that gets built when SQL is installed. I hope to detach and re-attach MSDB. Will that work? Will that cause errors? Can I do this just long enough to extract copies of the packages?
I will award at least 750 points for a sound resolution, but it won't let me put that many points directly only the question.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
There quite a good MS knowledge base article that may also help. It's about moving msdb e.t.c. to a different server so probably applies to your situation... Q224071
ASKER
Sorry for the delay in getting back to this.
Thanks to both of you, all the info was helpful.
I will award both of you 750 points as follows:
1) accept isplaney's comment as answer for this Q (500)
2) add new "points for" Q for isplaney for 250
3) add new "points for" Q for ozzydba for 500
4) add new "points for" Q for ozzydba for 250
Thanks to both of you, all the info was helpful.
I will award both of you 750 points as follows:
1) accept isplaney's comment as answer for this Q (500)
2) add new "points for" Q for isplaney for 250
3) add new "points for" Q for ozzydba for 500
4) add new "points for" Q for ozzydba for 250
ASKER
Oops, great, don't need to add a separate question.
Thanks again.