Fragmentation issues, performance issues, stability issues...

Is your t-log continuing to grow or is it staying the same size? Have you looked at hos much space is actually occupied? ...

Shrinking files is a Bad Idea. If you are doing regular backups of your transaction log, then the size that it is at is the size it should remain....

Are you running t-log backups? If not your transaction log will continue to grow.

I've never run a log shrink action on a mirrored DB. However, I have had...

Unless there's some obscure trick out there for doing so, no.

See these articles in BOL:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/a1d0693f-6784-4d1e-b1e4-074a5e56769b.htm

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/32abdbce-df5b-492a-b65d-5a9cc06e8497.htm

Is it possible he's talking about a SAN snapshot? That would be a different story...

Off the top of my head...

Disaster recovery - do you have a workable one and is it functioning properly

Performance - are there performance bottlenecks? what are they?

Is the DB...

Sure you can. You can do pretty much anything to the DB while it's being mirrored. The only exception I've found is removal of files / filegroups.

One caution:...

Well, for one thing, you should never do anything to the t-log other than to back it up.

SQL Server is smart enough to keep track of what transactions...

The information in the t-log is what is used to keep the mirror up to date. Yes, you need to run t-log backups on the Principal.

The only "maintenance" you...

If you don't have a backup, you'll have to rebuild it. Search BOL for how to.

A cachestore flush should not be preventing the move.

Have a look at this for some more info:

http://blogs.msdn.com/sqlprogrammability/archive/2007/01/19/12-0-plan-cache-trace-events-and-performance-counters.aspx

I did a really quick msdn search for you and found this:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2673397&SiteID=1

If you choose...

What is the error you're getting?

I actually reported a bug on this feature which, last time I checked, had not yet been resolved. The problem is (was?) that it...

I can tell you this from my own experience. DAS is NOT a practical solution at all for a database that size.

Oh man you guys are bringing back fond memories. I used to be a Delphi developer. I made the switch over to a DBA focus during the time...

I'm currently doing the job interview rounds. One of the places I interviewed at is doing the exact opposite. Everything is in T-SQL except the very front presentation...

These days I use Performance Dashboard and my own home-grown scripts for monitoring (they're free and portable). However, I've used Idera's Diagnostic Manager in the past with great success.