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...

A couple of points on your process:

Item 1: SQL Server service accounts should not be setup as local administrators. Whether or not you use a domain user or local...

You use the procedure sp_change_users_login with the auto login parameter and identify the login/user to be fixed.

Look up the procedure in Books Online for exact syntax and available parameters.