Wich type of replication? Transactional, merge?

Try running sp_subscription_cleanup. Check for parameters in BOL.

You can put your DBCC CHECKDB commands in separate jobs one for each db you need to check.

In 2000 the complete excecution is logged on SQL log, with the message...

Right Frank.

It was my mistake. Pay no atention to my answer.

Sorry for the mess, I meant this:

DROP TABLE myName

GO

CREATE TABLE myName(myn char(10))

go

INSERT INTO myName (myn) VALUES('alfred')

INSERT INTO myName (myn) VALUES('Alfred')

INSERT INTO myName (myn) VALUES('berta')

INSERT INTO myName (myn) VALUES('Frank')

INSERT INTO myName...

Another way could be this one, but don't know if it is cost efective:

DROP TABLE myNameGOCREATE TABLE myName(myn char(10))goINSERT INTO myName (myn) VALUES('alfred')INSERT INTO myName (myn) VALUES('Alfred')INSERT INTO myName (myn)...

Wich type of replication do you have? your Backup strategy will change depending the type of replication.

For transactional check for the option 'sync with backup' in BOL. This will keep...

I had to do it once. I used he following commands, maybe they can help.

sp_resetstatus 'dbname'

dbcc dbrecover (dbname)

and DBCC Rebuild_log (dbaname) bacause my log was damaged.

With simple recovery mode, only full backups are possible.

When failure, you will have to restore the last full backup you have.

With system databases this is ok. I would suggest to...

If the server name is the same, then you can backup all your databases, and restore them in the new server.

Check the expired subscription period, because you might need to...

You can execute sp_who or sp_who2 with it is more complete.

Every time you need to imitate something EM does in T-SQL it is good to execute a trace with profiler,...

did you run a checkdb in database 'Iowa_Vet'?

Did it return any errors?

You can run sp_repladdcolumn to add a new

column of an already published table.

check the parameters in BOL, and allow NULLs in the new column.

What error is showing?

Is it server2 configured for remote access?

The Task Pad view starting failing in my EM after my DB was very big.

Now my db in 300 Gb and most of the cases EM shows me an error...

SQL server uses an error log file each time it reboots.

You can use a new error log file by executing sp_cycle_errorlog.