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 (4)

23
votes
8answers
25k 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, ...
6
votes
2answers
1k 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 ...
68
votes
9answers
63k 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 ...
17
votes
3answers
27k 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 ...
15
votes
2answers
87k 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 ...
26
votes
7answers
7k 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 ...
9
votes
2answers
11k 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 ...
21
votes
9answers
45k 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 ...
4
votes
4answers
7k views

Optimising MSSQL 2008 server inside VMWare ESXi

I normally run my MSSQL servers on dedicated servers, but we've taken on a client who is running their SQL Server inside a VMWare ESXi 4 host, and quite frankly it's running like crap. We have ...
3
votes
1answer
614 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 ...
16
votes
6answers
8k views

SQL Database physical file fragmentation

I know that there are really three kinds of fragmentation that I need to be concerned about as a DBA: Index Fragmentation in the SQL data files, including clustered index (table) fragmentation. ...
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?
18
votes
8answers
168k views

How do I get this SQL Server ODBC Connection working?

Note: I've obviously changed the server names and IPs to fictitious ones. Here's what's going on. I've got a server, which I'm calling MYSERVER, running Microsoft SQL Server Express 2005. Right on ...
5
votes
5answers
17k 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 ...
4
votes
12answers
17k 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 ...
2
votes
1answer
1k 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 ...
4
votes
5answers
1k 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
3answers
268 views

What daily checklist items are there for coldfusion, iis7, sql server administrators?

That is going to be part of a site app tool i am creating that has many different functions. But my question today, is for sql, iis, coldfusion administrators, what kind of daily checklists, do you ...
5
votes
6answers
14k views

How to rollback a deleted table data?

I have deleted one table accidentally how can I rollback that. Please suggest that.
4
votes
3answers
3k views

“Cannot perform a differential backup for database ”myDb“, because a current database backup does not exist.”

I have what seems to be a pretty common problem when trying to take a differential backup. We have a SQL Server 2008 Standard (64bit) and we use Litespeed v 5.0.2.0 to take our backups. We take full ...
4
votes
4answers
3k 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 ...
3
votes
8answers
6k views

How to stop Log file from growing in SQL Server 2008?

In my application right after restore I perform many(>100,000,000) updates to the newly created database. Thus, LOG files grows significantly. How can I stop it from growing? NOTE: Setting recovery ...
2
votes
1answer
178 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
4answers
450 views

SQL server failover clustering

How many failover clustered nodes can you have?, and if you add more and more nodes, is it going to slow down?
1
vote
2answers
957 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
2answers
445 views

Distributing SQL Server on Internet regarding security issue

We are going to put our servers in two places to keep high level redundancy and to avoid bandwidth critics. The two servers are on different LANs but communicate over a WAN network (via Internet). One ...
1
vote
1answer
291 views

Attempting to open a dll whenever logging on to server after SQL Server upgrade to 2008 R2

The environment is Windows Server 2003 SP2 32-bit, SQL Server 2008 R2 SP1 When logging on to the server the following message box is displayed 'you are attempting to open a file of type 'application ...
1
vote
3answers
1k 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
76 views

clustering MS SQL 2008 [duplicate]

Possible Duplicate: Sql server active/passive vs active/active clustering I have a Project in DBMS just I need something like a BIG TITLES of What TO DO. Here a brief way about the ...
1
vote
1answer
149 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
2answers
836 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
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
1answer
84 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
3answers
906 views

sql server: cannot open backup device

i am doing a backup: BACKUP DATABASE timeclockplus TO DISK = 'c:\bak.backup' and i am getting this error msg: Msg 3201, Level 16, State 1, Line 1 Cannot open backup device 'c:\bak.backup'. ...
1
vote
0answers
91 views

Problem with MSDE 2000 5 minute keepalive over ISDN

We have a SQL Server transactionally pushing replicate data to an MSDE 2000 SP3a subscriber over ISDN. Prior to a recent upgrade to bring us to the MSDE 2000 level we pushed to MSDE 1. We are finding ...
1
vote
5answers
615 views

Setting up a SQL server outside the domain

im very new to this. I've set up an account "SQLBOX" thats on the a network, but not connected to the domain. I have installed an instance of SQL Server 2008 and am trying to connect to it from ...
1
vote
2answers
733 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
179 views

Recommended Server RAM for SQL Full Text Search (FTS) [closed]

I gather SQL Server 2008 Express requires a minimum of 512MB RAM to be installed to run on Windows Server 2003, however will this be sufficient to also run Full Text Search on about 50,000 records? I ...
1
vote
2answers
10k 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 ...
0
votes
2answers
325 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
3answers
171 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
2answers
228 views

Force close of MDF file

I have an MDF file that is being held open by another computer. The MDF file sits on a shared folder and the server that normally holds the MDF file open is shut down. However, when I attempt to ...
0
votes
2answers
2k 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...
0
votes
1answer
3k views

The server principal “sa” is not able to access the database “MyDb” under the current security context

We're getting this error and nothing we've tried so far has worked: TRUSTWORTHY ON exec sp_change_users_login 'Auto_Fix', 'sa' sa is mapped to user dbo and dbo is the database owner. Any help ...
0
votes
1answer
5k 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; ...
0
votes
2answers
627 views

PHP 5.2.11: Unable to load dynamic library complaints

I installed PHP 5.2.11 and upon enabling the php_mssql.dll module (and the obligatory restart of the services) started receiving warnings about not being able to load the dynamic library. The ...
0
votes
5answers
539 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 ...
0
votes
2answers
8k views

How to open port 1433 on windows 2003

How can I enable port 1433 on windows server 2003 to enable SQL connections? I don't have any hardware firewall just plain windows 2003 with sp2
0
votes
4answers
382 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 ...
37
votes
22answers
14k views

PowerShell? Do you use it? Can you show me some cool system administration things I can do with it? [closed]

I keep reading everywhere that PowerShell is the way of the future. When it was first released I did a whole bunch of virtual labs, but since then I still haven't used it in a production environment. ...