I ran into a weird problem trying to restore a backup copy of SQL2000
database into the new SQL2005 server. I copied the backup file
"databasename.bak" to the backup folder of the new SQL2005 server but cannot
see it using browse in restore function.
help!!!
BillI would say that was not exactly the same directory or there is a
permissions issue. Verify the complete path or try some other location.
Ben Nevarez, MCDBA, OCP
Database Administrator
"Bill Nguyen" wrote:
> I ran into a weird problem trying to restore a backup copy of SQL2000
> database into the new SQL2005 server. I copied the backup file
> "databasename.bak" to the backup folder of the new SQL2005 server but cann
ot
> see it using browse in restore function.
> help!!!
> Bill
>
>|||Ben;
You're correct. I looked into the wrong folder.
After that, I ran into a different problem though:
I upgraded the SQLserver 2005 to SP1 ans tried to restore a copy of SQL2000
from another server to it. SQL 05 refused to restore saying that the backup
is for another SQLserver instance! I don't remember running into this
problem last time I did the same task.
Any idea why?
Thanks again.
Bill
Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
news:B1063714-ACF3-461D-885C-FCE372E210D4@.microsoft.com...[vbcol=seagreen]
> I would say that was not exactly the same directory or there is a
> permissions issue. Verify the complete path or try some other location.
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "Bill Nguyen" wrote:
>
No comments:
Post a Comment