You need export data and import them into database with correct collation.

You may need to configure SQL Agent Proxy account that has permissios to run your batch job.

Look into "Log Shipping" and "Transactional Replication" in BOL. Both solution will allow you to refresh the changes only from your production database to the reporting database.

I don't see indexes rebuild before you perform business logic sp to generate summary data. You will perform table scan mostly since indexes have been dropped at step3.

What did you get after running the command? Look at both SQL Server errorlog and eventlogs to see what is the cause.

I don't know and I doubt the existence of such tools for SQL Server. I would like to know too.

SELECT * from yourtable where DATEDIFF(day, yourdatetimecolum , getdate()) <= 365

We have BMC Patrol but never heard it can report memory usage per database.

Is this backup process created by maintenance wizard? If it was, go to server task manager, find the sqlmaint.exe and kill it.

Could it be blocked? Run sp_who2 to verify that.

I would verify whether the performance decrease was caused by the backup.

You may consider to perform full database on weekly basis and do the differential backups for the rest days....

http://support.microsoft.com/default.aspx?scid=kb;en-us;810885&Product=sql2k

http://support.microsoft.com/default.aspx?scid=kb;en-us;816840&Product=sql2k

http://support.microsoft.com/default.aspx?scid=kb;en-us;815056&Product=sql2k

http://support.microsoft.com/default.aspx?scid=kb;en-us;815436&Product=sql2k

Edited by - allen_cui on 12/12/2003 4:59:28 PM

Thaks, Brian.

The web app will authenticat the user, pass the credentials through Basic authentication and users are not allowed anonymous access. We like to use one generic id to access database...

823 Error messages usually imply on disk corruption most typically

arising from problems at a level below the operating system (e.g.

Hardware component failure, bad/outdated device driver, or external

failure such as an...