have some sort of DB Backup file, when you choose to restore, you need to
check the physical file name. In your Restore dialog, click the Options tab.
Look at the section labeled "Restore database files as:" Make sure that the
path in the "Move to physical file name" is a valid one. This value is sent
in with the backup file and will most likely not match the path to your data
files area.
Hope this helps...
-----Original Message-----
From: Larry C. Lyons [mailto:[EMAIL PROTECTED]
Sent: Friday, October 10, 2003 9:28 AM
To: CF-Community
Subject: RE: SQL Server Conundrum
I'll have to post it again later, its on my home machine.
regards,
larry
At 09:13 AM 10/10/2003, you wrote:
>So what is happening? You bring the backup file over and choose (in
>Enterprise Manager, I assume) to restore database, right? Is this where it
>is failing? What is the error message?
>
>-----Original Message-----
>From: Larry C. Lyons [mailto:[EMAIL PROTECTED]
>Sent: Friday, October 10, 2003 9:10 AM
>To: CF-Community
>Subject: RE: SQL Server Conundrum
>
>Its a sql server 7 backup file. I'm trying to get my copy of sql server
>2000 (Dev edition) to read it and copy the database to my machine.
>
>larry
>
>At 08:29 AM 10/10/2003, you wrote:
> >That's quite strange. We have a mixed environment here (one legacy
server)
> >and we never have problems reading the 7 files on 2000. What exactly is
> >happening?
> >
> >-----Original Message-----
> >From: Larry C. Lyons [mailto:[EMAIL PROTECTED]
> >Sent: Thursday, October 09, 2003 8:58 PM
> >To: CF-Community
> >Subject: SQL Server Conundrum
> >
> >Hi,
> >
> >I need some help with a SQL server problem. I have SQL Server 2000, and a
> >client has SQL Server 7. He just sent me a backup of his database so that
I
> >could have a local copy of it, but my copy of SQL Server cannot read it.
I
> >am at a loss on how to proceed. Any suggestions would really be helpful.
> >
> >larry
> >
> > _____
> >
> >
> >----------
> >[
> _____
>
>
>----------
>[
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
