yes it would fail as the lsns would be out of synch.

there is nothing you can do to avoid this if you have to restore your primary database

in the error log at startup does it say

Set AWE Enabled to 1 in the configuration parameters to allow use of more memory.

or

Address Windowing Extensions is enabled. This is an...

nothing comes to mind. Did checkdb come up clean?

use DMF sys_dm_io_virtual_file_stats, it will give you info on IO activity per database file. good for seeing where the load is.

this replaced fn_virtualfilestats() in SQL2000, which still works though.

Interesting. the two types we have used, EMC and IBM, the drives themselves are not visible on the server. Hence no need to license.

I take it your database are read...

the databases are inaccesible with SAN mirroring also. You don't need to license this server as it is purely for failover.

reindexing operations can cause this behaviour. Be warned if you switch to full recovery mode whatever the process was will no longer be minimally logged, so you will end up...

the two types of (synchronous) SAN mirroring I have done the disks are not visible on the passive server, so I do not see how this would work.

you should probably...

the disadvantage of installing on different servers (other than cost) is the network traffic.

In these days of 64bit and multi GB RAM keeping them together makes more and more sense...

for the benefit of others who might get the same problem ,how?

All new databases are created from the model database, so you would add these objects to model.

As for the data, seems a bit of a silly question to me. If...

presuming all else has been done as described above to get SQL to us it after you enable the AWE sp_configure option use

reconfigure with override

not just reconfigure

then bounce SQL

no, they are not mutually exclusive.

giving db_owner + all others or sa + all others does no harm in itself so I guess MS see no need to protect people...

oops, sorry missed the part about the native backup.

Still run a DBCC, it will highlight any problems in the log file.

so the log must be full and growing?

correct on both counts