Viewing 15 posts - 1 through 15 (of 279 total)
I encountered this same issue, found a solution and documenting this for prosperity.
SQL Log shipping expects the trn files to be named "{DBNAME}_yyyyMMddhhmmss.trn"
for Ola Hallengren backup solution, this is equivalent...
August 25, 2022 at 3:22 pm
Forgot the include information about the machine:
Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 (X64)
Dec 28 2012 20:23:12
Copyright (c) Microsoft Corporation
Enterprise Edition: Core-based Licensing (64-bit) on Windows NT 6.1...
April 19, 2013 at 10:21 pm
cheshirefox (9/24/2012)
Experiencing the following - several times per hour. Has anyone experieced the following:
FlushCache: cleaned up 513008 bufs with 448519 writes in 75641 ms (avoided...
March 27, 2013 at 1:03 am
That cpu benchmarks at about 40% what a new e5-2690 does. 2.5x the cpu can kick the can down the road quite a bit.
February 28, 2013 at 7:03 pm
Jeff Moden (2/27/2013)
SQL Pizza (2/27/2013)
Got a lot of SOS_SCHEDULER_YIELDS-waits and a very high signal time. Could it also be possible, that we just need more CPUs?
As Gail has already said...
February 27, 2013 at 8:52 pm
Perfmon counters can really help as well.
They can give you a high level view of your server, and can provide evidence to help determine if things are improving or getting...
February 27, 2013 at 8:46 pm
Which OS (be specific please)?
What kind of HW (# of cpu's, ram, etc)?
How big are the Databases?
Have you run sp_updatestats?
Are you performing regular index maintenance?
Did this just start? or...
January 30, 2013 at 1:45 am
MSCS is part of windows, so there is no additional license.
December 3, 2012 at 11:03 am
There is a different set of binaries for 2012 Enterprise because server+cal licensed sql 2012 ent is limited to 20 cores and core licensed is not.
So, 2012 Ent is the...
November 30, 2012 at 3:07 pm
herb 25632 (11/29/2012)
Same query works fine on SQL_Production, but generates Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON' on...
November 29, 2012 at 8:18 pm
This pattern works well in these cases:
...and (@firstname is null or contains(firstname, @firstname))
...
Option (recompile)
November 29, 2012 at 6:33 pm
I haven't tried this with standard, but it does for enterprise:
Microsoft SQL Server 2012 - 11.0.2383.0 (X64)
Oct 5 2012 19:35:54
Copyright (c) Microsoft Corporation
Enterprise Edition: Core-based Licensing (64-bit)...
November 29, 2012 at 12:04 pm
Have you tried compressing the backup files using a zip utility?
Also, this is a pretty straight forward situation.
If the business requirement is to keep monthly backups of a...
November 29, 2012 at 12:01 pm
Viewing 15 posts - 1 through 15 (of 279 total)