I saw it once in one of my servers, but checkdb didn't report any errors.

The server and the db worked without any problems.

Later I had ro reinstall SQL and it...

If your databases is being published you won't be able to do it even with sp_renamedb.

Not that I know. Unless you include first the columns that you need to copy in the select clause, so they are all contiguous.

Well that could be the origin of the problem...Hope it won't happend again.

Stop the server and restarted with sqlservr.exe from the command line, and post here anything unusual you find.

With backups for transactional replication you should consider using the sync with backup option sync with backup.

Execute sp_replicationdboption '<publicationdatabasename>', 'sync with backup', 'true'.

you can read more in BOL

Not sure where does it save the traces, but I guess that is actually saves it in the file, even the file has a size of 0.

What I'm sure that...

First run the log reader agent with the logread.exe from the command line, with parameter OutPutVerboseLevel equal to 2 to find out what is really happening. then post the error...

In EM it is possible that the subscriptions appears like running even if they doesn't exists anymore.

Run sp_dropsubscription or sp_droppullsubscription to completely erase the subscription.

If found that error in my publishers tipically when a subscribe a server with applying the snapshot. I mean @sync_type = 'none'.

I read somewhere that it is a...

Check the SQL log to find out since when it is happening and what was executing before the error.

Check also the event viewer for windows errors at the same time...

Or also can try this:

declare @db_nam varchar(40)

set @db_nam = 'newdb.dbo.'

EXEC ('select name from ' + @db_nam + 'namelist order by name ')

In wich won't matter the db name.

You can map the netword drive of the remote server from within SQL by using xp_cmdshell.

Do

exec master.dbo.xp_cmdshell 'NET USE X: \\Rem_Server\Remote_Path LoginPassword /User:Domain\user'

Then you can restore from that path...

Yes, you must select to create indexes on subscribers. With EM, in the publication properties and in the list of article, click in the button next to each article and...

I Would use transactional, running the distribution agent by every hour, using only delete stored procedures. And using a retention period long enough to keep the transactions in publisher until...