Well, the first thing you want to find out is if this is Express Edition or not. If it's Express, you won't have the option to create a Maintenance...

I found this posting on Simple-Talk the other day, and am intending to give it a try: http://www.simple-talk.com/sql/ssis/ssis-basics-setting-up-your-initial-package/

Then there's part 2 of the previous article: http://www.simple-talk.com/sql/ssis/ssis-basics-adding-data-flow-to-your-package/

Jason

Thanks for the information Steve!

If / when I go to the SQL in the City, it'll only be the second such event I've been too. I do (when I...

Well, for giggles I renamed an SQL Server I have, to see if that would break the Agent service.

I changed nothing, didn't follow the steps when done to rename an...

Did you rename the computer at some point?

I ask because it doesn't look like the computer name is the same between here:

and here:

Unable to connect...

Oh, I don't mind biased, and I figure I'll pick up some pointers even if I never touch a Redgate application.

Hmm, now to suggest this to one of my bosses,...

OK, I'm reviving this topic with a new (somewhat related) question:

How do you feel about the SQL in the City[/url] events?

I took a look at the agenda for the London...

At this point I've seen Avengers three times and yet I still wouldn't object to seeing it again. I'm a comic book fan from a while back, but nothing...

Thanks Lynn! I took a look at the PASS 2012 site, and it looks interesting, especially after I browsed some of the sessions from 2011.

Now, if I could figure...

Thanks to both of you!

Jason A.

Lynn, you are absolutely right that if we were to do Differential backups, it would catch the updated filestream information. I was talking about my original thought of doing...

Leo.Miller (4/17/2012)

---

jasona.work (4/17/2012)

---

I realize we could take Differential backups throughout the week (Tue-Fri,) which would capture only the updated / changed / added Filestream information, but there are office politics...

If you download and install the SQL Server 2008 R2 Express with Advanced Tools, Management Studio does come with it.

Jason

I think (right now) I'd probably be a Ford Crown Victoria. Rugged, dependable, keeps on going no matter what crap gets thrown at it...

Why do you think the Crown...

A few possibilities to look into on this:

1. Are your systems both in an Active Directory Domain? Can you ping each server from the other by name NOT...