Glad to hear that helped!

Read section 14.2 and 14.3 in this link - http://msdn.microsoft.com/en-us/library/ff647793.aspx

Also may want to check out THIS ARTICLE[/url] from this site.

As long as you got the bribe thing working you'll go far.

I didn't drink dew either Lynn but donuts, that was another thing. Had to forgo those now too...

Read that. I have to admit that amount of data makes my mind whirl a bit. :hehe:

Please refer to this thread or the MS thread linked in the thread. http://www.sqlservercentral.com/Forums/Topic332967-146-1.aspx#bm333212

Additionally, you are using SATA disk which are not going to perform as well. I would be interested to know what the RAID configuration is still. As Lynn suggested it...

Also - you didn't answer Robert's earlier question - "Backup of other databases running simultaneously?" - or I missed the answer. Can you also tell us how the drive is...

Completely agree! We use...

The rollback immediate will take care of killing those connections. There is a note in the documentation about ensuring that AUTO_UPDATE_STATISTICS_ASYNC is off as that can take priority and getting...

Sorry about that.

So, you would have to use the alter database set single_user with rollback immediate, make the name change and then change it back to multiple user.

I would...

Same reply as on #sqlhelp:

Have you tried dropping and re-adding the linked server? I hope that doesn't fix it but it would be the next step that I would try.

Yes, my company sees it as critical for both HA and DR.

We use a combination of technologies which include clustering and scaled out replication for HA and other technologies...

Sorry for the slow reply on this. To explain further, if you look in the delete stored procedure on the subscriber (refer to previous poster information on procedure naming convention)...

This has been pretty well answered but wanted to add one point on the delete procedures. You can actually modify those and comment out the error handling. That will allow...

+1