Thanks Kevin.

Hey Kevin,

Last server restart is 2016-01-04 23:32:30.253

I have no ability to Edit any code, ( i wish i was using Sp's)

I Tried creating dropping modifying indexes - no luck

this...

Hey Kevin..Thanks for the tips.

A. we have a plan to add more memory soon

C. I said properly indexed only because , i made sure -No duplicate, No unused, no missing...

After creating the publication

followed the link ,it helped

https://msdn.microsoft.com/en-us/library/hh882436(v=sql.120).aspx

monster,

thanks for the tip..i am looking at below link per your suggestion on scripting config settings

http://blogs.msdn.com/b/john_daskalakis/archive/2014/10/27/script-to-export-the-configuration-of-sql-server.aspx

Thanks

My Bad.. i did a validation check on server 1 and 2 failover cluster and it is working now ..never mind

Thanks

thanks JeepHound

Hey Thanks for the reply..

3. To some extent all of these are covered in a 3 node scenario, however if the network goes down your applications can't connect to the...

it worked actually

Values(1,'Abc','USA',ISNULL(@International,'N') )

thanks

I'm Sorry I was really in a Hurry .so i did not look at it Properly

I am Sorry ......

my requirement changed

They asked me to create a XYZ_MOCK database so creatde that and I did Copied Scripts From XYZ and ran...

Thanks for the answers .I do appreciate that

But If i do backup and restore ...i will be having all 50 tables ...

but i need only 20 tables ..Structure...

I got the script ....Thanks all ....

But do i need to restore .ndf files also???

Because i saw 6 ndf files when i try to restore ,,

MOVE N'XYZ_Data1' TO N'A:\MSSQL\User\XYZDBData1\XYZ_Mock_2.ndf',...