Thanks Sean,

I understand how to create alias but got confused where to configure i.e on sql server or on client computer:

from the link http://msdn.microsoft.com/en-us/library/ms190445(v=sql.105).aspx

It says, we need to...

Issue fixed.

Actually, on one of the nodes Firewall is running.

Disabled the firewall and it's working fine

Thanks

Windows Firewall service was already disabled on both nodes.

Please advise what else I need to verify?

Thank you.

I checked the below logs but did not find any IO errors:

1. SQL Server errorlog

2. Application Event viewer logs

3. System Event viewer logs

Is there any other logs I can look...

There are NO IO errors.

There are 50 databases on the same instance and the corruption is on only one database Mydb.

It is a QA database and in simple recovery model....

Thanks Perry.

What is the best practice to configure Mount points for SQL Server 2008 R2

I'm offered with two options:

1.

Take a 500 GB LUN fron SAN and then create a...

You mean there is no way to find out why the error occurred once we restart the service?

Thanks

Thanks,

I restarted the service and its working fine.

But I want to know why the error occurred..

Thanks

Check the permissions on the folders. When you copied the filestream folder it may not have inherited the permissions from the SQLData folder. The service account needs permissions to all...

it's FC.

the backup drive is Clustered Shared drive sitting on SAN. So in that case, we do not need any separate NIC as the backup directly writing to disk on SAN?...

Sorry Perry,

Can you please tell me how to do the same in 2008?

sql server 2005.

Thanks for your inputs

Matt,

In real world, if the database size 2 TB, how to backup that?

Full backup may take 1 day or 2..I don't think people do that way..

Please advise