Re: Migration from existing database server 2005 to new database server 2005

As far I as I know you will have to write your own script to backup log
file database on the source and copy and restore over a new machine to
mimic how log shipping works






<Bigserver@xxxxxxxxxxx> wrote in message
news:%235LRZmRjIHA.1164@xxxxxxxxxxxxxxxxxxxxxxx
Can we do online database migration from existing database server 2005
to new database server 2005, plz help me in this regard how to do it

Thanks,
Big


.

Relevant Pages

  • Re: KornShell question - manipulating a date timestampe
    ... > I'm trying to write a script that will head and tail the backup log ... The format of the file, right now, is ... I'm just learning ksh programming. ... If your backup is run by a program you have access to (a script) have the ...
    (comp.unix.aix)
  • Logs/Restore Logs
    ... Whats contained the the Backup Log Files? ... the log takes place on say a standby server? ... the log after executing those statements, will the log contain those DML ... And if it does contain the DML, does that mean that when a restore log ...
    (microsoft.public.sqlserver.server)
  • Re: Automating Backups
    ... > Here is the script. ... > I have SQL Server 2K developer. ... simple recovery model so that no backup log is allowed... ... USE msdb ...
    (microsoft.public.sqlserver.msde)
  • Re: Log Shipping Problem
    ... Do you perform BACKUP LOG withinit OPTION and then RESTORE it. ... create database test ... backup database test to disk = 'd:\db.bak' WITH INIT ...
    (microsoft.public.sqlserver.server)
  • Logging shadow copy activity?
    ... A customer called today and said that some of their files mysteriously ... I checked the backup log and no ... one has done a restore. ... I have shadow copy enabled on the volume and I wonder ...
    (microsoft.public.windows.server.sbs)