October 15, 2015 at 8:08 pm
Here are the specs
We have sql server 2005 version 9.00.4035 running on a windows 2003 server with sp2.
trying to upgrade to a windows enterprise 2008 r2 server with sql 2008 r2 version 10.50.6000
I detached the database and log files for a single database and copied them to the sql 2008 r2 box in the appropriate folders. The 2008R2 could not see the files so the attach did not work.
I backed up a database on the sql2005 box to a file share on the sql2008 r2 using a backup device. I could not restore it because the GUI could not recognize the backup device. Stumped I am.
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
October 16, 2015 at 2:02 am
Sounds like permission errors.
Post the error messages you are getting please.
October 20, 2015 at 8:11 am
Yes, it does sound like a permissions issue.
October 21, 2015 at 6:18 pm
I solved this. All I can say is stupid is as stupid does
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
October 22, 2015 at 5:13 am
What was the resolution?
October 30, 2015 at 3:06 pm
The detach and attach commands worked. Just had to reference the correct files.:hehe:
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply