| T.R | Title | User | Personal
Name | Date | Lines |
|---|
| 6022.1 | | XSTACY::imladris.ilo.dec.com::grainne | Grainne Ni Choiligh | Wed May 21 1997 06:58 | 15 |
|
You might also ask this question in the SQL Server conference
AMCUCS::MS-SQLSVR If you still can't restore from a different
architecture backup on SQLServer v6.5, you may be able to
achieve what you want with SQLServer replication. This is described
in detail in Part 6 of the 'SQLServer v6.0 Administrator's
Companion' (included with SQLServer Books Online.) There are
some restrictions on replication, however.
Grainne Ni Choiligh
European Software Centre @ILO
mailto:[email protected]
|
| 6022.2 | | HLFS00::ERIC_S | Eric Sonneveld MCS - B.O. IS Holland | Wed May 21 1997 23:19 | 6 |
| No way to restore backups from Alpha on Intel or vv.
you can setup replication or like (what we did as backup) daily transfer (it
becomes a scheduled task) the database. THe first is contigious the second a
one (complete) shot per time interval you define.
Eric
|
| 6022.3 | Thanks to all | MOSDM::GALITSKY | Andrei Galitsky | Thu May 22 1997 00:50 | 0 |
| 6022.4 | Seems to work ok using Seagate Backup Executive | RDVAX::16.124.56.22::dave.levy | Run Like an Antelope | Mon May 26 1997 06:43 | 16 |
| re: .2
> No way to restore backups from Alpha on Intel or vv.
> you can setup replication or like (what we did as backup) daily transfer (it
> becomes a scheduled task) the database. THe first is contigious the second a
> one (complete) shot per time interval you define.
I have to disagree with you here. We are using SQL Server 6.5 on Windows NT
Alpha and Seagate's Backup Exec (with SQL Server integration) on an Intel machine
to do the backups on our entire environment. We have successfully restored a
corrupt SQL database from our Seagate backup.
Frankly, I didn't know that this was not supposed to work, but we did not have
any problems with it.
dave
|
| 6022.5 | | CGOOA::OWONG | SKIWI in Canada (VAO) | Mon May 26 1997 10:42 | 14 |
| I think we have language semantics in play here.
My thought is that a SQL backup of an Intel based SQL database cannot be
restored to an Alpha based SQL database.
.4 seems to be using the Intel to run a backup utility getting the
data from an Alpha SQL database.
The issue is not how or where the backup utility is run but what hardware
architecture did the database originate on.
Please correct me if this is wrong.
Owen.
|
| 6022.6 | | RDVAX::akocstdhcp104-25.ako.dec.com::levy | Run Like an Antelope | Tue May 27 1997 06:59 | 7 |
| Ahhhh...gotcha. Re-reading, I agree.
.2 does give some hints, but I think the customer probably wants to
do what we're doing. Really need more info before making any more
guesses.
dave
|