SanjayAttray (8/21/2009)

---

If you already had 2005 certification then most probably just write one paper 70-453 and you get MCIPT. In Database Administration though, which I cleared last year.

I am...

Great discussion... !!! Folks, I really appreciate all the feedback and the ideas... this is how you learn when you write and share 🙂

One thing I am not sure -...

Hi Grasshopper, the techniques I mentiopned in the article can...

nitin1353 (7/21/2009)

---

Hi, Excellent article

I am working in a big environment where we have a Monitoring DB on each instance but i am still confused how do we set that up.

Can...

One thing I forgot to mention above is that whatever the findings, one should always DOCUMENT them, preferably in a consistently formed list of documents and make those documentations VERY...

Although this article is about what a developer should do when s/he inherits a database instead of a DBA should do, here are few more things I would suggest:

Health and...

rms (5/21/2009)

---

Hello Sadequl,

Thanks for your response, since i originally installed reporting services with the database instance, it was patched to SP2 - it's not patched now because i have un-installed...

Krishna Potlakayala (5/21/2009)

---

Sadequl Hussain (5/20/2009)

---

Okay, I am posting this again:

Problem:

A database exists in a SQL Server instance with an application regularly posting large volumes of data in it. The...

rms (5/20/2009)

---

Hello all,

I'm not that knowledgeable with SQL reporting services so I'm hoping my problem will be easy to resolve.

On a server running SQL Server 2005 SP2 32bit (windows server...

Lynn Pettis (5/20/2009)

---

If this triggers and you still eventually hit 90% full on your transaction log, you know that there is a definite problem somewhere with your application and open...

RPSql (5/20/2009)

---

Here's some more informaiton.

1.Database is in full recovery mode and we are using database mirroring on it. We are doing nightly full backup and hourly trans backups.after each trans...

Okay, I am posting this again:

Problem:

A database exists in a SQL Server instance with an application regularly posting large volumes of data in it. The database log (and presumably...

Krishna Potlakayala (5/20/2009)

---

Sadequl Hussain (5/19/2009)

---

Krishna Potlakayala (5/19/2009)

---

Sadequl,

I am afraid these ARE options. At least better than stopping SQL Server.

On what basis you say that?

Well, I would be saying this because...

Krishna Potlakayala (5/19/2009)

---

Sadequl,

On what basis you say that?

Well, I would be saying this because in my viewpoint,...

Krishna Potlakayala (5/18/2009)

---

Sadequl Hussain (5/16/2009)

---

Instead of stopping SQL Server, there are other options you can take.

Before the next run of the data run (that increases the log file to fill...