Solved

snapshot replications sql 2005

Posted on 2011-09-16
1
191 Views
Last Modified: 2012-08-13
there is a snapshot replication that is refreshed nightly. The snapshot is now requiring significantly long time to complete. Is there anything to look for? or anything that can help speed up the process?
0
Comment
Question by:sqlserverdba
1 Comment
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 250 total points
ID: 36551167
"The snapshot is now requiring significantly long time to complete"
We need some context here...

1. Define "significantly long" in chronological terms
2. Is this "Long" time something new (all of a sudden), or has this been increasing faster that expected

I mean, if when you first ran this 5 years ago, with 1000 records it was fast.
But now 5 years later with "Millions of records, "it is now requiring significantly long time to complete"...
...Then this may just be normal...

(Consider Archiving some data perhaps...?)
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question