Need more intfo on the table

regards

Hi

You can try log shipping  and set you logs to execute on a hourly basis

regards

wayne

The distribution database will hold the transactions until the subscriber has received it and will not remove it from the distibution database , your distibution database will get larger with...

The maintenance plan does the dbreindex and everything else , Auto-update statustics should be set on the database level settings , your can exeute sp_updatestats on the database , this...

It sound like you are trying to do minor repair on system tables with the maintenance plan

It does require a single user mode to do system tables

regards

wayne

The backup file contains everything in the database , it does not contain the logins

Yes it can be restored onto another sql server , script out the login , jobs...

Start up your mssql , sqlserveragent service accounts with a network account

and add the network account to local admins

regards

wayne

Hi

You can try and replicate the one table , Not sure if the table structure is the same

or  you can use a query to insert the data where not...

If the option AWE is enabled . Do you still need to enable it in the boot.ini file

It worked the memory for sql has increased  to 3.1 gigs on sql through performance monitor