Activate Standby Database

Hello,

I'm upgrading my database server hardware this weekend. On the new
server, I've created a standby database and
logs are being copied over and applied right away on the standby. I've
scheduled a planned downtime
to shutdown my production database and then active the standby on the
new hardware.

Question: Since all redo logs and control files are available, can I
move the standby control files out of the way and copy
the old production server redo log files and
control files over to the new server? Then open the database

I don't want to do an alter database activate standby because this will
do a resetlogs and invalidate all my previous backups. I could
backup the control file to trace on old server and create new control
file on new server with this script.

.

Relevant Pages

  • Re: How to apply SP4 to SQL Server 2000 Log Shipping
    ... Hi, Mike. ... I don't have specific knowledge if you can ship to one server running sp3 ... the standby database is in the same instance as the Test ...
    (microsoft.public.sqlserver.replication)
  • Re: How to apply SP4 to SQL Server 2000 Log Shipping
    ... I don't have specific knowledge if you can ship to one server running sp3 ... the standby database is in the same instance as the Test ... Note that applying SP4 for us also requires a Collation change. ...
    (microsoft.public.sqlserver.replication)
  • Re: Using EM 10gR2 to Create Standby Database
    ... database on the same server as the primary database. ... I want the standby created in /t15, not in /u01, but I have not found ... would want a standby on the same server as the primary. ... That server holds only test versions of production databases. ...
    (comp.databases.oracle.server)
  • Re: Using EM 10gR2 to Create Standby Database
    ... database on the same server as the primary database. ... I want the standby created in /t15, not in /u01, but I have not found ... would want a standby on the same server as the primary. ... That server holds only test versions of production databases. ...
    (comp.databases.oracle.server)
  • Create SharePoint Portal failed.
    ... One mentioned ensuring that SQL Server uses a case ... 13:55:40 Service database server is 'USDC-JOHRIV'. ... Update dbo.propertylist set DisplayName = N'Last name' ...
    (microsoft.public.sharepoint.portalserver)