Check with the network guys to see if the port for the named instance is allowed through the firewall for VPN users. Typically, VPN users will only be able...

The top 1 in your select statement may not always bring back the same record each time, since there is no order by clause on the query. The WITH(NOLOCK)...

It's a little difficult to say if the corruption is gone. From the error messages, it appears to be a problem with the pointers on the two off-row storage...

Are you using the FILESTREAM_WITH option on the restore command? The documentation is not too specific, but I would assume it moves the Filestream data to a new directory.

You most likely need the Oracle client. For SSIS, you will want to instal the 64 bit and 32 bit clients, since the Data Tools are a 32 bit...

I've always had basic disks, but I doubt that is a major concern. The lack of MPIO would be a problem, as typically SANs are set up with multiple...

Have you installed and configured MPIO on both of the nodes? The report shows a large number of disks all MBR/Dynamic.

Check the filegroups for the database. Most databases (at least the ones in this size range) have just primary and Logs, but a filestream database will have a filegroup...

If there are no dependencies on the actual owner of the database (such as the application runs as that ID), then you probably do not need to worry about this....