see http://support.microsoft.com/kb/321185

you are on SP2.

SP3 is now out, you dont 'need ' to install it if you have no problems, but I would look to be installing SP3 in order...

then I think I was on the wrong track Lynn, it just sounded simialar to an error I had a while back.

sorry.

Lynn Pettis (12/19/2008)

---

george sibbald (12/19/2008)

---

Lynn, its a long shot, but I had a windows SP2 install fail because it could not find a .msp file, and that was a...

Lynn, its a long shot, but I had a windows SP2 install fail because it could not find a .msp file, and that was a permissions issue to the...

seeing as borgs have come up and various other androids, amazed no-one hes voted for seven of nine!

..and I should have said thanks for sharing. 🙂

good script and most useful for DR purposes wesley. good timing as well, I have a script to reverse engineer sp_attach_db statements, but expecting some database with more than 16...

my pleasure.

error 33 is 'The process cannot access the file because another process has locked a portion

of the file.'

do you have some other process that copies the backup of your USB...

join to the sysobjects table, sytem tables have an XTYPE = 'S'

you could query the sysprocesses table, if there were any backups running the column 'cmd' would have an entry of 'backup database'

thanks for the feedback

Of course the version of SQL is recorded in the errorlog at startup, and in the event of an instance crash these logs will likely still be there.

Just in case...

Info on how system dbs handle recovery modes here:

http://technet.microsoft.com/en-us/library/ms365937(SQL.90).aspx

so you should be able to have msdb in full mode so you have some other problem there, possibly no full backup...

so quick question is................why is it possible to put the dbs in full mode? Is the space used in the logs growing? Or is checkpoint still in fact clearing them...