Also you can rebuild the indexes which are poor i.e. run dbcc showcontig and if Scan Density is below 80% reindex.

Thus you can save time as well as reduce burden...

I guess hosted team is still under impression that Microsoft OS needs reboot at a specific period.

The fact is those days are gone. I also used to reboot the server...

You can use profiler if you do not have any third-party tool.

Capture the live data with the help of profiler during peak hrs and re-run the same into test environment...

Yes, You are verymuch correct Silverfox.

Hello Sarvesh,

If your database is not on production or if you can manage little downtime on weekend. I suggest detach and attach would be better option to move your data...

Silverfox

Thank you for understanding.

----------------------------

Give Respect & Earn Respect

Silverfox

This is with reference to doubt of k.przewozniak that...

"I wonder if everything is fine with this server... "

Can you please tell me how you can find out if everything...

To make sure every thing is fine run

dbcc checkdb (msdb)

Hello Krishna,

You can ask you vendor to have brief technical session. You just than download the trial version and test thoroughly into your test environment before going further.

HTH

check the service account password.

All these Int. questions are very tricky and having multiple answers. It's all about matching the wavelength with the interviewrs. There are many int. I have faced in which I...

use this command to start sql server from command prompt:

for default instance:

sqlservr.exe -m

for named instance:

sqlservr.exe -m -s <instancename>

HTH

Try... sp_monitor

San,

There are multiple way of doing the same things...

You can easily delete the unwanted database.

Refer following link for Physical design of DB.

http://download.microsoft.com/download/4/7/a/47a548b9-249e-484c-abd7-29f31282b04d/PhysDBStor.doc

If you do have only one application with one sql instance Active - Active will not be possible. You can go with Active...