Thanks all, I want to learn Powershell thats why I thought to do it using Powershell.

Thanks. 🙂

its 32 bit. what counters i need to check.

because my production and developer environment are different..so cannot restore master db.

Any another way out to fixing the orphan.

Thanks in advance.

Hi,

The version is SQL Server 2005. And I am not allowed to use any high availability solutions. Fixing up orphan users becuase I am restoring backup from one server to...

Sorry Bruce I was committing one mistake I tried like [PS C:\> .\filename] and it worked. Thanks for your help. 🙂

Hi Bruce

I modified the script and tried to execute but no output file is being created in c:\ drive. Apologize if I am doing any silly mistake since I am...

Thanks all for useful comments.

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

Thanks Perry..:-)

Thanks all for replies. 🙂

Its SAN drive.

Only backup job is running at scheduled time.

yes the data volume hasn't grown by half, and I dont have knowledge about performance monitor tool.

Hi Perry, if heartbeat signal is using private network and anyhow private network goes down then how this heartbeat signal will use public network ?

Thanks in advance.

Thanks for your quick replies Perry. 🙂