Hi Perry,

Thanks for the response. Yes. Checked it. The messages from error log have been posted on my first post.

There were Few replication failed jobs with the following error message.

Replication-Replication...

Folks,

I guess the post shd be filed under Administration. so posted it under admin section.

Any replies please specify on the thread below.

http://www.sqlservercentral.com/Forums/Topic1337718-1550-1.aspx

Are you able to see the same details using select * from sys.dm_os_performance_counters?

wiseman82 (2/28/2012)

---

Our production SQL Server 2005 instance has 256GB memory - We upgraded our database servers a while ago and went from 64GB to 256GB.

There isn't really anything different to...

Thanks for the response. But I am looking for first hand experience of folks who have had 256 GB RAM SQL Server. The case studies are mostly from microsoft site...

You mean on the sceondary you have disk level corruption on the log file?

if thats the case , make sure the storage errors are fixed and and then try to...

Elliott Whitlow (1/26/2012)

---

spenn6367 (1/26/2012)

---

arr.nagaraj (1/26/2012)

---

couldnt understand your question exactly.

On Node A you have Default instance ( VirtualServername1) and Node B you have named instnace (VirtualServername2\instancename). You want to...

couldnt understand your question exactly.

On Node A you have Default instance ( VirtualServername1) and Node B you have named instnace (VirtualServername2\instancename). You want to connect to Node B...

http://www.mssqltips.com/sqlservertip/1036/finding-and-troubleshooting-sql-server-deadlocks/

http://www.sql-server-performance.com/2006/deadlocks/

Can you provide us with Create table and insert table scripts. Makes it easier for us to help you better.

Do you have only one status per day? When you...

was there any new indexes created or a Re index maintainence job that ran today?

Any other known long open transaction?

Your errorlog should say

DBCC CHECKDB (<db name>) executed by sa found 0 errors and repaired 0 errors. Elapsed time: 0 hours 0 minutes 47 seconds.

Though I am not sure ,free space and fragmentation info should be present in Backup header.

Better expert will confirm 🙂

* Secondary server's service account losing read access on the shared folder on primary containg log backups.

* Breaking of log chain.. ( Changing recovery model, taking backup to different location,...

When you restore you want the exactly the same set up including the Filegrowth, free space available etc...Especially useful if you have allocated your DB a specific amount of space...