I don't think dynamic AWE is support in SQL 2000, Why don't you upgrade to 2005 or 2008?

Here is the steps enable and set AWE memory

To enable AWE

sp_configure 'show...

"This dynamic AWE example does not apply to SQL Server 2000"

Try this, Check books online for more Info

sp_configure 'show advanced options', 1

RECONFIGURE

--To enable AWE

sp_configure 'awe enabled', 1

RECONFIGURE

GO

I agree with Linda, we have SQL instances on Virtuals in Test Environment for more than two years. We had problems with Virtuals Host failing which brings down...

I don't think you will be able to access data from another server using select statement without linked server connection. You can replicate the objects if you want copy of...

I had experienced same problem, fix was to put the database in emergency mode and extract all the data using SSIS package. Once you had detached database you lost...

Mismatch columns between publisher and subscriber can many reasons one of then could be schema changes at the subscriber. In Replication there is an option to allow schema changes at...

If you are using SSMS 2008 client, you can see all the objects details in Object Explorer details tab Including Row count, data size, Index size etc.

Enjoy!

Gail is correct, It is not best practice to move\restore system databases. If i understood correct you want the same objects on both servers correct? If thats the case...

Best practices is not to restore system databases, i have not seen in any environment DBA' s restoring system databases until and unless mandatory. Why are you trying to restore...

If cost is not constraint then Clustering is the best option for high availability, you have two options in clustering Active\Active and Active\Passive.

Active\Active: In any point in time both nodes...

You can verify the last backup file and last restore file by querying these table log_shipping_monitor_primary or log_shipping_monitor_secondary

on either one of the servers primary or secondary on msdb database....

Drop Index on destination table then rebuild index then load data, Rebuilding Index takes lesser time than defrag. If you want you can do rebuild index online...