Questions tagged [sql-server]
Questions related to Microsoft SQL Server. If your question is version specific please tag it specifically for that version as well. Does your SQL Server question belong here or on another site? Click the about the SQL Server tag link on the line below.
209
questions
31
votes
7
answers
91k
views
Setting Low Disk Space Alerts on Windows Server 2008
I was wondering if there is an easy way to trigger an e-mail alert on Windows Server 2008 when any logical disk partitions become low on space. I have 2 SQL servers that have come close to running ...
28
votes
8
answers
39k
views
Will disabling hyperthreading improve performance on our SQL Server install
Related to: Current wisdom on SQL Server and Hyperthreading
Recently we upgraded our Windows 2008 R2 database server from an X5470 to a X5560. The theory is both CPUs have very similar performance, ...
8
votes
2
answers
3k
views
SQL Server memory constantly going up, from 1GB RAM used to 7GB in a week
I have a ~45GB database that increases rapidly (~1GB every week).
So it's doing a lot of inserts; the web app doesn't have many users so reads are low right now.
But I'm noticing that the RAM sql ...
5
votes
6
answers
3k
views
What should I do if I find someone is brute forcing my server password?
I just checked the eventlog on my vps and found that someone is brute forcing both my sql server sa password and windows administrator password. (I have changed the account name from Administrator to ...
147
votes
9
answers
250k
views
How to dump a Microsoft SQL Server database to a SQL script?
Is there any way to export a Microsoft SQL Server database to a SQL script?
I'm looking for something which behaves similarly to mysqldump, taking a database name, and producing a single script which ...
24
votes
9
answers
63k
views
SQL Server to SQL Server linked server setup
Please explain what is required to set up a SQL Server linked server.
Server A is SQL 2005 Windows logins only .
Server B is the same (SQL 2005 Windows logins only) .
Server A runs Windows XP .
Server ...
27
votes
7
answers
9k
views
SQL Server disk design on an ISCSI SAN
Its standard practice to separate log and data files to separate disks away from the OS
(tempdb, backups and swap file also)
Does this logic still make sense when your drives are all SAN based and ...
11
votes
2
answers
13k
views
SQL Server 2005 / 2008 - multiple files / filegroups - how many? Why?
I'm a developer at heart - but every now and then, a customer doesn't have a decent DBA to deal with these issues, so I'm called in to decide....
What are your strategies / best practices when it ...
67
votes
4
answers
285k
views
Get a list of SQL Server Agent Jobs
I've got an extensive selection of these to add to a spreadsheet and don't want to go through by hand.
What it the T-SQL command(s) to generate a list of SQL Server Agent Jobs?
18
votes
2
answers
156k
views
I cannot connect to my local SQL Server 2008?
I've just installed SQL Server 2008 and I cannot connect to it with SQL Server Management Studio. My intention is to just let my local windows user be authenticated but I am not totally sure how to do ...
13
votes
5
answers
12k
views
SQL Server 2005: There is insufficient system memory to run this query
One of our SQL Servers, which has been running stable for quite some time (years), has recently been throwing insufficient memory errors. From the Application Event Log, we see:
Event ID: 701
...
11
votes
4
answers
24k
views
How can I backup an SQL Server database using Windows Server Backup?
Apparently Windows Server Backup has some support for backup of SQL Server databases:
Ability to recover applications. Windows Server Backup uses VSS functionality that is built into applications ...
10
votes
4
answers
16k
views
SQL Server Backups using Volume Shadow Copy
Many well-known backup utilities for Windows use the Volume Shadow Copy Service built in to newer versions of windows to create a point-in-time snapshot of the disk in order to safely back up open ...
8
votes
2
answers
29k
views
SQL Server Windows Authentication fails after tonight's security updates: The login is from an untrusted domain
We have the following setup:
One Domain Controller (DC, Server 2003 R2 Standard x64)
One SQL Server (SQL, Server 2008 R2 Standard x64)
some clients.
All machines are in the same domain. All user ...
6
votes
4
answers
6k
views
SQL transaction log backups conflicting with full backups?
On our SQL servers (2000, 2005, and 2008), we run full backups once a day in the evening, and transaction log backups every 2 hrs. We haven't really worried about these two processes conflicting, but ...
6
votes
7
answers
35k
views
How to rollback a deleted table data?
I have deleted one table accidentally how can I rollback that.
Please suggest that.
5
votes
5
answers
31k
views
Don’t have permission to access SQL Server Express 2008?
I have a remote PC with SQL Server 2008 setup and allowing remote connections.
I am an Admin user on the PC and have remotely connected to the SQL Server and I am trying to restore a database from ...
5
votes
6
answers
8k
views
SQL Server licensing, is it per CPU? So a 32 CPU would mean like 150K in licensing? [closed]
SQL Server licensing, is it per CPU? If yes, so a 32 CPU would mean like 150K in licensing?
5
votes
12
answers
51k
views
SQL Server database on an external hard disk drive
Due to some security problems, My boss has asked me to store all sensitive data in external/removable storages like USB stick or external HDD and this specially includes the MDF/NDF/LDF files of SQL ...
5
votes
5
answers
3k
views
Lock Windows Disk for Backup (EC2 Snapshots)
I'm looking for a way to flush all pending writes to disk in Windows, then buffer all future writes until a command gives the go-ahead.
I'd like to flush SQL Server writes and Windows system writes, ...
4
votes
6
answers
2k
views
Hidden Features of SQL Server
On SO hidden features SQL Server we got a lot of useful stored procedures.
What hidden features should we know to tune our SQLServer database server?
PS
Here is the similiar question about ...
3
votes
1
answer
648
views
windows server 2003 monitoring software combining SQL Server monitoring with CPU-IO stats
I'm aware this type of question has been asked many times before:
How to Monitor Bandwidth usage in real terms
Network monitoring
application monitoring tools
Network Traffic Monitoring
...
3
votes
1
answer
3k
views
Windows Filtering Platform dropping SQL Server connections
I've been investigating connection issues between my web server (Web01) and a database server (Database01). My current setup:
Web01 - two NICs, one external (firewalled), one internal (not firewalled)...
2
votes
1
answer
361
views
Microsoft SQL alternative for Oracle's Imp and Exp command
I'm looking a command line tool or SQL command to export/import a table or complete database. Much like the imp and exp commands of Oracle databases.
Any suggestions?
2
votes
2
answers
3k
views
SQL Server Remote Connections
I am at my wits end with trying to access a remote SQL Server 2008 R2 Express instance.
Here are the following that I have tried.
1) I enabled remote connections in the instance properties.
2) I ...
2
votes
1
answer
3k
views
How to Deploy an ASP.NET Web API- and Browser-based Application to a Production Environment [closed]
(Please forgive if this is posted in an incorrect forum. We didn’t know exactly where to post it.)
We have an ASP.NET Web API single page application - a browser-based app running in IIS to serve up ...
2
votes
2
answers
34k
views
How to recover a MSSQL user's password?
I've been tasked with moving us from one decade old system (Access '97) to a brand new system using MS SQL Express 2008 as a backend. So great, I know I can connect to the database (successful with a ...
1
vote
1
answer
193
views
SQL- Encryption Database
I have taken backup from the live environment and trying to use it on the local box. The database in the live is encrypted with a key.
I have restored the database to localbox and cannot run any ...
1
vote
2
answers
10k
views
Sql server active/passive vs active/active clustering
What is the difference between SQL Server clustering methods:
- Active/Active
- Active/Passive
in simple worlds and an example usage scenario per method...
1
vote
3
answers
3k
views
Attempt to access SQL Server with the user SA
I'm suffering an attempted invasion by brute force. A bot is trying to figure out the sa password. How do I restrict logins 3 attempts in SQL Server?
Moreover, I would like to block an IP, how can I ...
1
vote
4
answers
1k
views
Why upgrade from SQL 2005 to SQL 2008 R2?
have been tasked to write a document outlining the best reasons to use SQL 2008 R2 instead of SQL 2005 for my brand new BI project. We have a policy of only using two versions at a time and there are ...
1
vote
2
answers
923
views
SQL Server wont start on my 64-bit virtualization slice
I have installed SQL server 2008 express on a 64-bit virtual box and the service wont start.
Looking at the event log I get:
Could not create tempdb. You may not
have enough disk space available....
1
vote
1
answer
95
views
SQL Server 2000 daily backup, need advice
HI all, in my company there is a SQL Server 2000, they ask me to make a backup plan for it, for example:
database #1:
1- they want a complete backup every 15 days (done).
2- they want a differencial ...
1
vote
1
answer
537
views
Terrible performances using a remote Azure SQL Database
We're currently evaluating Azure's SQL Database service (vs local installation) because we would like to have the "Always Encrypted" feature integrated in our (java-based) application.
Problem is, ...
1
vote
2
answers
2k
views
Memory Usage of SQL Server
SQL Server instance on my server is using almost full memory available in my Physical Server.
Say if i am having 8GB of RAM than SQL Server is using 7.8 GB of RAM from system.
I also have read ...
0
votes
2
answers
734
views
Just a few questions about Hyper-V virtual machines and clustering
I have been using Microsoft’s Hyper-V technology for a little while now, but I am just now dipping my toe into clustering.
In particular, I am trying to implement a fault-tolerant SQL DB. This ...
0
votes
5
answers
733
views
Connecting to local Sql server 2005 through Internet
My Sql server is on Local Machine,
I want to access it through Internet.
I Configure Surace manager and Configuration manager
of sqlserver 2005 for remote access.
My sqlserver is running on port:...
0
votes
4
answers
418
views
Why some XP installs don’t automatically Start SQL2005 Service (Instance)
I have a number of XP machines that have a SQL 2005 Instance running on them, and they are set to start automaticly in Service Control Manager.
On 1 or 2 of these machines when you reboot, the SQL ...
0
votes
3
answers
342
views
Sql Server Database Restore
I am working in Sql Server 2008. The Issue is when i restore the database the database users get disable i can map that particular user with the Login user. For mapping i have to remove the user from ...
0
votes
1
answer
10k
views
Maintenance Cleanup Task(s) running 'successfully' but not deleting back up files
I have a maintenance plan setup for all my user databases on a particular server, which does all the usually things at various intervals.
The 7th and final subplan is a two stage cleanup plan; ...
47
votes
7
answers
43k
views
Is it safe to have SQL Server auto-shrink turned on?
There are many SQL Server options that can be enabled for databases, and one of the most misunderstood ones is auto-shrink. Is it safe? If not, why not?
42
votes
6
answers
174k
views
What are named and default instances?
What are named and default instances?
What is/are the difference(s) between them?
Why they are used?
41
votes
6
answers
57k
views
SQL Server (2005/2008): Does full backup truncate the log in full recovery mode
I've just read through a lot of MSDN documentation and I think I understand the different recovery models and the concept of a backup chain. I still have one question:
Does a full database backup ...
38
votes
1
answer
101k
views
What can user do with VIEW SERVER STATE permissions?
In SQL Server 2008 there is a permissions VIEW SERVER STATE. What rights this permission give to user? What SQL Server mean by SERVER STATE?
38
votes
7
answers
54k
views
How do I reduce transaction log backup size after a full backup?
I have three maintenance plans set up to run on an Sql Server 2005 instance:
Weekly database optimisations followed by a full backup
Daily differential backup
Hourly transaction log backups
The ...
30
votes
7
answers
19k
views
Is it OK to run perfmon on production servers? And why?
Or should perfmon be limited to a Dev/QA server with load tests that simulate production activity?
I'd like to run perfmon for two days (like Sql Server master Brent Ozar suggests) to get an overall ...
26
votes
11
answers
175k
views
Can't connect to SQL Server using 'sa' account, what I'm missing?
I'm trying to log in to a SQL Server 2005 Express instance using the following command:
osql -S .\INSTANCE -U sa -P password
I get the error: Login failed for user 'sa'.
I can connect just fine ...
25
votes
4
answers
35k
views
In SQL Server, how do I create a login for an existing user?
I restored a database from one SQL Server instance on to a different SQL Server instance. The database allready has users added to it. But they don't have Login's for the new SQL Server instance.
I ...
25
votes
4
answers
247k
views
Install SQL CLR types & Report Viewer 2012 on Sql 2008 server
I'm in the process of installing a client's ASP.net site on a Windows Server 2003 box running Sql 2008.
The site uses Report Viewer 2012, but when I attempted to install it on the server, I got the ...
19
votes
14
answers
269k
views
SQL - an error occurred during the pre-login handshake
Until yesterday evening, I was able to connect to my server from my local machine. Now, I get the following error:
A connection was successfully established with the server, but then an error ...