See link below about adding articles and the 'allow immediate sync' property

http://deepakrangarajan.blogspot.com/2009/01/sql-2005-transaction-replication-adding.html

John.

See

http://msdn.microsoft.com/en-us/library/ms147311.aspx

but read this article first

http://msdn.microsoft.com/en-us/library/ms152560.aspx

John.

Have you tried dropping the article for the table that you are doing the deletes in, doing the deletes and then adding the article back to the publication. This...

I agree with Ten Centuries on 'keep it simple'. Before I start this kind of operation, I have a backup of either the database or the table that I...

Exactly Gail,

But you never know if you are missing something:-)

Have you tried to create a new backup job with the databases and backup folders with a cleanup task?

I have the same problem on some of my servers, but I...

I would say that Central Management Server is the best for me. I can right click on my central management server and choose new query. Once a new...

We use snapshots for one of our reporting databases. All processing is done by 7:00 AM when the old snapshot is dropped and the new snapshot is created. The...

First of all let me say that I enjoy my work and at times consider it one of those "and you mean that they will pay me to do that...

Your backup command does not look correct. Try

backup database pubs to disk='e:\pubs.bak'

In your log files job adjust the schedule to stop before your backup begins and start again...

I have always looked at my job security as to what skills and knowledge I have to sell. Attitude plays a large part in the job security also. ...

I have also used Jeff's code as a jumping off point to do date tally tables. Julian date conversions were what started me down this road. I usually...

select cast(cast(getdate() as varchar(12)) as datetime)

gives

2010-03-22 00:00:00.000

John.

If nothing else, you might want to start counting the records in the database to see if the database is really growing or not, and if so by how much.

create...

Here's how I do it with a sp. The path can be local or remote. Here days = 3, all "bak" files in the directory older that 3 days...