Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with sql-server-2008-r2
Search options not deleted
user 35768
SQL Server 2008 R2 (major build version 10.50.xxxx). Please also tag with sql-server.
3
votes
2
answers
73
views
Is there a less manual way of changing database properties for all databases in an instance?
I've recently audited a SharePoint server and found configurations that are against best practice.
I'm hoping there is better and quicker way than right-clicking and changing these settings manually …
- 1,385
1
vote
0
answers
30
views
Why are the checkboxes absent under the Notify Operator Task?
I have several maintenance plans configured on a SQL 2008 R2 (10.50.6529). When I remotely connect to it with SSMS 2008 R2 or SSMS 2016 to edit the notify operator task there is nothing listed, just …
- 1,385
1
vote
0
answers
56
views
Performance Metrics for TempDB [duplicate]
I've been tasked with gathering performance metrics on a few database servers that have one TempDB data file. It seems prevailing wisdom is to have one TempDB data file per core up to a certain point …
- 1,385
2
votes
2
answers
3k
views
CHECKDB fails on MSDB and Master system databases
I get the following error within my maintenance plans:
Executing the query "DBCC CHECKDB(N'master') WITH NO_INFOMSGS "
failed with the following error: "The database could not be
exclusively …
- 1,385
2
votes
1
answer
79
views
Strange Backup and Alerting Issue
I received alerts from one of my database servers over the weekend that was somewhat disconcerting. There was an alert for each single database within the maintenance plan.
A full backup has never b …
- 1,385
1
vote
1
answer
206
views
How Do I Find Who Last Edited a Record or Table in a Database?
I believe that I have most of the work done for whoever wants to tackle this question.
I have the following query built:
USE MyDataBase;
GO
SELECT DB_NAME(ius.[database_id]) AS [Database],
O …
- 1,385
0
votes
3
answers
3k
views
SQL Log Messages - FILESTREAM and xp_cmdshell
I was perusing the SQL logs today and found the following:
FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'MSSQLSERVER'.
Configuration option 'xp_cmds …
- 1,385
1
vote
Virtual Log Files (VLFs) Fragmentation
You're correct about how the VLFs grow in size. Check out the following video from Jes Borland for some more tidbits.
How SQL Server Works: Log File (Video)
- 1,385
2
votes
2
answers
11k
views
BACKUP failed to complete the command BACKUP DATABASE
Not sure if this is a false-positive issue or not, but I need quell my curiosity about it. I get the following error message:
Error: 3041, Severity: 16, State: 1.
BACKUP failed to complete the …
- 1,385
0
votes
Accepted
BACKUP failed to complete the command BACKUP DATABASE
Looks to be a post-completion check failure as there is no evidence elsewhere stating otherwise.
- 1,385
2
votes
2
answers
3k
views
Numerous failed authentication attempts in error log
I'm having a hellacious time trying to figure out what is attempting to authenticate against a particular database server, running SQL Server 2008 R2 Standard Edition. The following is the error litte …
- 1,385
3
votes
1
answer
712
views
Why is SAN Replication is Causing Random Database Corruption?
Having a strange issue with a disaster recovery technology we're trying to implement. The environment in both datacenters is the same having VMWare and Dell Equallogic SANs, which are the same versio …
- 1,385