It may be cluster feature but its available at SQL server instance level , can you tell me where we can configure at windows level if its available ?

Thanks.

Standard Edition (64-bit)10.50.2817.0SP1

Getting the registry values (service account,authentication mode,etc)through system stored procedures using sql server integration services.

Not getting the error at the first attempt , its throuwing...

Can anybody help me on this ?

GilaMonster (6/18/2008)

---

Do you want to see what users have the lock pages privilidge? If so, you may have to locate where in the registry the values are entered and use...

Yes , but i am looking for cluster enviroment.

Thanks.

Standard Qourum.

Sorry for the confusion. My question was

Will faileover occure when Active node rebooted even at the passive node cluster service is stopped ?

Thanks your infer and reply .

Thanks for you answer's.

Is page restore possbile here ?

Hi,

You can find restoration information as below in the error log file which has information about backup files...

Database was restored: Database: xxxxxx, creation date(time): 2008/11/14(15:07:22) device

information: (FILE=1,...

Has anyone come across such a problem ?

I found the article which has exact information that i was looking...

http://support.microsoft.com/kb/834305

free_mascot (5/9/2011)

---

In this situaltion you can use database role "db_backupoperator".

Create user and assign role of db_backupoperator in each database. Also you can create user and assign database role in model...

Syed Jahanzaib Bin hassan (4/29/2011)

---

Backup file drive and Restore File Drive is same ?

what is the size of Backup file now ?

Is there any Load on Database at the time...

Thanks Ray mon for your suggestion.

It would be great if you provide some links where i can find what could happen if windows system restart without stopping the database...