Mirroring different versions

I am looking into Mirroring versus Replication. When going over the SQL2005
version features it list Mirroring (Safety Full Only). Does this mean the
database has to be in Full Recovery mode or that the mirror has to be
synchronous?
Thanks,
It means yes to both. With other editions of SQL Server 2005 (ie Enterprise
Edition) you have other options for mirroring, ie High Performance.
http://www.zetainteractive.com - Shift Happens!
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Cindy" <Cindy@.discussions.microsoft.com> wrote in message
news:9CC6F9E4-41F0-4F7F-AC52-09E74ED88B9A@.microsoft.com...
>I am looking into Mirroring versus Replication. When going over the
>SQL2005
> version features it list Mirroring (Safety Full Only). Does this mean the
> database has to be in Full Recovery mode or that the mirror has to be
> synchronous?
> Thanks,

Mimic DBCC Memusage

Does anyone have a routine that returns results like DBCC MEMUSAGE used to return in older versions of SQL Server?

I think sys.dm_os_buffer_descriptors gets you close. Books Online shows a query that assembles some of the data you are looking for. I've modified this to be a bit more user-friendly.

Hope this helps,
Bryan

Code Snippet

SELECT

x.name,

obj.name as [object_name],

index_id,

count(*)AS cached_pages_count,

is_modified

FROMsys.dm_os_buffer_descriptorsAS bd

INNERJOIN

(

SELECTobject_name(object_id)ASname

,index_id ,allocation_unit_id

FROMsys.allocation_unitsAS au

INNERJOINsys.partitionsAS p

ON au.container_id = p.hobt_id

AND(au.type = 1 OR au.type = 3)

UNION ALL

SELECTobject_name(object_id)ASname

,index_id, allocation_unit_id

FROMsys.allocation_unitsAS au

INNERJOINsys.partitionsAS p

ON au.container_id = p.hobt_id

AND au.type = 2

)AS obj

ON bd.allocation_unit_id = obj.allocation_unit_id

innerjoinsys.databases x

on bd.database_id=x.database_id

GROUPBY x.name, obj.name,index_id, is_modified

ORDERBY 1, 2, 3, 5

|||

Thanks, Bryan. This is similar to what I presently have, but it might fix the problems; hang on and I'll give this a try.

This looks pretty good; thank you.