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]
