That's a lot of data to paste over here.

Can you guys suggest in particular which sections you need in particular?

we have 128 Gb of memory on the server.

max memory allocated for sql server is 100 GB.

Resource governor not enabled.

Full text filter daemon launcher is enabled.

Thanks

Thanks a lot !!!!!

can't we install on one server and add the other node later?

What if we want to upgrade a standalone to a cluster environment and if we want to use the...

Are you able to re-point the applications etc? YES

I will try to work on the mirroring option.

Can I know more about other options?

Hi Thanks for the reply.

So i cannot insert the value as PM and AM in the datatype column which is defined as "datetime" or Datetime2 in my destination table.

Please confirm.

If...

I require more 2 TB of space for shared disk. We will be using SAN.

Not sure of the mountpoints.

Windows server 2008R2 is installed on the vm servers.

Where to check...

Actually we are testing it on VM servers before doing it on PROD.

I am not sure how to do this whole thing without downtime.

I replicated the PROD environment on to...

Thanks!!

Our prod is a huge OLTP environment. We are trying to setup clustering on it.

Can we setup cluster services on the standalone server without any downtime?

Is it possible? If yes,...

Sorry, I got it.

Thanks !!

What about the retention period of saving the backup files and copy files? We also have to take care of this issue? If the backup files are removed before...

In logshipping........we save backup files on primary server and then copy these files to secondary server and then restore on the secondary server.

So my question was instead of saving it...

I am not sure if it works without re-initialization, therefore you need to test it on some test server prior to do it on production.

1. Go to publication properties.

2. Select...

That column was a part...