troubleshooting Question
sql I moved database files, how do I remap the dbs
I had originally created my databases by copying the files and running the sql below. I had to move the files to a different drive.
They were in: C:\OptionDB
They are now in : J:\OptionDB
Here is the command that I used to create the database.
CREATE DATABASE HOD201210
ON(NAME='HOD201210', FILENAME='C:\OptionDB\HOD2
LOG ON(NAME='HOD201210_log', FILENAME='C:\OptionDB\HOD2
FOR ATTACH WITH ENABLE_BROKER;
Go
I am also not sure if I can open sql server management studio since I moved the files before remapping or detaching.
They were in: C:\OptionDB
They are now in : J:\OptionDB
Here is the command that I used to create the database.
CREATE DATABASE HOD201210
ON(NAME='HOD201210', FILENAME='C:\OptionDB\HOD2
LOG ON(NAME='HOD201210_log', FILENAME='C:\OptionDB\HOD2
FOR ATTACH WITH ENABLE_BROKER;
Go
I am also not sure if I can open sql server management studio since I moved the files before remapping or detaching.
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 6 Comments.
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.