Sorry - meant indexes with more than 1000 pages. Because, reindexing indexes with less than that is practically useless. It can be argued the reindexing anything less than...

pshaship (4/22/2010)

---

Because of this increasing log file size while rebuild indexes making us to disable log shipping configuarion for our environment. We have a database of size 15 GB and...

It sounds like you are trying to install the database engine again. Only select to install the reporting services component and any other non-cluster aware components you want on...

jcrawf02 (4/21/2010)

---

Pity that Brent will get kicked out of the MVP club so soon after his MCM... 😛

And now for something completely different...

Any advice on ridding my lawn of the...

Try rebuilding all indexes in that database - and then see if it reports different usage. I am not sure why your backup failed - did you ever check...

I think we agree...

Well, you shouldn't be shrinking the database - it is just a waste of time since it will grow again.

What are the sizes of the mdf/ldf file?

What is...

prithvi-1147092 (4/19/2010)

---

Thanks for the update. Elsewhere in this forum, it was mentioned that \\ should be made \ etc but no mention how this can be done! Anyway, the copy...

My recommendation: don't use devices, use files instead and let SQL Server date stamp each backup file. What it sounds like you are trying to do is manage the...

Perry Whittle (4/19/2010)

---

local accounts work even on a domain, but you have to replicate them from machine to machine using the same username and password, much the same as you...

Bhuvnesh (4/19/2010)

---

...

ananda.murugesan (4/19/2010)

---

Mr.Perry Whittle said correct.

when I am using sp_help_revlogin sql 2000 then after exec this script in

SQL 2008 DB all Login were automatically maped with particulare database, which was...

Perry Whittle (4/17/2010)

---

Jeffrey, yes its one of the WITH options DEFAULT_DATABASE =

The revlogin procedure will export the logins default database. OK if its master but if its a database...

Your best option is to restore from backups, applying all of your transaction log backups up to the point in time of the failure. You do have a good...

Perry Whittle (4/17/2010)

---

Jeffrey Williams-493691 (4/17/2010)

---

As others have pointed out, you need to run the updated version of sp_help_revlogin before you restore the databases. When you do that, the users...