Hi,
wanted to create a test company within sql 2008 that has all the same data as our live company. I created a backup of the live company and actually have the mdf file and also the bak file from backup within the sql management studio. I went to detach the test company and renamed the file called 850.mdf to 850.mdd. I then copied the copy of live company mdf into same directory as where the 850.mdd currently is. I then tried to do an attach of the copy of live company but got errors. I actually renamed the copy of live data to 850.mdf. Was this necessary and could i have done a restore of the bak file instead? The restore actually said that i am trying to restore data that is from a different company structure so forth. thanks
wanted to create a test company within sql 2008 that has all the same data as our live company. I created a backup of the live company and actually have the mdf file and also the bak file from backup within the sql management studio. I went to detach the test company and renamed the file called 850.mdf to 850.mdd. I then copied the copy of live company mdf into same directory as where the 850.mdd currently is. I then tried to do an attach of the copy of live company but got errors. I actually renamed the copy of live data to 850.mdf. Was this necessary and could i have done a restore of the bak file instead? The restore actually said that i am trying to restore data that is from a different company structure so forth. thanks
The Value of Experts Exchange in My Daily IT Life
Experts Exchange (EE) has become my company's go-to resource to get answers. I've used EE to make decisions, solve problems and even save customers. OutagesIO has been a challenging project and... Keep reading >>
Mike
Owner of Outages.IO
Phoenix, Arizona, United States
Member Since 2016
Join a full scale community that combines the best parts of other tools into one platform.
Unlock 1 Answer and 2 Comments.
View membership options“All of life is about relationships, and EE has made a virtual community a real community. It lifts everyone's boat.”
William Peck
Member since 2004
Our community of experts have been thoroughly vetted for their expertise and industry experience.