Lynn Pettis (2/18/2010)

---

GilaMonster (2/18/2010)

---

GT-897544 (2/18/2010)

---

2) If so go head and bring one database offline and then bring online that should work, if database come online clean, recycle SQL services,...

GilaMonster (2/18/2010)

---

GT-897544 (2/18/2010)

---

2) If so go head and bring one database offline and then bring online that should work, if database come online clean, recycle SQL services, should fix...

If that is the status values for suspect databases. Looks like it is a clean shut down, no corrupt files.

1) Do...

What do you see if you open databases from SQL 2000 client\box itself? do you see them as suspect mode?

EnjoY!

OP mentioned in the Note, When OP tried to refresh databases list OP receiving .NET error message...

Are they in suspect mode?

EnjoY!

Diane Rayzer (2/16/2010)

---

Hi Everyone,

I'm wanting to do something similar in SQL 2005. From Server A (in the network) I want to connect to Server B (in it's own DMZ);...

Yes\No, because it is very rare you restore system databases, but no harm in taking system databases as they take little space. Include them in maintenance job.

EnjoY!

What is the error message?

EnjoY!

Lynn Pettis (2/17/2010)

---

GT-897544 (2/17/2010)

---

If failure was at I\O SAN controller level, Server Team had already told you before you go to check SQl server error logs that it is hardware...

J.O. (2/17/2010)

---

Been doing alot of reading, and I know its not the same for everyone depending on server configuration, users, database size, etc. but had a question on RAID configuration...

GSquared (2/17/2010)

---

GT-897544 (2/16/2010)

---

GSquared (2/16/2010)

---

GT-897544 (2/16/2010)

---

Elliott W (2/16/2010)

---

This whole post makes me laugh..

Basic Troubleshooting 101:

1. Find out WHY you have the problem in the first place

It is clear that GT-897544 has...

It depends on the activity, check this out.

To answer your question, yes it will hold lock on the objects commit is issued.

http://www.sql-server-performance.com/tips/transactional_replication_p2.aspx

EnjoY!

richard-730095 (10/12/2009)

---

Hello all,

I've been trying for days now to get my new SQL Server x64 Enterprise cluster online in an active / active configuration.

In the end, this is going...

Doesn't matter if you have 2 node or 4 node cluster if disk fails. Clustering helps only if you have node failure like windows. If you want to achieve high...