Going back to your real issue, that of re-initializing the subscriber, you may need to look at how you are doing this.

In SQL 2005 schema changes may be replicated to...

As Jason says, low rows per page really means wide rows. In my old mainframe days we could manage the size of the page, this allowed us to calculate an...

Note this article: http://support.microsoft.com/kb/264474

Taking it one database at a time.

Model: Unless you have modified the Model database for your particular requirements there is no real reason to move it to...

In theory yes, but I question why you want to do it this way. There are a few issues that can cause you problems.

Firstly you can backup the resource database,...

It's not as black and white as that.

I do have an issue with SQL creating schemas for every user, and I tend to delete them and set all users default...

In general knowing that most vendors don't like client messing with their DBs, I've used a different approach to this problem. I would rather add my own database to the...

If you are using sp_spaceused you will often get out of...

Yes, I've seen similar behavior, although not exactly the same as your first example I have seen the second one.

2 things I've learned about the DMV Index recommendations. Don't accept...

Have you tried doing a restore with REPLACE? You should be able to use any database backup as long as you make the database name match and use WITH MOVE...

Patricia Johnson (11/22/2010)

---

No transaction log backups are failing. I run a transaction log backup every 15 mins for all the databases. This transaction log truncate appears to run...

marko61 (11/18/2010)

---

sorry if I've bodged the explanations so far.

Are you able to advise which trace counters would be most useful to break down the different stages around the cursor?...

I've got to second Lutz here. It sounds from what you said that you ran the SELECT statement of the cursor and it ran in "0" seconds, but when you...

Avoid using cursors!

Cursors are row based queries, in simple terms SQL defines which rows are required in what can be thought of as a temporary structure. Then when you step...

Page9:F1 (11/18/2010)

---

So I think if I can get rid the replication rebuild, I can reduce the time window for the work.

We cannot make the DB offline or detach directly...

Ann Cao (11/17/2010)

---

I see an microsoft knowledge based instruction of how to backup/restore user databases to a new server, and then transfer logins and sql jobs.

But some one mentioned...