Thank You,

For example, if the drive is not in the same group - the SQL Server cannot see the drive. So, for backups you would have to reference the drive...

Hi,

from this link http://www.mssqltips.com/tip.asp?tip=1651

Here we have a separate group DEVBACKUP to keep the bakups. In this scenario, how this group failover to other node when failover initiated due to some...

Thank You

We create a minimum of 3 cluster groups:

Cluster Group - contains the cluster resources

MSDTC Group - contains the resources for MSDTC

SQL Group - contains the resources for a SQL...

Thanks Scott,

.

We have the backup drive in backup group and...

Thank You Scott, George,

According to Scoot, We need to create a share LogShipLogDump$ on Node1(Active) on the cluster and as well as in secondary server right?

We have a Backup group...

Thanks,

In server A, the SQL Agent runs under ABC\mssqlsrv and in other Server Server B, the SQL Agent runs under XYZ\mssqlsrv. So In this case how can I share...

I went through the link, but just clarify the above four points.

Could you please provide me a script, which continuously checks the index fragmentation and if it finds the avg index fragmentation>30%, it should perform index rebuild and if it is<30%,it...

I thoroughly checked, NO other jobs are running.

But in SQL Server 2005, Full, diff and log backups can run at the same time as I understood.

thanks

I got the same error second time today(after 5 days) and investigated all the databases. I noticed that for one database auto shrink is enabled.

If this is the reason, the...

could you please give me some info.....

Here are my server and...

from where this user 'NT AUTHORITY\ANONYMOUS LOGON' is coming from ?????

thanks,

sql server surface area configuration-->surface area configuration for services and connection-->click remote connection of your instance-->TCP/IP and NamePipe---------IS ALREADY ENABLED

Both Server A and Server B are Developer editions 64...

Iam using windows integrated security. Its a domain...