Of course...! :rolleyes:

GilaMonster (5/3/2009)

---

I've had to do that before, haul a couple tables out of a backup (litespeed) and transfer them over to a...

GilaMonster (5/3/2009)

---

That's great when the DB is down and you need to restore parts of it really fast so that the users can carry on going, but it's not going...

I'm going to take this bit by bit to be as clear as I can for Gail and Michael:

troy.hodge (5/1/2009)

---

Our Legacy DB2 Z/OS System has 13 databases broken up into...

GilaMonster (5/3/2009)

---

That's not independent. That's just showing that you can restore 1 or 2 filegroups of a DB that has more. That's just partial database availability. That's great when the...

RBarryYoung (5/3/2009)

---

Hmm, I never dealt with OTT from the standpoint of point-in-time recovery (the OTT feature(s) that our customer paid us to emulate in SQL Server worked more like Detach/Attach),...

I was...

Michael Valentine Jones (5/2/2009)

---

This would amount to recovering the data in one filegroup to a different point in time than the other parts of the database, and that is something...

Jeff,

For common numbers like 8000 it's even sillier - the version I posted was a hack-around to get past the fact that the original fails to compile at all over...

Jeff Moden (5/2/2009)

---

Yes... but then you must also account for the run being against an NVARCHAR and divide by 4 instead of just 2 in Phil's example... as I did...

I suppose I should also add that database snapshots can be used to provide another level of protection against data accidents.

I've only been asked to restore data twice in the...

Jeff Moden (5/1/2009)

---

Actually, it's a "white space" problem.

[font="Courier New"]DECLARE @CrLf NVARCHAR(MAX)

    SET @CrLf = 'X    '+CHAR(13)+CHAR(10)

 SELECT LEN(@CrLf),

        LEN(REPLACE(@CrLf,CHAR(13)+CHAR(10),''))[/font]

Any sproc that has spaces just before the last CrLf will have the problem because when the trailing CrLf goes away, those...

Jeff Moden (5/1/2009)

---

Flo actually used a permutation of Itzik's method. It will quite handily build a billion row table without driving the log file nuts like most every other...

GilaMonster (5/2/2009)

---

It allows for tablespaces (SQL filegroups) to be moved...

Michael Valentine Jones (5/2/2009)

---

You can restore files or filegroups independently, but as a final step, you need to apply transaction logs to bring the database forward to a transactional consistent...

Cheers Barry,

Apologies to anyone offended if I came off a bit sharp there - I was posting quickly and disengaged some of the required politeness filters. Oops!

The backup/restore model...