GilaMonster (8/29/2012)

---

No. Log backups are not based off a full backup unless that's the first ever full backup since the DB went into full recovery. Otherwise they're based solely on...

Thank you all, but I guess what was confusing is that each time you take a Full backup, the TLog backups that follow are based on that Full backup, so...

Chrissy321 (3/8/2012)

---

>>and then in SSIS I can also put the farm name in another column

Can you use the extended properties of a database.. Right-click on the database and go to...

Sean Lange (11/15/2011)

---

You are over thinking this. Don't make it so difficult in your mind. The client machine makes a request for a web page. This is done when you...

Thank you all for the responses, but I am still VERY unclear on how this actually works.

I remember reading years ago when the whole .NET thing first was getting started...

The current customer I work for has all their servers in a datacenter in another part of the country -- I...

Tape? You guys are funny!

But seriously, most places...

Thanks Gail, and I know there are different considerations for every server, but do you have a somewhat standard set of Backups and Deletes you do on a 'typical' server?...

Nice! Those both really work great, I didn't realize there was that @query parameter.

I guess a third option would be to create a #tmp table and save whatever complex query...

If you do this, the value of @messageBody is 0, rather than a list of servers.

DECLARE @messageBody VARCHAR(MAX)

EXEC @messageBody = sp_databases

SELECT @messageBody

Thank you Ninja's_RGR'us, it will take me a while to dig thru that!

But basically what y'all are saying is there is no way to take the output of a SQL...

Ninja's_RGR'us (8/10/2011)

---

P.S. The Restore gui can generate that whole restore script using the same tables.

I love having a 2nd option. My personal choice what to use the file names...

Here's another article that seems to add to the issue -- it clearly says each SSAS instance needs its own port. Whereas the earlier article says SSAS only works on...

OK, that worked, with some issues, of course...

I got a couple of test servers. On Server 1 I installed SQL 2005 database engine, and upgraded to SP4.

On Server 2 I...

Thanks! Care to share how?