will have to be treated somewhat differently.
If they can get you the required permissions on the original database server,
then you can use Enterprise manager to create a local copy of the database in
question and then synchronize it with the original. That would be the easiest
method without having to get into all the permissions involved in the backup
file which is probably causing your errors
======================================
Stop spam on your domain, use our gateway!
For hosting solutions 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
Suggested corporate Anti-virus policy: 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 12:50 PM
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]
