The other part of the story is that it also depends on the datatypes you're dealing with.

Row compression takes all numeric types and makes the physical storage variable length.

So, storing...

No. It will not work.

Not with any backup tool.

The issue is not the backup app, but the fact that as part of the upgrade, the database physical structures are...

Yes.

For larger blobs it's more efficient to use the GetPath() and Open SqlFilestream() functions to get an open file handle and use that to access the data under SQL control....

First, re-read my post about direct file access. It is...

Scott Roberts (9/24/2008)

---

Nice article, but I have a couple of questions/suggestions:

1. Are there any tests demonstrating the performance difference between FILESTREAM and traditional VARBINARY(MAX) columns? I've seen mention of varbinary...

Good article, but a couple of clarifications are in order:

First, FILESTREAM is a storage attribute on a varbinary(max) datatype column. It is not a new datatype. Seems like...

Note that if you planned in advance you could use named log marks to uniquely restore to any named mark in that range, regardless of time. Carrying it to...

Steve Jones - Editor (10/17/2007)

---

Of course, if you have log backups at 1:59, you'd only get the first backup at 1:59. According to Paul's post, SQL Agent freezes from 2-3...

OK, I'll see if I can explain it better.

The database as a whole MUST be at the same point in time.

If a database is in full recovery mode, you can...

If you have a database which is in full recovery mode, and if you roll the database forward to some point in time after the restore, then you could have...