Thanks Luke. I changed the value in the registrty to 2 and have managed to now login! I have since discovered that a 3rd party app that accesses the SQL...

Sorry - it would have been mixed mode as well. I did log into Query Analyser to check the version number after the SP$ install so I must have been...

THE AD Accounts were members of SysAdmin within SQL Server.

The issue I had was that the maintenance plan was not reducing the data file size. So I assumed the free space was being removed, but the file size was...

Thanks for the reply.

I agree, if the Deny checkbox is ticked the permissions are still associated with that login, as the Login still retains its permissions after being disabled!

Apologies. Here's the XML:

&ltNewDataSet&lt

&ltFormData&lt

&ltRequestTypeID&lt1005&lt/RequestTypeID&lt

&ltRequestTypeText&ltAdditional Bin Request&lt/RequestTypeText&lt

&ltFormVersion&lt1.0.0&lt/FormVersion&lt

&ltNotes&ltPLEASE DELIVER AN ADDITIONAL GREY TO THE...

Thanks you for all your replies.

I have also been experimenting...

I created:

Full1.Bak

Tran1.TRN

Full2.BAK

Tran2.TRN

using SQL2005. I deleted Full2.BAK and restored Full1.Bak, Tran1.TRN and then Tran2.TRN and this worked.

I'm still a tad confused?? I...

Thought so.

The doubt cam from reading about SQL2005 backups:

Copy-Only Backups

Usually, taking a backup changes the database and affects how later backups are restored. However, occasionally, it is useful to...

I have now fixed this. The generic DBA account was in the BUILTIN\Administrators login which I had denied (as a test). This was taking precedence. When I fully deleted this...

That's great.

Would this have to executed from a different server though?

Thanks for the great reply.

With the increase in log file size - the live log files (I have 2 ldfs) only total 3GB in size, but when I restored they...

Thanks - that's great. So a Rebuild does all a Reorganise does and more?

I've also found that the .txt log files are not created either. Would be quicker to create jobs from scratch!

Thanks Mark - I'm with you now.

Have imported a plan and see what you mean with having to change the server name etc etc. At least it keeps the steps...

Mark

Apologies but where do I expand 'Stored Packages', 'MSDB' & 'Maintenance Plans' from? I have created a new SSIS Package and created a Connection Manager to my Server where the...