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
4answers
4k views

Ghost Cleanup

my understanding of the ghost cleanup process is that every five seconds it will look to removed ghosted records in an index. and so it will not overload the system, it will only "clean" roughly ten ...
6
votes
2answers
2k views

Renamed a SQL Server, however maintenance plans still have old name

A colleague has renamed a SQL server, however all of the maintenance plans still have references to 'OLD_NAME' as 'Local Server Connection'. The text boxes containing the server names for Local ...
6
votes
5answers
3k views

SQL Server suddenly using only a small portion of CPU

We've got a Windows 2008 R2 server running SQL Server 2008. All of a sudden, the SQLServer process is refusing to go above 20% CPU usage. As of last week, when running a heavy query against the db it ...
6
votes
1answer
1k views

How to upgrade MS SQL Server from 32bit to 64bit

I have a production server, that is used for MS SQL Server Databases. The machine specs are: - Intel Xeon E5410 CPU with (EM64T) - 4 GB RAM - SCSI HDDs in RAID mode It currently has: - Windows ...
6
votes
2answers
12k views

Login failed for “IIS AppPool\ASP.NET v4.0” - SQL Server Web

I'm trying to migrate a website from SQL Server 2008 Express to SQL Server Web, and the website is having trouble accessing the database. In truth, Express was only ever used by running the website ...
6
votes
4answers
3k views

Help! The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log space

We're running SQL Server 2000. In our database, we have an "Orders" table with approximately 750,000 rows. We can perform simple SELECT statements on this table. However, when we want to run a ...
6
votes
12answers
9k views

Move SQL-Server Database with zero downtime

Is it possible to move a sql server 2005 db to a different server running sql server 2008 without any downtime? The system is 24/7 and has to be moved to a different server with different storage. We ...
6
votes
3answers
19k views

Best tool to migrate a PostgreSQL database to MS SQL 2005?

I have a database in PostgreSQL 8.3.1 that I'd like to migrate to MS SQL Server 2005 (or maybe 2008), including both the table schema and the data. The database is about 50GB in size with about ...
6
votes
6answers
3k views

How can I backup an SQL server (2000 and 2005) database?

Currently we backup our MSSQL 2000 and 2005 databases using software to copy files to tape nightly. Database sizes are 14-16Gb and 500Mb. As SQL server can backup a database to a file would we be ...
6
votes
1answer
4k views

Does SQL server log shipping require a 2nd SQL license [duplicate]

Possible Duplicate: Can you help me with my software licensing question? I'm currently working on a high availability solution for SQL Server 2008. I have 2 servers with 1 license of ...
6
votes
3answers
17k views

Why is “DbccFilesCompact” status is “Suspended”?

I am running SHRINK file on a 600G data file. Currently, status is reported as "suspended" and sys.dm_exec_requests.percent_complete for DbccFilesCompact command reports that it is running (but very ...
6
votes
3answers
3k views

Maintenance plan for SQL Server Database Mirroring

We're using SQL Server database mirroring and we're trying to create a db maintenance plan to backup the database. The problem is that when the server is not the primary database the plan fails. I was ...
6
votes
3answers
5k views

Scheduled Jobs during hours of autumn time change

I'm wondering how other people deal with this scenario. What if you have a job scheduled to run at 1:30 am. In the autumn, when time changes, the hour of 1:00:00 to 1:59:59 repeats itself and so ...
6
votes
2answers
12k views

SQL Server: dbo vs db_owner role member?

I'm assinging user to a new database. What is the difference of user being a default dbo user compared to assinging login as a db_owner role member?
6
votes
2answers
21k views

How to create an alias for a named SQL Server instance

On my developer computer I have an SQL Server instance named *developer_2005*. In the resource setting files of a C# application we are creating, the instance name is set to foobar (not really, but ...
6
votes
1answer
130 views

DL380 Gen9 which processor and what impact on NUMA

We are about to build a new server and I was wondering what would the impact on NUMA with the options available. The system will be built using a Proliant DL380 Gen9 8SFF which has 2 sockets, and 12 ...
6
votes
2answers
599 views

Windows File Cache drops suddently

I have a 64-bit Windows 2003 server with 48 CPU cores and 128GB of RAM running a single application (SQL 2008 Analysis Services). SSAS is currently using about 50GB of memory. SSAS relies to a ...
6
votes
2answers
5k views

Certificates in SQL Server 2008

I need to implement SSL for transmissions between my application and Sql Server 2008. I am using Windows 7, Sql Server 2008, Sql Server Management Studio, and my application is written in c#. I was ...
6
votes
2answers
3k views

Perl TDS character sets

I'm using the FreeTDS driver with DBD::Sybase, connecting to an MS SQL Server. When I query certain values of certain records, I get this error: DBD::Sybase::st fetchrow_arrayref failed: OpenClient ...
6
votes
2answers
456 views

sql server maintenance plan

What are the best practices for optimal database maintenance? is updating statistics necessary? (i think statistic update is on by default) how about reorganize indexes or just rebuild them? shrink ...
6
votes
4answers
753 views

SQL Server: How do you check if it's safe to change the SA password?

If I change the SA password for a Microsoft SQL Server, can I see in a log or a trace if some application somewhere is trying to log in with the old password?
6
votes
2answers
1k views

Which type of certificate for encrypting SQL Server?

Does it matter? We buy our certificates from Thawte, and I don't see a special type of certificate for SQL Server as opposed to a certificate you'd buy for a web server. Please be gentle with me if ...
6
votes
2answers
3k views

How to Rename a Database on a SQL Server Amazon RDS Instance?

Attempts via SQL Server Management Studio and Transact SQL to rename a database hosted on a SQL Server Amazon RDS instance result in the following error. User does not have permission to alter ...
6
votes
1answer
6k views

How to upgrade sql server express 2005 to 2008R2

Im using EF 4.1 in visual studio 2010, and I would like my sql server db on the server to be 2008R2 (because I want to use the migration tool from MS for EF in VS). Tool : ...
6
votes
1answer
2k views

Is it possible to redirect (or create an alias) so that requests for a default instance of SQL redirect to a named instance?

Is it possible to redirect (or create an alias) so that requests for a default instance of SQL redirect to a named instance? Scenario is I have SQL 2008 R2 installed as a named instance ...
6
votes
5answers
8k views

Double hop problem with sql server 2008

I'm trying to set up the following scenario. I have 3 servers, they are all in same domain. Server A has web application which runs under (domain) service account, dom\web. Server B has instance of ...
6
votes
4answers
5k views

SQL Server 2008 R2 Error 15401 when trying to add a domain user

I am trying to add a domain user. I am doing the following. Expand Security Right click on Logins Select New Login... Login name select search Click on location and select entire directory Type ...
6
votes
2answers
115 views

What are the basic tasks that need to be done to keep an SQL Server 2005 database healthy

I have a SQL Server 2005 database that is large in every sense. It is complex, it has a lot of data (relatively, but given the lack of blobs, it is still quite large) and it is heavily accessed. What ...
6
votes
7answers
33k views

Can I run SQL Server Management Studio in Windows 7?

I've recently upgraded my OS to Windows 7, but this new OS wouldn't let me install SQL Server Management Studio. Is there a way to get around it?
6
votes
2answers
3k views

MediaWiki on MS SQL Server

I've been doing some digging on running mediawiki on sql server instead of MySQL, but haven't come across any concrete information. All of our servers are running SQL Server so I'd like to stick with ...
6
votes
1answer
888 views

What is the most efficient way to backup a directory full of large database backup files?

We use NetBackup here at Stack Exchange, and I'm working on revamping our backup policy to be more efficient. Currently, we use SQL 2008 R2 and have the SQL run maintenance plans to backup the data ...
6
votes
2answers
368 views

Data from a table in 1 DB needed for filter in different DB

I have a Win Form, Data Entry, application that uses 4 seperate Data Bases. This is an occasionally connected app that uses Merge Replication (SQL 2005) to stay in Sync. This is working just fine. ...
6
votes
2answers
3k views

SQL Server: Statements vs. Batches vs. Transactions vs. Connections

My question is simple: What are the differences / similarities / cardinalities between Transactions Batches Connections and Statements in SQL Server? As far as I understand a connection is a ...
6
votes
2answers
1k views

Listing pending reboots in windows

I'm trying to install SQL Server 2008 on a Windows Server 2008 x86 system, and I'm getting an error saying "Rule 'Restart computer' failed." I've already found a lot of people saying to clear the ...
6
votes
2answers
327 views

SQL Server Management Studio Connect to Server List Editing

I'm using SQLServer Management Studio (2005) and I have a fairly lengthy list of servers in there, and I'd like to get rid of some of them that are no longer in use, without having to set them all up ...
6
votes
0answers
260 views

SQL server language media doesn't support the language of the OS [duplicate]

While trying to install SQL server 2012, I get the error: "SQL server language media doesn't support the language of the OS" I've downloaded the SQL server 2012 in English language only (2 times to ...
6
votes
1answer
541 views

Database Backup and Full-Text Search

I am running SQL Server 2005 EE. When trying to perform a full database backup I receive the error message: Failed to pause catalog for backup. Backup was aborted.BACKUP DATABASE is terminating ...
5
votes
7answers
10k views

How to optimize performance for MSSQL databases?

I'm a dba with a database with ~280 tables, and total datasize of ~1,5GB. I'd like to tune the database to make it perform better. What do you do to keep your SQL databases performant? How much ...
5
votes
5answers
20k 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
27k 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
4answers
8k 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 ...
5
votes
5answers
34k views

SQL Server Issue: Login failed for user 'username'

I am running a copy of SQL Server 2008 Standard and trying to setup a new user login for access to a DB through a web app. I am using Security -> Logins -> Add login to create the user. Login name ...
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 ...
5
votes
2answers
14k views

How to temporarily stop time syncing with domain controller?

I wish to do some testing on my local machine which requires me to put the date forward a year. So I can test some stuff in SQL Server (i've found it not possible to override the sql server time). ...
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
6answers
10k views

How to find when the stored procedure was deleted and who deleted it?

Actually, one of the critical jobs failed while executing. In the error message it was found that the failure is because it was missing a stored procedure. Now how do I find out when was the stored ...
5
votes
6answers
895 views

How to do periodic Sql Server performance monitoring and troubleshooting?

What are the best tools and processes for periodically monitoring and troubleshooting sql server performance issues?
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
4answers
16k views

Is there a way to run sqlcmd to get query output without showing the number of rows affected?

I am running a simple query in SQL Server 2005 and want it to export to a file via sqlcmd. I was hoping to get the results in a csv format without the headers and the query metadata (how many rows ...
5
votes
8answers
5k views

One Database vs. Multiple Databases

I need to design a system which represents multiple "projects", one per client in SQL Server , something similar to StackExchange... same data model, different sites (one per customer). Each project ...