I guess nakarjun ask the way to retreive server configurations.If so, sys.configurations can be used for server level settings.

Thank you for your timely reply. I will have a note of these steps.

If I understood correctly, we are going to avoid false alert from 5pm to 7am by raising threshold value. Then, we will not be notified of actual lag in normal...

Use dbname

Go

Select count(Total_pages), count(used_pages) , sum( total_pages* 8) TotalPagesKb, sum(used_pages * 8 ) Usedpageskb from sys.allocation_units

I am not sure above query will help you 100%, but you...

By default, sqlcmd should be installed along with engine. Can you check sqlcmd.exe is there in

'......\Microsoft SQL Server\100\Tools\Binn' folder?

Check Event viewer for any error logs.

I had a problem like this once because of password expiration of AD account. Resetting Service account's password worked.

Truncate and insert????? then why we cant go for BCP? Will it not be faster?

Do you mean to move you mirrored Database to new server without breaking up mirroring session?

It is not possible without breaking mirror. If you can get downtime, break the mirror...

you can add another node. It should work. But you should make sure your third node can handle your sql instance(s) in case of failover.

One more note. By default , DAC uses 1434 port.

"However, if I set a non-default port, say 1638, for my SQL server to listen over, do I need the SQL Browser to listen for incoming requests, so it can...

Shrinking Log file is not recommended until you run out of drive space. If your disk can hold 60GB log file, you can leave as of now.

Also when the pruning...

If Mirror went down or unavailable, Principal will be running 'exposed',it means it can serve the application and accept transactions, but principal cant send trns to mirror. So down side...

From Sql Server 2008 Sp1, we can uninstall updates through 'Add or Remove Programme'. Before uninstall, better take backup of all databases.

After Restore verifyonly, its recommended to restore the database and run a checkdb to ensure no IO-related corruptions are there.

I would like to get some inputs on Restoreverifyonly from you...