Try first copying the backup files to restore to the drive you intend restore on, and then exec the restore.

Info source:

http://www.mombu.com/microsoft/sql-server-msde/t-cannot-use-backup-file-s-originally-formatted-sector-size-512-and-now-device-sector-size-2048-254989.html

---

Edit/Additional information:

Confirmed at (near the end):

http://technet.microsoft.com/en-us/library/aa275793(v=sql.80).aspx

And:

Excellent article on setting up a linked SQL server. Could be interesting to cover some links to other popular DB sources just to round out the topic.

Only one item...

Since the OP doesn't actually test the bounds of an specific integer type, it can be confusing. However, the Reg-Ex in the OP is nice, and I prefer to...

Gary Varga (3/23/2010)

---

DPhillips-731960 (3/23/2010)

---

...

To the point, I don't know of an academic school yet with a course that actually teaches RDBMS design with the effect of producing any significant amount...

Tom, I like your style and agree with most of your assessments. NULLs indeed. But I won't even attempt to insinuate that I have anywhere near your understanding...

Great site Steve!

The about page stats need updating... on member count, or at least a date point on the figure.

But anyway, it is the best site. This and BOL...

The short answer:

In reality, it comes down to how many layers of security a company needs, and the perception of due diligence. That depends...

I applaud the release, as it will help to push the 2008 series out there. Many wait for a second release for fear of problems and bugs, and this...

nick (5/18/2009)

---

...

Everyone who has recovered from back pain and repetitive strain injury has their own ideas, and I'm no exception. I went and studied the Alexander Technique, and had an...

Glad I could help!

srowley (5/14/2009)

---

Hi Steve,

I've recently taken up full time alpaca farming. I've noticed a significant improvement in my general well being and have lost a lot of weight. Not...

Good advice Steve. After straining my back a few weeks back, I have been trying to be quite a bit more careful with body mechanics.

I wanted to add that it is definitely by design that multiple instances of the same named Procedure can be executed at the same time. If not, then recursive...

"

CREATE PROC GO AS BEGIN

EXEC ('ALTER PROC GO AS SELECT NULL')

EXEC GO

DROP PROC GO

END

GO

EXEC GO

"

So to start we have actually TWO primary initiated commands.

First:

"

CREATE PROC GO AS...

Or even the cloud, where...