First check the connection on the same server then go for remote,check all 3 protocols for SQL Server instance as well as client protocols in the SQL Server configuration Tools

Regards,

Syed...

you can use SSMS SQL Server Management studio to attach a database also by right on the Databases and then click ATTACH and then select files

Regards,

Syed Jahanzaib Bin Hassan

MCTS |...

Its new security,Its just a pop up we can say also because we are administrator too,if we are removing and executing some critical stuff then its appear

Regards,

Syed Jahanzaib Bin Hassan

MCTS...

Base Tables are those tables which are using for SELECTION only and set these type of tables in 1 to 10 times in a year

Transaction Tables are those tables which...

Provide query Display estimated Plan , it will show where is the cost of query

Are you receiving ASYNC_NETWORK_IO wait type ?

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP | OCA | OCP...

If dont have enough resources and you cant buy a license of new OS then you should change these settings and requirement

1-Enable PAE on your OS level

2-Enable AWE on your...

There is required only 1 cluster for 2 nodes

Yes this is correct

then if you want to install application like SQL Server or else then you have required 1 more IP...

It will be same as you create witness server in a normal server environment,in cluster environment you always use cluster SQL name,now scenerio is

Cluster 1 Name Primary : MSSQL_PRI

here...

No,

If you take a snapshot then snapshot do transaction of the same primary database

and database mirroring is an alternate of Cluster failover not for Replication check this by microsoft

Default value is 0 when sql server start

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

My Blog

http://www.aureus-salah.com

Default for the Operating System but SQL server didnt set this as default you have to set this parameter as well

Max degree of parallelism affects the number of physical processor

Regards,

Syed...

that was understood to stop the reporing services first then if he has any problem like as he mentioned then do that

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP | OCA |...

Check this script if you have any problem or modification required then tell me

Did you read this statement in the end of my post

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP |...

IF you have mutiple drives not partition or like SAN multiple drives,in this scenerio multiple files and filegroup will help you to optimize the database for performance

IF you have enough...

this problem occurs when SQL Server and agent service is started somewhere else like

Administrative Tools->Services,not from the Cluster Manager

Just right click on a Service and then click on RESOURCE...