Viewing 15 posts - 1 through 15 (of 26 total)
Hi Grant,
Thank you for your answer.
When I'm doing the backups, everything is in sync and committed. I've already tried the automatic failover too (without data loss),...
________________________________________________________________
"Accept conditions as they exist, or accept the responsibility for changing them."
January 23, 2018 at 6:11 am
We had an issue once with tempdb.
Someone read about secondary data files and contention. So obviously he created 15 LOG files for tempdb.
DBCC EMPTYFILE was not sufficient,...
________________________________________________________________
"Accept conditions as they exist, or accept the responsibility for changing them."
June 20, 2017 at 12:29 am
Hi,
Gail and BL0B_EATER are right, no such thing as Conditional process status.
I assume you are using sp_who2 or the Activity monitor.
Are you sure you are checking the 'Status' column and...
________________________________________________________________
"Accept conditions as they exist, or accept the responsibility for changing them."
December 14, 2015 at 4:58 am
What is the size of your latest diff backup?
Are you on simple recovery model? (lack of log backups)
Were there any changes in the usage of the database? (4 mins diff...
________________________________________________________________
"Accept conditions as they exist, or accept the responsibility for changing them."
September 24, 2015 at 2:40 am
schaudhary (9/24/2015)
Every Monday, Wednesday & Friday Full Back Up Process Run.Every Sunday Index Rebuild and statistics Update Process Run.
Differential back run every 3 hours.
Is it a local or remote backup?...
________________________________________________________________
"Accept conditions as they exist, or accept the responsibility for changing them."
September 24, 2015 at 2:18 am
Hi,
What is your backup plan?
How frequently do you have full and log backups?
This could be numerous reason for the 'slowness':
the cumulated diff backups have very big size (maybe only weekly...
________________________________________________________________
"Accept conditions as they exist, or accept the responsibility for changing them."
September 24, 2015 at 1:57 am
Hi,
A clustered index is a physically ordered table (heap) itself. If you disable it, it will become inaccessible.
Here is a pretty neat article:
http://blog.sqlauthority.com/2010/04/29/sql-server-disable-clustered-index-and-data-insert/
In short: do not disable the clustered indexes.
________________________________________________________________
"Accept conditions as they exist, or accept the responsibility for changing them."
September 23, 2015 at 12:49 am
Hi,
Is something happened during the SP installation? Do you have enough resources (mem, disk etc), did you check the db files?
Take a look in this article (and many others for...
________________________________________________________________
"Accept conditions as they exist, or accept the responsibility for changing them."
August 25, 2015 at 12:51 am
Hi,
You are in the good place, just choose 'Remove' and eventually you will have the usual 'Select Features' window to choose which component do you want to remove.
________________________________________________________________
"Accept conditions as they exist, or accept the responsibility for changing them."
July 14, 2015 at 8:16 am
ray santalis-466762 (7/8/2015)
________________________________________________________________
"Accept conditions as they exist, or accept the responsibility for changing them."
July 9, 2015 at 8:04 am
Hmm it was wild guess, some time ago I've learnt that SQL in local connection can fall back to NTLM. But if you still see NTLM from a remote machine,...
________________________________________________________________
"Accept conditions as they exist, or accept the responsibility for changing them."
July 3, 2015 at 4:06 am
Joy Smith San (7/3/2015)
Perry Whittle (7/2/2015)
has the account been trusted for delegation?
It was NOT. But now I got it done "Trust this use for delegation to any service (Kerberos only)".
I...
________________________________________________________________
"Accept conditions as they exist, or accept the responsibility for changing them."
July 3, 2015 at 1:07 am
JimmyJones (7/1/2015)
Hi,This was the closest article I could find when I needed that information, straight from Mr. Paul Randal:
http://www.sqlskills.com/blogs/paul/finding-out-who-dropped-a-table-using-the-transaction-log/
On a second thought:
- You could check the Standard Report 'Schema Changes...
________________________________________________________________
"Accept conditions as they exist, or accept the responsibility for changing them."
July 1, 2015 at 1:15 am
Hi,
This was the closest article I could find when I needed that information, straight from Mr. Paul Randal:
http://www.sqlskills.com/blogs/paul/finding-out-who-dropped-a-table-using-the-transaction-log/
________________________________________________________________
"Accept conditions as they exist, or accept the responsibility for changing them."
July 1, 2015 at 1:00 am
jellybean (6/19/2015)
For various technical reasons - we have to switch the TRUSTWORTHY property on a live database to on.
Any negative ramifications/potential gotchas of...
________________________________________________________________
"Accept conditions as they exist, or accept the responsibility for changing them."
June 19, 2015 at 3:57 am
Viewing 15 posts - 1 through 15 (of 26 total)