Hi there,

Yes it does, I've done it.

Hope that helps.

Thanks

Paul

Hi,

I just wanted to add something to this topic as I had the same error but the fix was slightly different, although adding files to the database was the key.

The...

gary.dunn (10/13/2011)

---

I apologize for hijacking this post, but I think your technique could be used to fulfill a request I've received. My users want a copy of a remote...

gary.dunn (10/13/2011)

---

I apologize for hijacking this post, but I think your technique could be used to fulfill a request I've received. My users want a copy of a remote...

Mohammed - care to share more information on that one-liner? Why would you want to avoid detach\attach, I've always considered this...

Perry Whittle (9/8/2011)

---

Andrew Notarian (9/8/2011)

---

Is there any reason we might not want to use the offline detach at old server /re-attach at new new server method of migrating from SQL...

Would it not be far easier to restore your backups (I assume you are taking backups of some sort; FULL + DIFF + TRNs) from the current SQL 2000 instance...

Just a quick update on this one in case anyone out there is following.

I eventually got around to creating a warm stand-by database and queried the transaction log after a...

GilaMonster (9/7/2011)

---

Paul Duffett (9/7/2011)

---

What if I had an unrecovered copy of the production database on a separte instance and "replayed" the transaction log backups, could I then query the transaction...