GoofyGuy (7/17/2014)

The pain goes well beyond these technical difficulties, because Access databases and their accompanying 'apps' are often written by people outside the IT department - meaning the business becomes...

Cool, thanks very much. I always like to learn a bit more about what's going on under the hood.

If you back it up with the Compression option it will hopefully make things a bit quicker when you're doing the copying too because the .bak file should be smaller.

By...

Oh, also, would not specifying a catalog make the whole process any slower?

Thanks again.

Thanks. So does that explain why the activity I'm seeing is in master?

(I did actually originally set the linked server up with a Catalog, but I was overruled by my...

Unless I'm missing something major, I'd just take a backup, copy the file over to the other instance, then restore it. Have you tried that? It's probably the simplest way.

I'd like to support this request, and also ask if it's possible to do what they have on other boards I use, which is take you to the last unread...

Hi- this is a really old thread that has been bumped. Cringe! They actually ended up trashing and rebuilding that server because it was just all wrong. It was definitely...

I agree. I've worked with people who seem to be quite happy to be stuck as "expert beginners", doing the same few things, year in, year out. They do those...

Have you done a DBCC CHECKDB?

Have you taken any log backups? It's not clear from your post.

Also check the profile for any denys that might have sneaked in.

Have you tried explicitly granting 'Connect' to that group? Sorry if this is too basic.

There should be more information in the SQL Server error log; can you have a look there and let us know what it says?

The same user has thanked me as a man too :-D. It's just nice when people say thank you.