Please explain --cold backups 
Author Message
 Please explain --cold backups

I have a SQL server 7.0 database which is published for replication. I had a
few problems with the server where the database is and  I was unable to take
a backup of the database.  Even the sp_detach_db didn't work (probably
because of replication).
So, I shut down the server, and copied the database and log  files to
another server.  Please note that I didn't remove replication before
shutting down the server. When I  attached the database to the new server,
Replication was removed from this database.  I don't understand this
behavior.
Why the replication was removed from the server?  Is it the default behavior
of SQL Server?  Actually , it suited me fine, but I am curious to know.

Thanks

TIG



Tue, 20 Jul 2004 21:16:49 GMT
 Please explain --cold backups

TIG,

I have frequently done what you describe, and replication is unaffected.
Did you copy ALL of the database and log files ?
Because if you do, and the new server has the same name (and revisions),
then in my experience SQL starts up none the wiser.

Its a useful trick in bringing back for development an exact copy of a
customer's multi-server system ( as long as you don't take so long that
replication needs re-initialisation ).

Suggest your system had problems, and this is just a symptom.

Regards
    AJ

ps You haven't mentioned where the distributor was, that may have an effect.
pps It's not hard to hack a database to remove replication - they are just
flags in system tables - sometimes Enterprise Manager and/or the correct
stored procs don't work in a complicated disaster recovery scenario.



Quote:
> I have a SQL server 7.0 database which is published for replication. I had
a
> few problems with the server where the database is and  I was unable to
take
> a backup of the database.  Even the sp_detach_db didn't work (probably
> because of replication).
> So, I shut down the server, and copied the database and log  files to
> another server.  Please note that I didn't remove replication before
> shutting down the server. When I  attached the database to the new server,
> Replication was removed from this database.  I don't understand this
> behavior.
> Why the replication was removed from the server?  Is it the default
behavior
> of SQL Server?  Actually , it suited me fine, but I am curious to know.

> Thanks

> TIG



Thu, 22 Jul 2004 14:58:43 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Backups - could someone please explain....

2. Set Explain -- Please explain

3. Backup agent or cold backups (SQL 7.0)?

4. question on cold backup(in archive mode)

5. Cold Backups on Oracle 8 NT, MSCS, and Oracle FailSafe 2.1.2

6. Oracle Cold Backup Shared tablespaces

7. Oracle Hot / Cold Backup Scripts for Oracle Sever on HP-UX 10.20

8. Cold backups shell script

9. Tar cold backups on AIX

10. loss of system datafile with no cold backup

11. Cold Backups

12. Help: restore accidental deleted data from cold backup


 
Powered by phpBB® Forum Software