Viewing 15 posts - 31 through 45 (of 185 total)
The error message doesn't look like it's related to a query timeout since it appears that it's trying to connect to the Principal server. The database is configured for...
April 6, 2016 at 7:46 am
So I attempted the install:
"Microsoft® SQL Server® 2008 R2 Native Client
Microsoft SQL Server 2008 R2 Native Client (SQL Server Native Client) is a single dynamic-link library (DLL) containing both the...
April 6, 2016 at 6:32 am
I checked the driver version and it's running:
SQL Server 2008 0x730B0003
SQL Server 2000 0x71000001
Is there a SQL Server 2008 R2 driver? Could I install a SQL Server 2012 or...
April 5, 2016 at 6:43 am
Oh really?? Can you please tell me more about the older version of OLEDB and how you fixed it?? :w00t:
April 4, 2016 at 1:58 pm
Thank you for the responses!
I just wanted to make sure that the servers will be configured correctly before going into production to prevent future issues.
I did...
April 4, 2016 at 6:40 am
Thanks!
Yes, I added the SQL Server service account as well as my account to the Perform Volume Maintenance Tasks policy.
April 1, 2016 at 8:16 am
Grant Fritchey (3/30/2016)
March 30, 2016 at 9:19 am
As far as I understand it, AlwaysOn is built on top of WSFC so WSFC needs to contain both nodes. You do have the option to share the storage,...
March 30, 2016 at 8:22 am
Haha... The VM/SAN admin responsibilities falls under my hat. Oh boy.
March 30, 2016 at 8:17 am
Thank you!
Copying a 2.7 GB file...
VM:
36.7 seconds
Physical Server:
3.4 seconds
Wow!
March 30, 2016 at 8:03 am
Thank you!
Is there an IO testing program you would recommend?
March 30, 2016 at 7:46 am
Oh, another possible reason could be that the VMs are SQL Server 2016 and the physical server is SQL Server 2008 R2... Prod database is in SQL Server 2008...
March 30, 2016 at 7:27 am
Thank you for the quick response!
The VMs and the physical server are on different SAN groups. This is the breakdown of the volumes...
VMs:
SQL Data: RAID 6 Accelerated (Equallogic SAN...
March 30, 2016 at 7:19 am
Blah... For some reason, my mount point didn't take. Instead, there was a file folder that was created.
March 29, 2016 at 6:39 am
Hmm... I'm getting the "There is not enough space on the disk" error again. The resolution to my previous "not enough space" was to create a folder within...
March 29, 2016 at 6:33 am
Viewing 15 posts - 31 through 45 (of 185 total)