is the 15GB log growth the size of the physical log or actual space used, you should use dbcc sqlperf(logspace) to tell you how much actual logspace is used...

look for evidence log backups or log truncations are happening outside of your logshipping set up. All backups are recorded in the errorlog to so look through that around the...

:blush:

JoeA (2/6/2009)

---

Is it possible that your Ctrl+Shift+M is being caught by another program?

I had this issue with a similar key sequence where an HP diagnostic (or update manager?) was catching...

have you tried - sp_help_jobactivity @job_name = 'name of your job'

- one of a series in how to skin a cat

track down the spid the job is running under using sp_who2 or activity monitor. Check the login_time and last_batch time from master.sysprocesses table.

that'll work! cheers andy.

A useful feature I'd forgotten all about, thanks. Now how am i going to remember ctrl-shift-m?

if you only have 2gb memory on the server no point configuring it to use AWE

the patch you mention is SP4 but for MSDE, this is not what you want...

what Ed just said, seconded.

with the addition of place the system dbs where you want them as part of the install process, then you don't have to worry about the...

that tells you HOW to do it, but we still recommend you don't,...

why?

cheers Ed. Thanks for the clarification. I was wondering about naming convention because all references to copying CDs I found referred to calling the folders servers and tools, and I...

Hey Ed, thought you would turn up here eventually.................on the subject of system dbs and installs I would be interested in your views on this (my last post in thread).....

er.....hyperlink...

Jen Hutchinson (2/3/2009)

---

We did just try another restore but we'd get the message that the database was in single user mode due to an in-progress recovery! So you are...