We are planning to install more disk space and need to temporarily move the data and log files and move them back after the disk space has been added.
Is Detach/Attach the best way to handle this?
You have to detach the database and then copy the .bak files to the directory and then attach it.
Steve Russell, MCDBA
|||Steve,
Thanks for the response. What will I need the .Bak file for? I thought I would just be working with the .mdf & .ldf files. In other words, I was planning to do a Detach, then move the .mdf and .ldf to another server, uninstall the current 30 GB drives then restall 200 GB drives and finally Attach the Db files...
Will this work or am I missing something?
David
|||Your absolutely correct, my bad; the .ldf and .mdf files.
No comments:
Post a Comment