Ok I got it working the issue was with UAC and the fact that I didn't create a user on both SQL servers.

If you use this feature remember to right...

In the end it looks like I will use a SSIS package and the copy database function in SSMS.

No ideas?

jsph152 (5/27/2011)

---

I know that I need to do Integrity Checks, Index Rebuild/Reorganize, Backups, Statistic Updates...

That's all that comes to mind. What I'm wondering is, what needs to be maintained and...

Guys -- Great answers, exactly what I was looking for. I appreciate all of the replies. 😀

cfradenburg (5/27/2011)

---

It's a big question and if you want a quick answer it's, "It depends."

How often backups, integrity checks, and reindexing needs to be done depends on your environment. ...

I guess I'm asking for too much or I could have worded my post better?

Between servers

Ninja's_RGR'us (5/26/2011)

---

You can use xp_cmdshell to get a list of files but that doesn't tell you from which db it comes from. You'd need to look it up the...

Do you know if generating a list of databases in a directory then generating the attach code for that is feasible?

Basically it would prompt you to select the directory that...