true abut SQL2008.   This is a test environment.   Still cannot connect to SQl2008 sql server using ssma.

running ssma IN 32 BIT mode helped.  Now this tables display when I select the MSACCESS database file.

But when I try to connect to sql server, I get...

I'm a powershell rookie.   Here is my 1st attempt.

copy-item -Path \\servera\D$\sqlbackups\*.bak -destination \\serverb\D$\sqlbackups\

When I run this in SQL Server agent, I get a successful...

yes. BTW This blog is really good.

I didn't even know how to set up Sql Agent Proxies. Not rocket science, but I always enjoy learning new features.

It's always great to have support from a solid team. Our network group is excellent.

I am copying 1 set of backups per day to a virtual server and this...

Setting up a SQl Agent Proxy and using CMD exec did the trick. In this process I have learned that working with xp_cmdshell is not amusing. ...

Nice idea. But I prefer the CMD Exec option.

Yes, the service acct did not have adequate permissions. I changed it and this caused Idera Diagnostic Mgr to go south for that server. I generated a...

Part 2. We have 2 2008 r2 servers with 2008 r2 sql server installed on both.

Our goal is to copy the full sql server backups from server A to...

The last option worked. Thank you.

I downloaded and ran the Migration assistant. It did a nice job moving the tables. Afterwards, I logged into SQl Server Mgmt Studio and activated...

yes ms access 2010 and sql server 2008 r2.

When using the upsizing wizard I chose the RI option. Perhaps the triggers would have been a better choice?

I used the upsizing wizard. it did not preserve the RI. Thanks for asking.