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]
