Hello,

I haven't worked with servers >2gb yet.

But found a great link about how sql server deals with memory:

http://sqljunkies.com/Tutorial/0D4FF40A-695C-4327-A41B-F9F2FE2D58F6.scuk

So my questions are:

1. Does the quoted advice above mean I should...

Are the database files excluded from the antivirusscanner?

BACKUP DATABASE testdb

TO DISK='\\ServerB\Backup\ServerA\testdb.bak'

*Make sure the executor (sql agent) has enough permissions on the disk

*Try to restore at least one backup. We had issues with windows 2003 without servicepack &...

Quite a coincidence, I went to a Oracle 11g launch presentation today.

you're welcome

sql-server-performance has a nice list of articles for setting a baseline / performance

http://www.sql-server-performance.com/articles/audit/main.aspx

Buffer cache hit ration 99% -> OK no more memory is needed, otherwise the cache wouldn't maintain 99%...

Do you have a backup of msdb?

There was an I/O error in the past that caused the torn page

Torn_page_detection:

This recovery option allows SQL Server to detect incomplete I/O operations caused...

*the @@Servername could still point to an older name, it doesn't autoadjust to the wins name.

at http://www.databasejournal.com/scripts/article.php/1496451

you can find a script that resets it to its wins name

sp_dropserver ...

sp_addserver ...

restart

*depending...

If you rightclick on the job in enterprise manager and choose properties, there is a tab "Notifications" (usually the last one)

There you can set up "alerts" when the job completes...

Trez,

Have you rechecked the odbc-connection?

Other things to check:

*select @@SERVERNAME /*internal name of server*/

*change the password/account used by the software account to connect to the development server (shouldn't hinder production).

*Is there...

You can check this with sql Enterprise Manager usually.

Management->SQL Agent->Jobs->right-click show job history

Additional information can be found in the main sql server logs

Management->SQL Server logs

I have a small issue digesting the post

Situation before:

1 Production server A (reel or virtual)

Situation in between

Cloned A to create developserver B (vm)

Current situation

Prod A reel

Dev B virtual

Do A &...

1) Check the sql server logs/windows log on a more detailed info.

2) Is the windows 2003 patched (service pack 2 seems to be current)

3) Are there any issues on the...

What is the foreign key FK_tb_vessellic_vsl_fsh_tb_lkpports_prt_fsh2?

How does @ID get filled in, I only see @IDINT

there is a new hotfix rollup

http://www.microsoft.com/downloads/details.aspx?FamilyID=9c9ab140-bdee-44df-b7a3-e6849297754a&DisplayLang=en

build 2187