Check the percent_complete column in sys.dm_exec_requests. I think that restore is one of the operations that populates it.

GSquared (11/25/2009)

---

Frequently. Often associated with strikes and demonstrations.

Never had a local power outage due to a thunderstorm or some idiot drunk-driving a...

Alvin Ramard (11/25/2009)

---

I have no clue as to...

http://msdn.microsoft.com/en-us/library/cc280362.aspx

Alvin Ramard (11/25/2009)

---

........ and the winner is ... (drum roll) ... Oh,...

Atul DBA (11/25/2009)

---

My suggestion for reconfiguring the mirror was based on db size of 200 MB and Log size of 2 GB which is not good sign. Even it was...

No points from me for that. That...

Jy ook? So baie mense van Suid-Afrika op hierdie forums.

The only natural disaster we know of so far...

btw, I used to work with a DBA team that managed a mission critical stock market trading system. We had a windows cluster, the SAN mirrored to a secondary site...

Ok, I vote this as one of the more ... 'questionable' recommendations I've read here recently.

As your log file is very huge, and it is required to Truncate the log...

roelofsleroux (11/25/2009)

---

Gila the reason we use mirrors is because this is for a stock exchange trading application.

If the database fails for some reason, the mirror kick in. If there is...

So do some tests (in a dev or test environment), see how queries perform,...

Please post SQL 2000-related questions in the SQL 2000 forums in the future. If you post in the 2005 forums, you're very likely to get 2005-specific solutions.

Jack_Thiru from chennai (11/25/2009)

---

If this is correct then security is not there for passwords, if i know a user i can directly login using windows authentication and reset passwords as...

Atul DBA (11/25/2009)

---

As your log file is very huge, and it is required to Truncate the log file for proper utilization of disk space, you need to stop the Mirroring...