Hi;

Very interesting topic, I am planning same environemnt. By active participation we can conclude this discussion with a complete DR solution.

I have attached a picture(solution), please add comments.

I want to...

Hi;

Thanks again, now move another step forward

As Now we have 3 nodes (2 active and 1 passive) cluster for our production, Now its time to create another cluster for DR...

Hi

Greate, thanks for the response.

I am expanding this discussion 1 step further.

Now we have 3 nodes cluster (2 active and 1 passive), Please help to answer following queries.

Requirement:

==========

a) I want...

Hi Champ;

First of all thanks for reply, I think I was not able to express my query properly. let me explain Mathamatically 😉

Available resources:

================

1) Total Servers available = 3

2)...

HI;

Team; Thanks a lot for your quick response.

This is a dedicated DB Server

Please confirm what is the purpose of AWE (in my case), is it required to select this option...

Thanks you so much, I am abe to acheive my target by the help of your query.

Thanks Take Care

in addition to abbove, DB ID having only read & write permission to database. can not grant dbo access.

Hi;

Thanks for the reply, but let me further define my target.

I have attached a snap shot of my database (please review)

in this picture I have a folder "system stored procedures"...

Thanks really a good response.

Yes I have confirmed with SAN team, all partition are seprate and sure that it will enhance read write performance.

So it will be a good option...

Thanks for the resonse

But here I want to discuss about one user database having multiple data files on differnet san partitions.

Hi;

I want to grant privileges in sql server 2005 to a db user to create and alter tables.

can anyone helpe me on this.

Thanks

Hi;

I m facing same issue.

error 208: invalid object name 'dbo.sysusers'

even at the time of granting permission to app user on database it is showing same message.

Hi;

Jahanzeb; Thanks for your reply but my main focus is to create cluster with 2 public network.

as you know that normally in windows 2003 cluster we have only 2 network...

Thanks for the reply.

can u please share the steps to restart n/w services (SQL 2005)

also please confirm steps to increase the value of timeout session frrom SQL server 2005.

Team thanks;

1- I have configured daily backup of full database and transaction log of all databases

2- Recovery mode is still full

Now please help on following

* as now I m taking...