Are you using Expresse Edition? I believe it wont be there.

See this posting.

http://sqlblog.com/blogs/louis_davidson/archive/2007/08/26/sys-dm-db-index-operational-stats.aspx

Did you try to kill restore log operation? It may take time to "rollback" this restore if log backup has large number of transactin. You need to wait until your...

+

Log shipping will not use any Port. Sql Agent will copy t-log backup files from folder to folder. This is one way of communication between two server unless you configure...

Mirrored database can't be accessed at any time. You need to take a Snapshot of mirrored database, then you can query the snapshot (Snapshot option is in only Enterprise Edition).

Also...

DDL Triggers can help you.

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

Create Trigger Deny_db_datareader

on Database

for ADD_ROLE_MEMBER

as

begin

SELECT 1 where EVENTDATA().value

('(/EVENT_INSTANCE/TSQLCommand/CommandText)[1]','nvarchar(max)') Like '%sp_addrolemember%db_datareader%'

If @@ROWCOUNT <> 0

Begin

Print ...

Did You change sql agent service account? If so, check if that account has permission on Bin folder.

[Is their any difference in clustering -- performance, setup admin etc between having a 2 Node Cluster using SQL 2008 Std edition or SQL 2008 Enterprise edition.]

Yes."Fast Recovery" in Enterprise...

Which Sql Version do you have? If you do not use Backup Compression, below query can help to calculate backup size (approximately 90%)

-- Data Size

Declare @dataSize Float

Select @dataSize=...

I would recommend Robocopy or Xcopy cmd utilities.

Also check this url. http://blogs.msdn.com/b/granth/archive/2010/05/10/how-to-copy-very-large-files-across-a-slow-or-unreliable-network.aspx

http://www.mssqltips.com/sqlservertip/2682/recover-access-to-a-sql-server-instance/

Also, Don't you have any other windows account with sa privileges?

Try with dm_db_Session_space_usage.

http://msdn.microsoft.com/en-us/library/ms187938.aspx

"Page counters are initialized to zero (0) at the start of a session. The counters track the total number of pages that have been allocated or deallocated for...

]

Hagen, Can...

Endpoints are started in both principal and mirror. ?