Viewing 15 posts - 4,126 through 4,140 (of 49,571 total)
And what if the full backup that completed successfully won't restore? Completing doesn't mean it's good. If you're using RESTORE VERIFYONLY, that checks the header of the backup file only.
So,...
December 1, 2015 at 1:27 pm
For CPU usage, use perfmon. It can track per core, for a specific process or overall.
December 1, 2015 at 12:26 pm
BACKUP ... WITH INIT;
December 1, 2015 at 12:25 pm
Could be a maintenance plan, a linked server (loopback linked server perhaps)
December 1, 2015 at 12:25 pm
No, it's not.
Running CheckDB on Server 3 tells you about the integrity of the DBs on server 3 only. The IO subsystem doesn't write to the transaction log when it...
December 1, 2015 at 12:24 pm
Check the application being used to access SQL and see what it's logging in as. If it's Windows Authentication, then it'll be something like <domain>\<logged in user> or <computer>\<logged in...
December 1, 2015 at 11:29 am
I said nothing about deny, and it's nothing to do with the computers being used.
A login to SQL Server starts with no permissions. So take the login that's being used...
December 1, 2015 at 11:18 am
Give the login that's used rights to access only the DB that it should be able to see and no other permissions. By default a login has no permissions at...
December 1, 2015 at 11:05 am
No, but generally a better (easier, less prone to errors) way of getting a DB from SQL 2008 to SQL 2012 is backup/restore. Is that an option?
December 1, 2015 at 11:01 am
Perfmon files are pretty small, I usually use the default of 15 seconds, run for a day or two and end up with a file in the tens of megabytes.
December 1, 2015 at 10:55 am
They want detail? How many rows are we talking about? If it's over a hundred or so, they're not going to be reading the data. Maybe worth taking some time...
December 1, 2015 at 7:45 am
Most new features will work fine in a lower compat. It's just places where what is allowed has changed, like with APPLY where things will break on a lower compat...
December 1, 2015 at 7:05 am
All that can be determined from the error is that it's some app on the machine 123.45.67.89. If that's the active node of the cluster, then there is something running...
December 1, 2015 at 6:35 am
Ed Wagner (12/1/2015)
GilaMonster (12/1/2015)
Ed Wagner (12/1/2015)
They appear to have a one-shot use though, before disappearing to somewhere else.
Probably something to do with collapsing the quantum mechanical wave function. Using one...
December 1, 2015 at 6:08 am
Ed Wagner (12/1/2015)
They appear to have a one-shot use though, before disappearing to somewhere else.
Probably something to do with collapsing the quantum mechanical wave function. Using one collapses the function...
December 1, 2015 at 5:32 am
Viewing 15 posts - 4,126 through 4,140 (of 49,571 total)