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.

learn more… | top users | synonyms (3)

6
votes
2answers
2k 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 ...
90
votes
8answers
111k views

Dump Microsoft SQL Server database to an SQL script

Is there any way to export a Microsoft SQL Server database to an sql script? I'm looking for something which behaves similarly to mysqldump, taking a database name, and producing a single script ...
22
votes
3answers
51k 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 ...
26
votes
7answers
8k 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 ...
24
votes
8answers
31k 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, ...
11
votes
2answers
12k 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 ...
24
votes
9answers
55k 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 B ...
30
votes
5answers
94k 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?
17
votes
2answers
128k 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 ...
6
votes
4answers
8k 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 ...
4
votes
6answers
6k 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
5answers
21k 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
12answers
28k 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 ...
4
votes
6answers
1k 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 ...
2
votes
1answer
2k 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 ...
13
votes
5answers
11k 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 ...
6
votes
7answers
21k views

How to rollback a deleted table data?

I have deleted one table accidentally how can I rollback that. Please suggest that.
4
votes
5answers
2k 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 ...
3
votes
1answer
622 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: http://serverfault.com/questions/499/how-to-monitor-bandwidth-usage-in-real-terms http://serverfault.com/questions/1259/network-...
0
votes
3answers
243 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 ...
5
votes
4answers
4k 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 ...
2
votes
1answer
239 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?
1
vote
2answers
2k 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 ...
1
vote
2answers
795 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 ...
1
vote
4answers
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
2answers
14k 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
2answers
5k 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
2answers
1k 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 ...
1
vote
1answer
159 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
3answers
2k 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
1answer
87 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 ...
0
votes
5answers
571 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
4answers
392 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
1answer
681 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)...
0
votes
2answers
597 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
1answer
6k 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; ...
35
votes
6answers
43k 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 ...
34
votes
7answers
45k 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 ...
39
votes
7answers
32k 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?
14
votes
4answers
26k views

Recommended disk/partition setup for a SQL Server

I'm looking for some advice regarding the best way to set up my disks/partitions for SQL Server. Here are some of my major concerns: How should the SQL files be seperated (data files, logs, temp)? ...
25
votes
7answers
11k 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 ...
13
votes
23answers
22k views

What is the simplest and fastest way to transfer large file through a Windows network?

I have a Window Server 2000 machine running MS SQL Server that stores over 20GB of data. The database is backed-up every day to the second harddrive. I want to transfer those backup files to another ...
5
votes
3answers
2k views

SQL server in VMware

Please provide your tips and best practices for virtualizing SQL Server in VMWare ESX I am interested in advanced configurations and settings. Please provide reasoning behind your recommendations ...
9
votes
6answers
69k 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 ...
4
votes
8answers
3k views

MS SQL Layout for best performance

We have purchased a new server to act as a MS SQL backend. I am curious to know what the best setup would be for it. The server is a Dell R710 it has 6 hard drives 2x 74GB 15k and 4x 146GB 15k ...
12
votes
2answers
7k views

Find out which database in SQL Server 2005 uses how much RAM

A friend of mine asked me today (trying to calm down an agitated customer of his) how you could find out in SQL Server 2005 which database uses how much memory (in the server's RAM that is) at any ...
9
votes
1answer
4k views

Alias to SQLEXPRESS

I have developer edition from SQL Server 2008, but now I have a piece of software with a hardcoded connection string: Data Source=.\SQLEXPRESS;Initial Catalog=db;User Id=sa;Password=1234; Now I ...
8
votes
2answers
3k views

Correct value for fill factor for clustered indexes with surrogate identity keys

I have a large table which has a clustered index with an identity primary key. I'm deciding on the correct value for the fill factor for this table to minimise page splits. We maintain indexes using a ...
7
votes
7answers
524 views

What do I need to know about running my own dedicated server (with windows 2008)

I'm thinking of getting my own dedicated server with the following stats: Processor: Celeron 440 2.0 GHz Memory: 1 GB Primary Hard Drive : 160 GB SATA II This will be running ...
5
votes
4answers
9k views

Does restoring a SQL database from backup rebuild its indexes?

Does restoring a SQL database from backup rebuild its tables and indexes from scratch? Or does it keep it in the same internal physical order it was in at the time of backup? We're using SQL 2000 ...