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.

Filter by
Sorted by
Tagged with
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 ...
rmwetmore's user avatar
  • 432
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, ...
Sam Saffron's user avatar
  • 2,009
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 ...
rksprst's user avatar
  • 445
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 ...
StarCub's user avatar
  • 247
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 ...
Matt Sheppard's user avatar
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 ...
ScottStonehouse's user avatar
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 ...
CPU_BUSY's user avatar
  • 2,342
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 ...
marc_s's user avatar
  • 1,172
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?
alimack's user avatar
  • 963
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 ...
Pablo Fernandez's user avatar
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 ...
Aaron Daniels's user avatar
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 ...
Heinzi's user avatar
  • 2,237
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 ...
tylerl's user avatar
  • 15.1k
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 ...
Heinzi's user avatar
  • 2,237
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 ...
BradC's user avatar
  • 2,210
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.
Simhadri's user avatar
  • 183
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 ...
Jan Zelezny's user avatar
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?
user2659's user avatar
  • 1,152
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 ...
Achilles's user avatar
  • 422
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, ...
Chris Moschini's user avatar
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 ...
Vinko Vrsalovic's user avatar
  • 1,523
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)...
Matthew Abbott's user avatar
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?
ferdyh's user avatar
  • 183
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 ...
Barry's user avatar
  • 185
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 ...
lmttag's user avatar
  • 197
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 ...
Matthew Scharley's user avatar
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 ...
Hari Gillala's user avatar
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...
Patrick Peters's user avatar
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 ...
ridermansb's user avatar
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 ...
GordyII's user avatar
  • 151
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....
Owen's user avatar
  • 135
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 ...
Kstro21's user avatar
  • 11
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, ...
huelbois's user avatar
  • 113
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 ...
Ashish's user avatar
  • 119
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 ...
René Kåbis's user avatar
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:...
user avatar
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 ...
Paul Farry's user avatar
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 ...
user avatar
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; ...
CJM's user avatar
  • 730
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?
Novice Developer's user avatar
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 ...
Heinzi's user avatar
  • 2,237
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?
hyty's user avatar
  • 441
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 ...
Dave D's user avatar
  • 483
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 ...
Bill Paetzke's user avatar
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 ...
JAG's user avatar
  • 859
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 ...
epotter's user avatar
  • 797
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 ...
Ted's user avatar
  • 353
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 ...
Rivka's user avatar
  • 353

1
2 3 4 5