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)

9
votes
3answers
7k 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 ...
8
votes
5answers
8k views

Maximum size of SharePoint content databases

Another question from talking to the SharePoint gurus while teaching MCM yesterday. The SharePoint guidelines are that content databases above 100GB are not supported. Without getting into the reasons ...
8
votes
7answers
6k views

Is there anyway to determine who dropped a table?

A table in the production database has 'mysteriously' disappeared. Does anybody know of any way to diagnose what the heck happened to it? And who did it? Edit 1: This is an internal app, with weak ...
8
votes
8answers
53k 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 ...
8
votes
10answers
18k views

Configuring SQL for optimal performance… SSD or HDD?

Does anyone know of any comparisons that show how SSDs compare to HDDs for performance in a SQL environment? I'm trying to understand what type of performance benefit might be gained by moving to SSD....
6
votes
4answers
15k views

MS SQL server: Single or multiple instances?

How costly (CPU or memory wise) is it to have multiple instances of SQL server 2005 instead of only one instance with prefixed databases? A company have three application providers. They each will ...
2
votes
1answer
1k views

what should be monitored for baseline sql server performance

What are the baseline perfmon counters for monitoring SQL Server and what do they mean?
26
votes
6answers
81k views

what are named and default instance?

what are named and default instance? what is the difference between them? why they are used?
8
votes
4answers
17k views

What's your best practice Recovery Model for SharePoint databases

Paul Randal asked some really nice questions about best practices for SharePoint SQL databases. Today, while helping a customer to maintain SharePoint installation he asked me a question about best ...
7
votes
9answers
15k views

MS SQL Server slows down over time?

Have any of you experienced the following, and have you found a solution: A large part of our website's back-end is MS SQL Server 2005. Every week or two weeks the site begins running slower - and I ...
7
votes
3answers
7k views

Current wisdom on SQL Server and Hyperthreading?

Lots of articles out there (see Slava Oks's original SQL 2000 article and Kevin Kline's SQL 2005 update) recommend disabling hyperthreading on SQL servers, or at least testing your specific workload ...
4
votes
5answers
51k views

Cannot login to SQL Server 2008 R2 with Windows authentication

When i try to connect to SQL Server (2008 R2) using Windows authentication: i cannot: Checking the Windows Application event log, i find the error: Login failed for user 'AVATOPIA\ian'. ...
4
votes
5answers
1k views

mysqldump for sql server [closed]

I have used mysqldump on a mysql database lots of times and am familiar with how it works. Does anyone know if there is a similar tool that could be used on a sql server database. I know sql server ...
4
votes
4answers
838 views

Creating a SQL server Maintenance Plan without the wizard

Is there a way to generate a SQL server maintenance plan that will be the same as the one generated by the wizard, but without going through the wizard dialog. I need something that can be created ...
3
votes
1answer
711 views

Possible disk IO issue

I've been trying to really figure out what my IOPS are on my DB server array and see if it's just too much. The array is four 72.6gb 15k rpm drives in RAID 5. To calculate IOPS for RAID 5 the ...
3
votes
2answers
450 views

How do you backup a database within SQL Server 2005 from the command line?

I need to create a scheduled task that will backup a database within a SQL Server 2005 instance. Is there a command line argument that I can use to achieve this?
3
votes
3answers
6k views

How does the LeftHand SAN perform in a Production environment?

I previously asked this ServerFault question: Does anyone have experience with lefthands VSA SAN The general consensus looks like it does not perform well enough for a production SQL server even at ...
2
votes
5answers
1k views

Should the Database be on the same box as the web server or separate

Im using SQL Server 2005 and IIS6. I have each on separate boxes (Quad cpu, 4G). Client wants to consolidate on to one box. This is an Enterprise application with 400 users. Performance is good now, ...
2
votes
3answers
20k views

SQL Server: Memory Usage High (7GB) + Page File Usage High (7GB) but CPU Usage (2% to10%) [duplicate]

Possible Duplicate: SQL Server memory constantly going up, from 1GB RAM used to 7GB in a week. Hello all, I am running SQL server with a lot of scripts that update large amounts of data (...
2
votes
1answer
20k views

SQL Server setup media does not support the language

I'm getting the following error when i try and install MSSQL 2008 on Windows Server Standard 2008 R2:
6
votes
3answers
55k views

How are SQL Server CALs counted? [duplicate]

Possible Duplicate: Can you help me with my software licensing question? Running a SQL Server, as far as I understand it, you need one CAL for every user who connects to the database server. ...
5
votes
4answers
2k 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, ...
5
votes
1answer
660 views

Virtual vs. Named SQL Instances

What are the benefits to using virtual as opposed to running multiple instances of SQL on a box?
4
votes
1answer
12k views

installing PHP for IIS8 on a windows server 2012 machine?

We are running a web server IIS8 on a windows server 2012 machine. I need to install PHP on it. I found a nice tutorial here: http://www.nutstech.info/2012/09/windows-server-2012-server-core-setup....
4
votes
6answers
15k views

SQL Server 2008 login problem with ASP.NET application: Failed to open the explicitly specified database

I am running SQL Server 2008 Express Edition on Windows Server 2008 with an ASP.NET application which must access the server. The ASP.NET application is associated with an application pool that runs ...
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 ...
4
votes
9answers
10k views

SQL Server 2008 failover strategy - Log shipping or replication?

We just moved from SQL Server 2000 to SQL Server 2008. We were using our own log shipping on 2000 for failover. For 2008, we need to decide to use our own log shipping, built in log shipping, or ...
3
votes
3answers
7k views

What's using all my memory?

SOLUTION: There's a lot of stuff to read in this thread, so i'll just summarize here to help. The problem is the VMWare ESX balloon driver which "inflates" the amount of memory "in use" that the ...
3
votes
3answers
11k views

DBCC CheckDB The operating system returned error 21(The device is not ready.)

The operating system returned error 21(The device is not ready.) to SQL Server during a read at offset 0x0000000001c000 in file 'E:\SQL Database\S***d\NewAdvWorks.mdf'. Additional messages in the SQL ...
3
votes
10answers
2k views

Freeing up disk space

I am a newbie in administering systems (as I am a developer), but lately, I am doing basic admin tasks on windows servers. We have an automated process that restores a database that failed with the ...
3
votes
3answers
2k views

What is the best practice for the database owner in SQL Server 2005?

What is the best practice for the database owner in SQL Server 2005? I have already searched this page... http://technet.microsoft.com/en-us/sqlserver/bb331794.aspx and didn't find what I was ...
3
votes
2answers
6k views

Too Many winlogon.exe LogonUI.exe csrss.exe open on server?

I just had to restart my content server because it bogged out. Everything was fine after i restarted IIS and SQL Server, but then i opened the task manager and found the following. I've never seen ...
2
votes
2answers
772 views

How do I configure SQL Server 2005 to accept a connection to a private or internal IP address on a private network?

I'm in unfamiliar territory, but here's the scenario: I have an application server and a database server, and both are on a private network. How do I allow connections from my app server to the ...
2
votes
4answers
1k views

Transferring data between SQL Server and MySQL

We host a couple of SQL Servers where we are planning to upgrade the environment (still classic asp). We are looking whether to move to a LAMP (or WAMP) environment instead of just following the ...
2
votes
2answers
349 views

mysql to ms sqlserver

How can I convert database from Mysql to SqlServer 2005?
2
votes
10answers
602 views

SQL2005 vs SQL2008

We are investigating replacing an existing SQL2000 server on Windows2003 (32Bit) with new hardware and a newer version. We are looking at an application that requires at least SQL2005, but will run ...
2
votes
1answer
599 views

error setting up replication from mssql to mysql

I'm trying to setup replication from SQL Server 2005 to MySql 5.1.53. I am able to add the publication without any problem. However, when I go to add the subscription I get this error: OLE DB or ...
1
vote
8answers
4k views

Need a resource that lists WMI perfmon classes

Does anyone have links to resources that list perfmon classes that are called by the WMI Query Language? I have some monitoring software that can pull data via WMI but I have to enter a query in WMI ...
1
vote
1answer
1k views

SQL Server 2005 Accidentally removed a user from public role, can't add user back into role

I'm trying to crearte a DB user account that only has access to a specific database, and can't read or change other databases, and can't alter credentials for any other accounts. I accidentally ...
1
vote
3answers
3k views

What permissions are required for SQL Server to run as a (active directory) domain user

I wish to switch the SQL Server 2005 service from running as a local user to running under a domain user (mainly so I can make backups to domain-permissioned shares). I can't seem to find a ...
1
vote
4answers
25k views

Permission denied when creating database in Sql Server 2008 express

Running the following (generated by Sql Server Management Studio) on Sql Server 2008 Express under Vista: CREATE DATABASE [test] ON PRIMARY ( NAME = N'test', FILENAME = N'c:\Program Files\Microsoft ...
1
vote
3answers
1k views

Very slow harddisk performance

Today I was trying to execute a long-running (but highly optimized) query on a server in our company. I've run the same query on the same data on my home computer (5400rpm harddisk) and it took about ...
1
vote
3answers
2k views

How do I properly set up SQL Server Profiler in a production environment?

In our production environment (SQL Server 2008 Enterprise), we've been having issues with CPU usage and network utilization. Based on the specs of the (multiple) machines we have and the general ...
1
vote
3answers
9k views

Can I change a live SQL Database from Autogrow safely?

I have a live SQL 2005 database, and am in the very unfortunate position of being the involuntary DBA. The database has an MDF file that is 1.4 GB, and an LDF with 2.2 GB. The Autogrowth is set to ...
1
vote
5answers
6k views

Recovering a specific job definition from an MSDB backup?

We've been asked to recover a specific SQL 2005 job from how it existed at a certain time in the past. We have MSDB database backups from that time period, but I can't overwrite the current MSDB ...
0
votes
1answer
169 views

Application Compatibility Clients do not show in MSSQL database, but do show in \AppCompat\

Application Compatibility Clients are denied access to the central MSSQL database, but are able to leave their own files in the \AppCompat\ share. The only computer that shows up in the "Microsoft ...
7
votes
1answer
10k views

How can a Perfmon “% Processor Time” counter be over 100%?

The counter, Process(sqlservr)\% Processor Time, is hovering around 300% on one of my database servers. This counter reflects the percent of total time SQL Server spent running on CPU (user mode + ...
6
votes
4answers
5k views

PhpMyAdmin for Sql Server

Does anyone know of a similar tool as phpmyadmin for sqlserver ? Especially the data dump is very handy. But also updating etc, without needing to remotely logon etc. is nice.
5
votes
2answers
5k views

How can I backup a SQL Server 2008 R2 DB without taking it offline?

I am familiar with the detach/attach process. But I cannot take the database offline. Is there a way to back a database, and end up with a usable mdf database file, without taking it offline?
5
votes
3answers
4k 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 ...