tanks a lot

i'm so confused

1:in simple recovery when i shrink log file to zero i cant see the logs in fn_dblog(null, null) but still apex can show the logs,what do...

Thanks

but it does not show large_page_allocations_kb and locked_page_allocations_kb

if they are available.

you should execute in this way :

Use FlexFamilyMembership

EXEC sp_resetstatus 'FlexFamilyMembership'

ALTER DATABASE FlexFamilyMembership SET EMERGENCY

DBCC checkdb ('FlexFamilyMembership')

ALTER DATABASE FlexFamilyMembership SET SINGLE_USER WITH ROLLBACK IMMEDIATE

DBCC CheckDB ('FlexFamilyMembership',REPAIR_ALLOW_DATA_LOSS)

ALTER DATABASE FlexFamilyMembership SET MULTI_USER

Gila and Lynn thanks a lot for your help.it was usefull.

thanks for your reply

so if the principal fails and we do a manual failover,i should do a forced service failover because the mirror database is now Disconnected and in Recovery...

After all of these ,finally i found the problem

I drop the port 5024 and create the new witness endpoint and set LISTENER_PORT =5025

also because i use windows workgroup my services in sql (for 3 instances_SQL Server (MSSQLSERVER) ) log on as local system

In my test server I installed 3 instances (SQLSERVER Interprise Edition 2008R2 _RTM):

MSSQLSERVER is my principal,its role in sys.database_mirroring_endpoints is PARTNER with the state STARTED and ENCRYPTION enabled.i have windows...

I got it.Thanks alot for your help.

Thank you GilaMonster,you are right.

I know each of them have their own databases

I mean can't we use the instances together?

what does it mean "only one server at a time...

Thank alot vinu512 for you help:-)

Thanks all for replies

You mean ad hoc query is a batch that can be executed for example from an application

or by sp_executesql ...?!!!!

Tanx so much

now i have a question

why the Total server memory in Performance monitor is less than physical_memory_in_use_kb in table sys.dm_os_process_memory.

my AWE is off and these tow are zero...

Tanx

Our data is so important and i dont want to loose any data

also i need online reporting

the primary database and standby are in one instance