Viewing 15 posts - 31 through 45 (of 353 total)
Is that script generated using the SSMS option.
It does tend to assume you are starting from scratch to create the publication.
Shouldn't there be accounts that are members of the Publication...
December 19, 2011 at 4:32 am
Yeah..you need to have a little read up on replication. Although merge is one of the more complicated forms, it's still fairly easy to set up. And as mentioned you...
December 19, 2011 at 4:26 am
Hi,
I think you need to read a little bit more about replication. Especially if you are supporting a production server.
Your answers to my questions suggest a very limited knowledge.
My advice....
November 22, 2011 at 7:01 am
Sorry I'm a little confused.
You are using Transactional replication..is that correct ?
What is failing at midnight ?
Is it the distribution agent or the snapshot agent ?
Can you tell me where...
November 22, 2011 at 5:13 am
For transactional replication, the snapshot is only applied once to sync with the subscriber.
Are you saying that you have transactional replication configured so that the snapshot agent runs every night...
November 22, 2011 at 5:03 am
So you've set up your replication and you now see replication jobs within the agent..is that correct ?
One should be a snapshot agent job. For your transactional replication, I'm guessing...
November 22, 2011 at 4:38 am
Ok..
So the Snapshot is failing..is that correct ??
Are you running this as a SQL job or some other way?
Can you run it manually ?
Thanks
Graeme
November 22, 2011 at 4:20 am
Hi,
How many tables in the publication?
What type of replication ?
What accounts are you using for your agents ?
Any server configuration that is specific to your company ??
Thanks
Graeme
November 22, 2011 at 1:19 am
Hmm..ok.
And your test environments are configured the same, albeit with less resources.
Have you load tested the application at all ??
This probably need a structured approach..and the articles posted by Gail...
July 11, 2011 at 9:40 am
Hi,
That sounds quite familiar to me...
Is the database being updated or is it read only ??
Have you minimised locking in the procedures ??
The high cxpacket value does suggest some parallelism...
July 11, 2011 at 9:05 am
Rebuilding indexes online is only available in Enterprise or Developer editions..which I suspect you already know.
Reorganising is the only real option open to you.
A rebuild of an index needs to...
July 11, 2011 at 8:57 am
Why don't you archive the data to a csv that can be zipped up into a fraction of the space..that way you have a fall back if the data is...
July 11, 2011 at 8:49 am
With 2008 you can also use CDC (Change Data Capture) or Change Tracking. Both are useful but require a little thought on what your needs are.
Another option is Audit triggers...
July 11, 2011 at 8:45 am
Like I said have tried getting the proxy account to do something simple through a job step..like create a folder or copy a file. Does the sql Agent account have...
July 11, 2011 at 8:11 am
Ok..
I recall an article by Microsoft that might help..it discusses using Alias' with the Client Network Utility
Hope this helps !!
Graeme
http://support.microsoft.com/default.aspx?scid=kb;en-us;321822&Product=sql2k
July 7, 2011 at 8:38 am
Viewing 15 posts - 31 through 45 (of 353 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy