Bokeh wrote: » We are upgrading a few of our computers, and I need to pull the sql 2008 db from 12 machines and put them on 12 new ones. I stopped the service, found the files I needed, and attempted to copy them. I am told right away that there is not enough room on the disk. Files are less than 5gb, and the external drive has 250gb free. I tried the google approach, and the few suggestions I saw didnt work. Has anyone done this successfully?
erpadmin wrote: » I don't know what you're doing, but normally when I want to do a database copy, I make a backup of the db, copy the safeset (file with .bak extension), and then restore it to whatever SQL instance I want. I'm guessing you are trying to copy the data and log files and then trying to reattach them. That can and does work too, but I prefer the backup/restore option, personally.
Bokeh wrote: » Thanks for the tips. These db's are small, the only purpose they serve is for Goldmine PE 8.5. So each one of our computers have a copy of sql 2008 on it, running XP. Management decided to upgrade the hardware for 12 desktops, so I just need to travel to the 12 places and get the data off. I'll set up a backup and then zip that for transfer to the ftp site, and then reload on the new machines before delivering them later this month.
it_consultant wrote: » Did you ask goldmine what steps you need to take to migrate from one PC to another. I am sure the database backup is very similar to what other posters have said, in my experience though, it is better to use the manufacturers procedures. In case something gets screwed up and you end up talking to their tech support, it will be much easier to troubleshoot.
jimmy1829 wrote: » Check the file system on the external hd, make sure it is on NTFS
RobertKaucher wrote: » Gotta love that file size copy limit! As a DBA I would still do this as a backup and not copy the mdf and ldf files, though.
erpadmin wrote: » +1 on that...as I said, it CAN work, but if you don't know what you're doing, a bunch of stuff can go wrong.
