Hi,

I did the following:

On Backup drive, which is in Backupgroup, I have created 2 file shares, Logshipping1 & Logshipping2 from Cluster Administrator. One for ins1 & one for ins2.

Configured Log...

If I manually Failover sqlgroup1...

Thanks,

I'm not migrating the Reporting Services one server to other

We want to have a standby server always on Secondary Location for SSRS too. From our setup so far we are...

the above steps...

Sorry..I missed the last lines to read from your previous post.

thank you

Thank you,

Personally I mostly use % idle time, avg sec/read and avg sec/write. Doesn't matter what the underlying storage is, if the idle time is low and the sec/read or...

Hi Gail,

My statement might be wrong. But I read about only Avg Disk Queue length, that we can not measure exactly when the storage is on SAN from one of...

I tried by giving above mentioned permissions But it did not work. While installing the application, it will ask for the following details

Connection Type: SQL Authentication

Server Name: ABC

Database name: Test

User:...

Hi Brain,

I did the following in sql 2000. Please correct me if I'm wrong

db_datareader

db_datawriter

db_ddladmin

To give Execute permission on stored procedure on a newly created database: after creating the database go...

Could you please give some info on the above cluster fail over. And aslo here Node3 resources should only move to Node2 but not to Node1 (thats the way we...

In SQL 2000, I did the following:

Created a new database Mydb and granted the below rights:

Created a login Scott and mapped that user to Mydb and selected the below database...

Go through this link..

http://www.windows-tech.info/15/2b775367de544d88.php#

which says, UTC time stamp is by design for Log shipping .trn files. But looks like there is no documentation for this on BOL...weird:hehe::hehe:

SQL Agent is running under domain account "abc\mssql" and its continually running and all other jobs also running fine. At one point in time the Notification Job failed twice. After...

Yes, the server is a part Active Domain.

Please advice...