February 27, 2003 at 4:53 pm
When we were first setting up our SQL server (MS SQL 7) we had not getting all the parts of rit yet (backup drive etc) .. It was an older machine and I knew how to copy files over when we decided to upgrade to a new machine. Well the new machine had to come a lot faster than we had planned. The old machine decided not to boot after one of my employee's was tinkering with it. The hard drive won't boot on anything, but i have it as a secondary on a second machine now and i can access most files just fine. There is about 2 weeks worth of historical data used for a tracking program on that drive in a SQL database. Is there a way to import that data into the new SQL database so that we have it for reference in the future?
February 27, 2003 at 8:41 pm
Easiest is to copy the mdf (and ldf if you have it) to the new machine, then attach. Then you can either leave the data there and access as you need it, or move to the new/live db using DTS.
Andy
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply