September 26, 2006 at 3:59 pm
I installed SQL2005 on a win2003 server using the C drive for the application and the D drive for the databases. The D drive contains the backup folder.
I copied a backup of a local sql2000 database to this folder.
When I tried to run the restore process, the SQl2005 application would not recognize the D drive. To make the restore work, I had to copy the backup to the C drive on the server. I'm a local admin on the server and I gave the server account admin rights. It still would not recognize the D drive.
Can someone help?
A co-worked backup up a local sql2000 database.
I copied the backup to a backup folder on the D drive
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.
September 27, 2006 at 7:13 am
How were you trying to restore the file, via the Gui or Via a script? If using the GUI there shoudl have been an option to change the location of the database files, iif using TSQL use the With MOVE switch.
September 27, 2006 at 9:33 am
Via the gui. The interface did not permit any restore files locations except those on the C drive.
The only thing I can think of is maybe the SQL2000 backup was created on the C drive of my user's desktop.
Anyone else?
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.
September 27, 2006 at 9:57 am
Were you using the From database or from file option? If you choose the from file option, it will work. Here are the steps..
click from Device, then the elipses...
BackupMedia, Click Add
Browse to your file. Click ok a couple of time to get back to the main screen...
September 27, 2006 at 10:03 am
That is what I tried. Oh well, it's a mystery.
have a great day.
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 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply