Re: Log Shipping In Syn?

Tech-Archive recommends: Fix windows errors by optimizing your registry

Yes, for an example of how to do this have a look at this -
http://www.sql-server-performance.com/sql_server_log_shipping.asp

--
Hilary Cotter

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



"Ed" <Ed@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D29A7CCA-621C-4202-9452-AE814179F8D4@xxxxxxxxxxxxxxxx
Hilary ,
I would like to make sure I don't misunderstand what you mean

Do you mean I should put three steps (backup --> copy --> restore) into
one
job? Inside the job, I should do "Go To Next Step if succeed" in order to
do
"synchronously".

The way that the SSMS uses to setup is "asynchronously"?

Thanks again

Ed

"Hilary Cotter" wrote:

There are two ways of doing log shipping - synchronously - the way you do
it, and asynchronously.

With synchronous a job, does the backup, copies it to the secondary, and
then applies the log there. Then the job completes and the next scheduled
job runs. If there is some overlap you miss a scheduled backup, copy,
restore operation, but log shipping is resilient to this.

With asynchronous you dump, and then another job does the copy and a
third
job does the restore. Backups will be queued at the primary until they
are
copied, and then queued at the secondary and applied in order there. The
advantage of this is that your exposure to data loss is much less.

--
Hilary Cotter

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



"Ed" <Ed@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9F855BA3-1813-4ACA-B2A0-008FC8ED8B40@xxxxxxxxxxxxxxxx
Hi,
If I set up the backup of the log file every 5 mins and I also setup
the
copy every 5 mins same as restore every 5 mins, I don't think I am
going
to
get the database updated every 5 mins since the backup and copy could
take
more time to finish. Is there any way to make sure everything in
sequence,
Cackup-->Copy-->Restore in stead of calculating the time for log
shipping?

Thanks

Ed





.

Relevant Pages

  • Re: back up
    ... mydocs folder has taken say about 10/15 mins. everything working as it is ... preventing the backup process from ... transfer rate fluctuates wildly because you have a bad medium ... then the ETA will fluctuate just as wildly. ...
    (microsoft.public.windowsxp.general)
  • Backup Server
    ... I am using Windows backup utilities and setting an incremental backup to sun ... Run small business server windows server 2003. ... Stop Task If Runs X Hours and X Mins: 72:0 ... rt - Server Performance Report ...
    (microsoft.public.sqlserver.server)
  • Re: Windows Explorer/I.E. Version 7
    ... restored to factory settings twice in that period because of viruses and the fact that I didn't have much data to backup. ... Now I have better protection so I feel comfortable installing more programs and such. ... I come back the next day and double click the IE icon and it takes 15-20mins for my homepage to load after waiting 5 mins for IE to load. ...
    (microsoft.public.windowsxp.perform_maintain)
  • Re: Log Shipping In Syn?
    ... If there is some overlap you miss a scheduled backup, copy, ... restore operation, but log shipping is resilient to this. ... If I set up the backup of the log file every 5 mins and I also setup the ...
    (microsoft.public.sqlserver.replication)
  • Re: SQL2005 fulltext backup
    ... Hilary Cotter wrote: ... Can you try to run repeated queries to verify exactly ... explanation I can think of is the fact that I backup to the same disk ... has some live catalogs, but it seems that while backup is running the ...
    (microsoft.public.sqlserver.fulltext)