Dave_O Posted January 14, 2015 Posted January 14, 2015 I have done a test using the SQL migration 2014 utility on an existing SIMS instance using the copy to file option. This completed without issue but the SIMS database was detached. I did not have time to see if dbattach would reattach the database (snapshotted the machine prior to migration and rolled back asap). Does anyone know if a simple dbattach will restore the existing database?
steveg Posted January 15, 2015 Posted January 15, 2015 It should do, just move the mdf / ldf out of the data folder first, as it tries to copy them to that folder as part of the process, and fails if they are already there. Steve
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now