masonrivlin
asked on
Restoring MS-SQL DBs from .bak files
In the event of disaster, How does one recover previous system with backup files (.bak) on a new server and a fresh install of SQL Server?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You have to rebuild the master database, using a tool that you should find on the SQL Server cd: rebuildm.exe
You can also reinstall the SQL Server, specifying those sort order.
You can also reinstall the SQL Server, specifying those sort order.
masonrivlin:
This old question needs to be finalized -- accept an answer, split points, or get a refund. For information on your options, please click here-> http:/help/closing.jsp#1
EXPERTS:
Post your closing recommendations! No comment means you don't care.
This old question needs to be finalized -- accept an answer, split points, or get a refund. For information on your options, please click here-> http:/help/closing.jsp#1
EXPERTS:
Post your closing recommendations! No comment means you don't care.
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
Award points to angelIII and allenstoner
Please leave any comments here within the next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
Anthony
EE Cleanup Volunteer
I will leave a recommendation in the Cleanup topic area that this question is:
Award points to angelIII and allenstoner
Please leave any comments here within the next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
Anthony
EE Cleanup Volunteer
ASKER
Now what I want to do is force it over the existing master db. After that, I am certain that the rest is a simple matter indeed.
With that in mind, How do I restore the master db when the backup from which I am working was saved in a NON binary sort order?