Viewing 15 posts - 1 through 15 (of 36 total)
Hi,
Have you set the Computer Account to be Trusted for delegation? This can be done in AD with the User and Computers console by opening the properties of the Computer...
August 5, 2014 at 6:17 am
Yes, they can (and it's trivial to test and prove). Full backups DO NOT and never have had any effect at all, whatsoever on the log backup sequence.
I just tested...
August 5, 2014 at 2:47 am
NO!
Full backups do not and never have broken the log chain. The reset the differential base, that is all. Copy_Only allows for a full backup to not reset the...
August 5, 2014 at 1:52 am
GilaMonster (8/4/2014)
To break the backup chain:- Switch to simple recovery and back to full
- Delete a log backup file (the .trn)
- Delete the transaction log
- Revert to a snapshot
My additions...
August 5, 2014 at 12:34 am
Hi,
If your SQL Server is configured to use 16GB of memory by setting the Max Server Memory configuration option to 16000 (or by leaving it to default value), it's very...
August 4, 2014 at 12:27 am
Hi,
If you want to know what query caused the memory dump, you need to look into the memory dump. You need to use a debugger, such as WinDBG, for that...
July 30, 2014 at 11:58 pm
Hi,
OS System Cache is a subset of a Standby List. Standby List is used for pages that have not been touched for awhile and Windows performed memory trimming on them....
July 30, 2014 at 2:55 am
Hi,
I think there might be something wrong with the alias you're creating. In the Add Network Library Configuration page check the following:
Server alias: This is the alias name to the...
July 26, 2014 at 12:25 pm
Hi,
Error code 53 means: "The network path could not be found". The most common reasons I've seen this occur are:
A) Name resolution failure. This can be tested by adding the...
July 24, 2014 at 10:52 pm
Hi,
If your client OS is 64-bit you have two cliconfg.exes, one is the 64-bit residing in \Windows\System32 folder and the other one is the 32-bit one in the \Windows\SysWOW64 folder.
If...
July 24, 2014 at 4:57 am
Ola also provides a excellent documentation for all his maintenance solutions, just click the link on the left side under "Menu"-title. The documentation has all the parameters explained as well...
July 23, 2014 at 1:58 am
Hi,
Have you been able to connect from the client computer without using the alias? If your client software doesn't support that for some reason, you can use regular telnet with...
July 23, 2014 at 1:51 am
Hi,
You should start out by mapping what instances require DTC as it's not something you automatically need (after SQL Server 2005, which did require it for cluster installation). SQL Server...
July 22, 2014 at 11:27 pm
logicinside22 (7/12/2014)
I just created SQL Server 2012 active/passive two node cluster. Have F:\ Data G:\ Log for this cluster
Now I want to add sql 2014 with names instance...
July 15, 2014 at 1:19 am
Hello,
Have you looked at Summary.txt and Details.txt files? These should be in the timestamp folders under \Setup Bootstrap\Log folder and have more details about any errors occurring during the update.
July 14, 2014 at 7:10 am
Viewing 15 posts - 1 through 15 (of 36 total)