Ok, now i am clear. so i hope this i can apply to my restore issues also

subhash

Yes, ALATER DATBASE TEST1 SIGLE_USER , we can execute only when no users aer conencated....

My doubts are clear..... thanks a lot Vidas and Mike

subhash

hai Mike,

But this ALTER DATABASE TEST1 SET SINGLE_USER

will make all the connections teminated and will not allow further connection to the DB right ?

And this can be an easiest...

Hai Colin,

We used to move Cluster resources/groups (cluster admin-->right click group-->move group) from one node to another manually.

I just want to track when this movement happends...time and date

subhash

Hai,

Vida, thanks it works out....

with reference to this Single user Mod , i have one more query,

I was trying to restore a database, it was not allowing me to do...

Hai Vidas,

Ok, can u tell me how can i put, for example the DB 'TEST1'  to single user mod ?

pls give me the commands pls

And at this moment if i try to open another QA, it will give an error meessage like  db is in single user mod only one admin can connect at...

is there anything like

Truncate will release the used space to OS and Delete will not do this

David can u pls tell me what is this 818 hotfix ?

OK, enough inputs...... thanks a lot

OK, thanks...

i know that if clustered index exists, Logical Scan Fragmentation can be a measure for the level of fragmentation, since here we didn't have any clustered index and the...

recovery mod is still FULL,

is there any problem if SQL Agent is running under system account ?

In application log i am getting write permission error for this job (but how...

application log is not full,

but in application log it is showing log failed (no permission to write ), but it was running two days back

SQL Agent service is running under...

The disk is from Hitachi storage box(SAN),

and i am able to access the disk from primary node in which i am installing the sql 2K EE.

I have copied the SQL...

LAST FEW LINES FROM SQLSTP.LOG

19:26:14 Begin Action:  DialogShowSdLicense

19:26:15 End Action DialogShowSdLicense

19:26:15 Dialog 0x20 returned: 1

19:26:15 End Action ShowDialogsHlpr

19:26:15 ShowDialogsGetDialog returned: nCurrent=0x4000,index=14

19:26:15 Begin Action ShowDialogsHlpr: 0x4000

19:26:15 Begin Action:  DialogShowSdVirtualServer

19:26:37 ShowDlgVirtualServer returned:...