In my opinion there is no reason to worry about indexes that are less than 500 or even 1000 pages. On several occasions I have seen that rebuilding an index...

This might sound lame but did you check the replication monitor and VIEW DETAILS of the subscriber? That should show the status of the replication and if it replicating any...

Not sure how you can reduce the time taken to rebuild the indexes. But have you configured fill_factor for those indexes such that they don't get fragmented quickly. It's always...

Take a look at the following link. I have explained how you can add new articles to the publication and avoid taking a snapshot of all the articles.

http://saveadba.blogspot.com/2011/08/adding-new-article-without-generating.html

If the performance had been good in the past then I would start with updating the statistics with full scan. And later rebuilding the indexes. You need to schedule these...

Take a look at the SQL Server Agent Error logs, SQL Server Error logs and the Windows Event viewer. Check for any relevant errors at the time when you tried...

If you want to test this then set up log shipping in a test environment and delete/move a log backup file from the primary server before it gets copied to...

When you check for existing users then I am assuming that you are looking at the list of users under SECURITY for that database.

In case you are concluding that...

First check the last file copied and restored to the secondary. Run the following queries on the secondary node.

The following query will give you the last log backup file...

Try running Process Explorer and see what process is holding the lock on those files.

http://technet.microsoft.com/en-us/sysinternals/bb896653

Not sure if running the job directly is the solution for the given error but if you want to avoid a new snapshot for all the articles then run the...

Few facts to remember.

1) Index rebuilds will cause significant logging and hence your log file will grow. Subsequently, the log backups will also grow. There is no way you can...

I use the following TSQL to run commands against all databases. Change the SELECT statement to select the databases you need.

Take a look at this script but do not run...

There are several reasons that could lead to this error. From your post it does not look like you are using a double hop to connect to the instance.

hopefully,...

Take a look at Perfmon counter 'Memory\Available MBytes' to find how much memory is free on the system. It is nice to have at least 1 GB of free memory...