Restore the backup file to a newly created database.On this database, go to the table you

want to restore and transfer the contents of that table into the database you...

You could refer to below link.

http://www.sqlmag.com/blogs/SQLServerQuestionsAnswered/SQLServerQuestionsAnswered/tabid/1977/entryid/72340/Should-I-Index-My-Foreign-Key-Columns.aspx

It is a repeated quested. Question was posted previously on Jan 24,2011.

This link is quite useful

http://www.brentozar.com/best-sql-server-dba-books/

Sure Craig, I got to know something 🙂

Can you post the contents of the ERRORLOG.

Also, verify if the SQL Services are running.

Go to

Start-> All Programs-> Microsoft SQL Server 2008 R2-> Configuration Tools-> SQL Server Services->

Check SQL...

I hope you are connecting to correct instance. Did you configure the default instance or named.

To confirm on this, you could navigate to below folder path

C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log...

Thank you.

Thanks for introducing new topic. I had not heard about it before

Craig,

I checked with one ex Microsoft employee. He says the product license is permanent but the product support would be renewed on yearly basis.

Thanks for the question, but I was unable to post this update as I encountered application error for close to 2 hours 🙂

Thanks for the question. Remember reading about it few years back.

Also, make sure to perform the same steps to the snapshot agent job on the publisher if it is enabled or scheduled to run by any chance.

How many number of subscribers are you doing to add if any?

You could test accordingly.

You could stop the relevant agent jobs on the publisher instance.

As this is transactional replication, better to stop and disable the below jobs on publisher.

-> Log reader job

-> Distribution job

After...