check how long you are keeping the tran log backups for on the primary. All I can think of if you get an out of synch error after not restoring...

well, presuming you are using...

is the server backup using a SQL agent that backs up the SQL database. This could cause a gap in the log chain if it was a log backup. Check...

colin, you sure? Even if this is so surely...

ddonck (6/12/2008)

---

And one last update. Since I couldn't find a way to rename the local connection I decided to start fresh and delete the existing Maintenance Plans. That failed due...

right click on dts package and select 'schedule package'. this creates a sqlagent job which runs the package.

no probs.

From BOL:

To modify the logical name of a data file or log file, specify in NAME the logical file name to be renamed, and specify for NEWNAME the new logical...

If EM does not work and you are sure filenames are correct, it is always worth a try via query analyser

'alter database dbname set read_write'

according to your first post you were getting these errors with log limited to 10GB. looks like for now if you have the disk space you will have to turn...

my fault, i added an incorrect post about using dateadd function which i deleted. unfortunately sunshine has already tried it, hence spurious post about missing ')'

please ignore that post.

the cumulative post SP4 hotfix rollup you want is HF2187. containf the AWE fix.

MArios, hot add memory proviso useful to know, thanks.

thats the trouble, the playing field keeps changing........

sotn (6/4/2008)

---

I am still confused as to how can a 32-bit application reference above 2GB without AWE 32 as the /3GB switch just tells the O/S not to use it...

sotn (6/4/2008)

---

Sorry I don't think I stressed the specific understanding issue properly, I meant that for a 32-bit app to access more than 2GB does it require AWE to be...