But what if the databse doesnot start due to some reason.. how to find the reason & where to fin the information :w00t:

Hey Thanks Vivek, Even i know the answers.. but wanted to verify...

Anyways for the question

1) You want to implement the lowest level...

GilaMonster (10/16/2012)

---

Database mirroring doesn't impact performance (implemented correctly).

As for whatever questions were deleted, those look like homework or test questions. How about trying them yourself, you don't learn anything...

Hi Paul,

thanks for providing the answer 🙂

Currently we have 5 servers...

For example..

1 server have 20 databases almost 20GB each.. now the tempdb files & user datafiles & log files is...

Perry where r u???? 🙁

Say na what will happen if we do implement this???

What is the use of doing this???????

i wanna send email to my seniors so that they can...

Thanks Chandan.. i got it !!! 🙂

Hi Chandan,

Can you explain more on what should we recommend in normal scenario???

Thanks Paul 😉

Perrry if you have documented it.. please attach na;-)

Perry Whittle (10/8/2012)

---

Yes I...

Perry Whittle (10/8/2012)

---

Hi, yes my tasks around this have been...

Hi Satish can...

Hi Perry Whittle,

Did you goyt any chance to perform this at your end???:-)

I am still waiting for the approval :w00t:

Sure Gila, Thanks 🙂

But then if truncation of log is not to be done then what should i answer this???

Like i will be asked that why...

Gila please verify below Steps...

1) Rebuild Indexes.. (Does this is necessary to be done evry day?)

2) Backup & Truncate log (Is this correct?)

3) EXEC sp_updatestats (What abt this?) :w00t: