Home / server / Questions

Questions[orphans](server)

Martin Hope
Chris Moschini
Asked: 2012-07-01 12:06:56 +0800 CST
  • 2

When I restore a db in Sql Server 2008 R2 from data on another server, it makes a mess of the users. I have a Windows User and MsSql Login named Web_SqlA on both machines. Before the Restore, Web_SqlA is properly mapped to the right Windows user in the database. After the Restore, Web_SqlA is still listed as a user for the db, but it's no longer tied to the Windows user, causing Trusted Connections to it to fail.

How can I Restore the db without breaking this user each time?

I see that this:
Sql Server Database Restore

Addresses fixing these orphaned users after the fact; I'm looking to prevent overwriting the users during the Restore in the first place - everything else should be restored, but leave my users be. How can I go about that?

sql-server-2008 users restore database-restore orphans
Martin Hope
Mark Henderson
Asked: 2010-02-16 13:26:48 +0800 CST
  • 1

I have a problem. My vSphere 4 host virtual machine is powered on, but is not accessible via the network (I don't know what is wrong with it, for reasons that will soon become clear).

Because my vSphere host is clearly in a bad state, I can't connect to the vSphere centre to manage my cluster. So I logged onto each blade in the cluster (all 10 of them, ESXi 4), and I can't find the vSphere VM listed in any of their individual inventories.

Which makes me believe that the VM is orphaned, but still powered up, on one of the blades.

Is there any way I can get the machine back into a local blade's inventory? I know I can add it to the inventory by browsing the SAN datastore, but I won't be able to start it if it's already running on another blade!

vmware-vsphere orphans
Martin Hope
rlb.usa
Asked: 2010-01-29 12:31:22 +0800 CST
  • 1

Hey guys I have a large website I am trying to clean out; there are a ton of pages and quite a few of them are orphaned. (a page with no pages that link to it, IE, a page that can't be gotten to).

Is there an online service or a program that will find orphaned pages?

orphans