At 03:19 PM 10/10/2003, you wrote:
>What do you get if you run this against the backup in QA:
>
>
>restore verifyonly from disk = 'C:\your_backup_file_here'
>
>-----Original Message-----
>From: Larry C. Lyons [mailto:[EMAIL PROTECTED]
>Sent: Friday, October 10, 2003 1:55 PM
>To: CF-Community
>Subject: RE: SQL Server Conundrum
>
>
>Nope its a brand new computer last June, with a clean install of SQL Server
>2000.
>
>larry
>
>At 02:40 PM 10/10/2003, you wrote:
> >Do you have the database (older version or something) on your machine? If
> >so, you may consider removing it or pointing to another database to restore.
> >
> >-----Original Message-----
> >From: Larry C. Lyons [mailto:[EMAIL PROTECTED]
> >Sent: Friday, October 10, 2003 1:51 PM
> >To: CF-Community
> >Subject: Re: SQL Server Conundrum
> >
> >Doug,
> >
> >That's the problem I try to run the restore and keep getting this error
> >response:
> >
> >The backup set holds a backup of a database other than the existing "XXX"
> >database. RESTORE DATABASE terminated abnormally.
> >
> >larry
> >
> >At 09:42 AM 10/10/2003, you wrote:
> > >Even SQL 7 will not directly read the backup file
> > >
> > >You will have to "restore" the backup to a local directory, and then open
> >the
> > >resulting files.
> > >
> > >======================================
> > >Stop spam on your domain, use our gateway!
> > >For hosting solutions <http://www.clickdoug.com>http://www.clickdoug.com
> > >Featuring Win2003 Enterprise, RedHat Linux, CFMX 6.1 and all databases.
> > >ISP rated:
> > ><http://www.forta.com/cf/isp/isp.cfm?isp_id=772>http://www.forta.com/cf
> /isp
> >/isp.cfm?isp_id=772
> > >Suggested corporate Anti-virus policy:
> > ><http://www.dshield.org/antivirus.pdf>http://www.dshield.org/antivirus.pdf
> > >======================================
> > >If you are not satisfied with my service, my job isn't done!
> > >
> > >----- Original Message -----
> > >From: "Larry C. Lyons" <[EMAIL PROTECTED]>
> > >To: "CF-Community" <[EMAIL PROTECTED]>
> > >Sent: Friday, October 10, 2003 8:09 AM
> > >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]
