Viewing 15 posts - 2,716 through 2,730 (of 2,883 total)
Did you look in the event log? I am willing to bet that that is exactly what it shows in the event log. I've sen those types of messages in...
March 9, 2017 at 11:12 am
I've not done much (ie anything) with windows failover clustering,but that dependencies list doesn't look like it lists cluster disk 5 as being included in the failover.
As a...
March 9, 2017 at 11:09 am
9 TB of data is a lot of data to restore, so it doesn't surprise me it takes a while especially on a system with that low of memory.
March 9, 2017 at 10:28 am
small progress again, firewall was blocking some ports on remote computer so i think i...
March 9, 2017 at 8:44 am
Right. About the CHECKDB thing. that threw me off. But you have not run checkdb in quite some time, no? 2017-01-19 appears to be the last time it was...
March 9, 2017 at 8:20 am
If I understand the logic correctly, I think this is more what you want for your loop:WHILE EXISTS(SELECT 1
...
March 9, 2017 at 8:09 am
Well, first I would add in the RECOVERY option to the restore.
Second, it sounds like you are out of resources to do the restore. how much free space...
March 9, 2017 at 7:17 am
March 8, 2017 at 3:23 pm
I think to encapsulate it you would need to put it into a UDF but as you said that'd be a RBAR thing and you are trying to avoid those....
March 8, 2017 at 2:39 pm
The other option, presuming you have SQL Enterprise or SQL 2016 SP1, is to use change data capture.
https://technet.microsoft.com/en-us/library/bb522489(v=sql.105).aspx
March 8, 2017 at 1:48 pm
how about this:SELECT CAST(ABS(CAST(CAST(FirstDate AS DATETIME) AS INT) - CAST(CAST(SecondDate AS DATETIME) AS INT)) AS INT)/365
Not positive that outer cast to an INT is required, but...
March 8, 2017 at 1:04 pm
I did this recently on our test box. I just used the SQL 2016 installer to do this. I clicked on the upgrade button and let it do its magic....
March 8, 2017 at 10:33 am
March 8, 2017 at 10:11 am
What is in the log AFTER the differential restore?
And what is your full restore command? What about if you remove all of the optional arguments and just stick...
March 8, 2017 at 9:50 am
March 8, 2017 at 9:15 am
Viewing 15 posts - 2,716 through 2,730 (of 2,883 total)