On Mon, Feb 16, 2009 at 1:16 AM, C. Hatton Humphrey wrote:
The main thing I'm worried about is any performance hit on the
publishing server. The target server can lag behind data-wise by a
bit (30 minutes to an hour is an acceptable delay).
Those do not appear to be very challenging
Don wrote:
With regard to 1,498 tables, do you mean, User Tables? just for clarity.
Yes, 1498 user tables. The application was originally built on a
flat-file database system like DB3/4 or Foxpro and was ported to SQL
Server without re-engineering the database. All of the tables have 8
Those do not appear to be very challenging requirements. You could
probably even do this without any of the built-in replication at all
but with just incremental backups. How have you currently configured
your backups? Do you notice a performance impact when you run a full
backup? Do you
On Mon, Feb 16, 2009 at 1:10 PM, C. Hatton Humphrey wrote:
Jochem van Dieten wrote:
The current schedule for backups is a full backup at 3am for the group
of databases and then a transactional backup every hour from 7am to
10pm during the week.
For performance size doesn't matter all that
Those do not appear to be very challenging requirements. You could
probably even do this without any of the built-in replication at all
but with just incremental backups. How have you currently configured
your backups? Do you notice a performance impact when you run a full
backup? Do you
Question for anyone that handles SQL Replication: What effect would
setting up transactional replication from a large Windows 2000
database (17 Gb) with moderate usage (18-20 max simultaneous
connections) to a Windows 2005 server have on the performance of the
Windows 2000 machine?
The reason
Thanks for the comments, Don!
The main thing I'm worried about is any performance hit on the
publishing server. The target server can lag behind data-wise by a
bit (30 minutes to an hour is an acceptable delay). The problem is
the size. A MS Dynamics GP database contains 1,498 tables (not
Thanks for the comments, Don!
The main thing I'm worried about is any performance hit on the
publishing server. The target server can lag behind data-wise by a
bit (30 minutes to an hour is an acceptable delay). The problem is
the size. A MS Dynamics GP database contains 1,498 tables (not
Question for anyone that handles SQL Replication: What effect would
setting up transactional replication from a large Windows 2000
database (17 Gb) with moderate usage (18-20 max simultaneous
connections) to a Windows 2005 server have on the performance of the
Windows 2000 machine?
The reason
9 matches
Mail list logo