Thanks for the tip,

So after running

USE DatabaseName;

GO

ALTER SCHEMA dbo TRANSFER JohnThomas.tablename;

GO

I'll go from

johnThomas.tablename to dbo.tablename?

Thanks again,

D.

Hey, thanks for getting back. I just worked out what was wrong, I added the SQL service account to the 'lock pages in memory' priv and it all worked out.

Thanks...

Thanks Gail, we are actually behind on on SP's so I'll make some moves there.

Regards,

D.

Its ok, I think an application is just trying to access the DB while its being backed up.

D.

That did the trick, thank you. This is what I ended up with before your help, I can see where I was getting it wrong and will help in future.

select...

Thanks for getting back, Guys. Gail, thank you for the link I'll have a read through. Elliot, will definatly be testing, but needed to make sure I'd be testing it...

Hi Perry, which service account are you refering to? The sql service account? I have multiple named instances, only one was changed via services (not by me), the others where...

Hi Perry,

If I try to change the account in SQL configuration manager, I can choose the account no problem, when I click apply and/or OK I get the following error...

Hi Perry,

Thanks for getting back,

What tool did you use to change the SQL Server service account?

SQL Configuration manager, not services.msc

Are there any messages in the event log?

Lots, the main one...

Thanks for getting back everyone,

I did try to restore the a backup to 2008 (which worked of course), I then tried to use the Transfer SQL Objects Task to copy...

Thing is I hve tried that and it misses too much stuff. Its so annoying that the Transfer objects task is what I need, but does not work properly.

Regards,

D.

Hi Phil, thanks for getting back.

There is no datbase on the other side, I just wanted to transfer the database along with everything into the 2008 instance (hence setting...

The 2005 database is set to 90, but what other database?

Regards,

P.

Hello,

Its running on the SQL 2008 R machine.

Regards,

D.

Hello sb-619473,

I am in exactly this position, could you please let me know what happened in the end? Did you manage to get round it?

Regards,

D.