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
Search options not deleted
user 35768
All versions of Microsoft SQL Server (not MySQL). Please also add a version-specific tag, like sql-server-2016, since it is often relevant to the question.
1
vote
0
answers
71
views
What do you disable, uninstall, remove from your OLTP SQL Server to keep it as clean as poss...
I'm looking for answers on all the services you disable, anything that you disable, uninstall, etc. The goal of this topic/question is have a running checklist of things that do NOT need to be on a S …
- 1,385
21
votes
4
answers
57k
views
How do you find SQL Server version/edition without SSMS installed?
How do find out which edition is installed without having the management studio installed? I have a server that functions as a license manager for another software. Upon investigation of a high RAM …
- 1,385
1
vote
Log Shipping "out of sync" but none of the jobs are failing
I take the LSAlert job with a grain of salt. Troubleshooting that issue made me pull my hair out! In the end, the log backup, copy, and restore jobs were functioning as expected.
Here are a few thin …
- 1,385
1
vote
1
answer
5k
views
How do you filter SQL error logs to display specific error messages? [closed]
I find it hard to believe that there aren't better native tools to filter SQL Server Error Logs. Even Windows Logs have better filtering capabilities. I'd like the ability to remove certain events f …
- 1,385
3
votes
1
answer
1k
views
How do you run T-SQL commands on multiple servers from one place?
I have some daily and weekly tasks where I run a script to get the required information. What is the way to running this code once and hitting all the servers without having to log into each one of t …
- 1,385
0
votes
1
answer
1k
views
Strange Log Shipping Error Message
Environment and Server Details:
12.0.4457
Windows Server 2012 R2 standard
VMWare Virtual Machine
Dell Equal Logic SAN
SQL Error Log Message:
The log shipping secondary database ServerName.Data …
- 1,385
0
votes
Initial Full Backup Failing Immediately
I forgot to update this post with what ended up working for me. I don't know why, but running SSMS as Administrator allowed the backup to complete as you'd expect.
- 1,385
1
vote
SQL server Installation
In short, put the OSes on slow storage and all the data/log & backup files on fast storage.
I know that my environment is different that yours, but I think similar principles apply. We have a SAN an …
- 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
4
votes
3
answers
4k
views
Very high I/O on database during a backup maintenance plan
I've recently been having some hellacious problems with a specific maintenance plan. I found that part of the problem was that I had Shrink and Rebuild Index in my nightly plans, those have since bee …
- 1,385
1
vote
Cannot access Properties page of a database
Fixed the issue, but not sure what caused the problem.
I detached/reattached the database and then was able to access the database properties.
It appears that this database lost its owner somehow. …
- 1,385
1
vote
Strange Database Mirroring Problem
I seriously suggest building another system with SQL Server Express and configure it as your witness server. Then set your operating mode to "High safety with automatic failover (synchronous)".
This …
- 1,385
1
vote
Log shipping on secondary server
I've ran into this same problem! As Mr. Vernon stated, the account needs admin access to the server. However, that is not the recommended way of providing access to the service account, especially if …
- 1,385
1
vote
1
answer
49
views
Does database mirroring replicate the time stamp for database backups?
We use Quest Spotlight for database server monitoring. Depending on when SQL server decides to fail over automatically, we will get an alert stating that a database has not been backed up in over thr …
- 1,385
5
votes
1
answer
12k
views
How to convert an XML deadlock file into a graph or something readable?
I'm looking for a easy or manageable way to read an XML file, specifically the XML output for SQL Server deadlocks. I have some servers that are not being monitored for various reasons.
I found the …
- 1,385