Good question, never heard about this. Thanks.

Using this option is better than detaching the database.

ALTER DATABASE <DBName> MODIFY FILE (NAME = '<logicalFile>', FILENAME = '<physicalname>')

With this we could avoid using sp_replicationdboption to remove...

This might be the toughest QotD.

Good question on a nice topic.

beejug1983 (10/25/2011)

---

How the job will find the .bak file of Wednesday since there are many other files are also located. And what about orphan users? Will I be able to...

You could create a job on the target server and include the steps one by one as desired.

For copying the backup files, you could set up a shared drive and...

I think you won't be able to perform what you are trying. From books online, we have this information regarding

sp_replcmds. You could refer this link below.

Link

"Replication treats the first...

Not tried this before but can you share the error message?

Useful article Kimberly, Thanks for sharing. Hopefully, we will get more articles from you on replication. 🙂

Eric Mamet (10/19/2011)

---

Dear all,

- failing some distribution cleanup on our test server (which we were never able to fix, although we think we installed replication exactly the same that...

Please refer below link, it is quite useful.

Link

Is that SQL2000 backup - a native backup file or taken using some third party tool?

vk-kirov (10/19/2011)

---

"The Default group can be moved out of the Default Pool"? The referenced BOL article says just the opposite:

Resource Governor Concepts

---

The default group is alterable but it cannot be...

If you don't mind me saying it seems that you have very little experience with Windows server systems and networks in general. Research TCP/IP and IP addressing. Practice these concepts...

Thanks. Good question.