Until and unless the transaction logs are not truncated, it will work fine because log reader agent works by monitoring the transaction log of each database configured for transactional replication...

very good information :-

http://www.brentozar.com/archive/2012/08/sql-server-dba-interview-qa-part-answers/

We are running SQL Server 2008 R2 and I am putting my case together to move to SQL Servre 2012 in from of management. We are 24*7 SaaS company and...

Are you trying to restore on a top of database which already exists?

If yes then use:-

Alter database <DBNAme> set offline with rollback immediate

go

alter database <DBNAme>set online

go

restore command

Covert them into datetime & compare.

Look into Distributor's sql agent jobs.

What kind of answer it is? He is asking for permission required to create Transactional replication.

Only members of the sysadmin fixed server role can set this up from end...

Use Activity monitor to see what is going on when you see CPU jumped to 96%.

Also I would recommend using Adam Machanic sp_whoisactive, to see what is going on.

You can...

There is very excellent blog post by Kendra Little @brentozar.com

See if that could help.

http://www.brentozar.com/archive/2012/03/how-decide-if-should-use-table-partitioning/

SELECT sysjobhistory.server,sysjobs.name AS job_name,

CASE sysjobhistory.run_status

WHEN 0 THEN 'Failed'

...

If you post table script and script to insert some sample data that will be very helpful.

I am using office 2010 and it works fine for me.

Below are all the steps you have to do.

1)

EXEC sp_changepublication

@publication = 'PublicationName',

@property = N'allow_anonymous',

@value = 'false'

GO

EXEC sp_changepublication

@publication = 'PublicationName',

@property = N'immediate_sync',

@value = 'false'

GO

2) Add table to publication :-

exec dbo.sp_addarticle...

Try using sp_msforeachdb.

Could you please post the exact error which you are getting?