what state is the database currently in?

with the standby\undo file missing you wont be able set the database to norecovery or recovery mode if it is in standby mode at...

could you explain a little more what you mean by this

Mark Jones-393934...

are you moving the databases across drives on the same server or between servers

it doesn't however mention, Active\Active\Active\Passive.

Next time i build myself an 8 node cluster with 3 passive nodes it'll be an Active\Active\Active\Active\Active\Passive\Passive\Passive

i suppose.

as i said, a cluster is either active\active or active\passive irrespective of the number of nodes.

The following article states

Microsoft Technet

---

Server clusters can take two forms: active/passive clusters and active/active clusters.In...

Check that the account running the SQL server services has permission to read write the folder specified.

Just a couple of points

Firstly there is no such thing as an

Active\active\active\passive cluster.

A cluster is either active\active or active\passive.

Secondly for dev and uat clusters, virtual is the way to go....

using virtual disks for the VMs SQL Server storage will be the weak point. For the SQL Server data storage drives they are better created as RDM's and ideally the...

BigSam (5/20/2011)

---

I have a 2-node cluster that I want to migrate to a 3-node cluster with more storage and memory. The current 2-node cluster will be retired.

Both clusters are running...

king_emperor_in (5/19/2011)

---

Thanks for your reply, Well i did exactly the same thing on my local machine and it was fine.

but if i will do that on my Production Server, wouldnt...

or someone\something is taking a log backup

2008 and 2008 R2 may reside on the same hardware

also you want to be using the sys.database_principals catalog view and not sysusers. This should be better

declare @sql nvarchar(max)

set @sql = ''

SELECT @sql = @sql+

'

print ''Dropping '+name+'''

execute master.dbo.sp_revokedbaccess '''+name+'''

'

FROM

...

you're welcome 😉

you're welcome 😉