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

Backup SQL Server to a Network Share

How do you backup an SQL Server Database to a Network Share?
6
votes
2answers
901 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
1answer
4k 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
5answers
7k 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
4k 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
1answer
1k views

Delete performance for LOB data in SQL Server

This question is related to this forum thread. Running SQL Server 2008 Developer Edition on my workstation and an Enterprise Edition two-node virtual machine cluster where I refer to "alpha cluster". ...
6
votes
2answers
113 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
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
749 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
317 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
2answers
365 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
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
482 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
9k 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
6answers
18k views

How to rollback a deleted table data?

I have deleted one table accidentally how can I rollback that. Please suggest that.
5
votes
5answers
19k 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
4answers
7k 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
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
5answers
32k 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
6answers
862 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
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
8answers
6k views

Can Oracle and SQL Server exist on the same server?

We want to install SQL Server on a legacy machine which is running Oracle. Is there any reason why they cannot coexist on the same machine?
5
votes
4answers
14k views

How can I add myself to my local sql server's windows authentication?

IT recently re-setup my laptop with 64bit windows. He installed Sql Server dev edition for me and set it up with a username and password. I logged in and tried changing Sql Server to windows ...
5
votes
6answers
26k views

cannot add a user to sysadmin role in SQL Server

I am using SQL Server 2008 Management Studio. The current logon account belongs to machine local administrator group. I am using Windows Integrated Security mode in SQL Server 2008. My issue is, ...
5
votes
2answers
6k views

Clustered indexes versus non-clustered indexes?

I am in charge of a smaller DB 300+ hundred megs 100'ish tables about 45 users hit it throughout the work day. Mostly reads, but a fair number of updates and inserts. I have been slowing learning the ...
5
votes
8answers
9k views

How do I copy a SQL Server 2005 Database?

In my environment I need to copy a database from one server to another. Usually a QA machine to my local box. I do not have access to QA machine. I can connect to the database, but not RDP into the ...
5
votes
3answers
13k 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
3answers
43k 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 ...
5
votes
5answers
13k views

How to rename a project in the Team Foundation Server (TFS)

How to rename a project in the Team Foundation Server 2008? What are khown issues?
5
votes
6answers
44k 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 ...
5
votes
1answer
635 views

Virtual vs. Named SQL Instances

What are the benefits to using virtual as opposed to running multiple instances of SQL on a box?
5
votes
5answers
2k views

Using SAN Replication/Snapshots for SQL Server disaster recovery?

We have a web application that utilizes SQL Server 2008 on a single database server. All storage is local. For the past year we have been trying to get any form of SQL Server Replication to work ...
5
votes
7answers
1k views

Optimizing performance across thousands of SQL Server databases

We are building an application where each client will have their own database. None of the databases are particularly large (20MB to 400MB each), but there will be ~5,000 to start and at any one time ...
5
votes
3answers
3k views

SQL Server 2008 R2 Enterprise database has unexpected 4GB database size limit

I have SQL Server 2008 R2 Enterprise installed on a local Windows 7 x64 workstation. When I create a database on the server, it unexpectedly has a 4GB size limit (Database properties in SQL Server ...
5
votes
4answers
9k views

Enable SQL Server to backup on remote machines/drives

I have a SQL Server (2000, 2005 and 2008) and I'd like to use SQL Agent (or even a simple backup database 'xxx' to disk = 'yyy'), to backup to remote drives. I.e: i have a mapped drive in the SQL ...
5
votes
4answers
739 views

Geographical DB synchronus mirroring

An architect in our company has designed a solution based on 64 bit SQL2005 Standard edition synchronous mirroring between a physical (4 quad core, 32GB RAM) server and a virtual DR server (4 virtual ...
5
votes
6answers
14k views

SQL Server 2005 Service Pack 3 won’t install

I am trying to install SQL Server 2005 Service Pack 3 and it keeps failing. Comes back with the following: Microsoft SQL Server 2005 - Update 'Service Pack 3 for SQL Server Database Services 2005 ENU ...
5
votes
3answers
3k views

SQL Server Collation settings for System Center Service Manager 2012

There is a lot of conflicting or confusing information surrounding the required collation settings for SQL Server, as it pertains to hosting the SCSM 2012 database and associated data warehouse ...
5
votes
2answers
9k views

How to allow the local Administrator to have access to SQL Server?

One of our clients has an installation of SQL Server Express 2008 R2 that we more or less manage for them. Today I need to create a new database(a fairly rare occurrence). So I go to login as the user ...
5
votes
3answers
651 views

Simplest way to export a SQL Server database

Using SQL Server 2008, how do I export a database to mdf so that I can attach it on another machine? (using "Attach") I tried detaching it (the english opposite of attach), but it didn't work out too ...
5
votes
2answers
3k views

How can I use powershell scripting to change SQL Server Aliases?

I have an x64 machine that regularly needs about 10 aliases changed in the SQL Server Client Network Utility (cliconfig) for both the x64 and x86 sides of the registry. Is there a way I could do this ...
5
votes
3answers
222 views

Repeatable, reliable SQL Server deployments

What is the best way to set up a SQL Server deployment that can be easily repeated across multiple virtual servers? Does Microsoft provide something for this, or perhaps Powershell scripts?
5
votes
3answers
5k views

New Windows 2008 Disk Partitioning Offset question - should I worry about it?

We're about to hardware upgrade our exisiting Sql 2008 Server. So, I'm checking out some best practices with regards to hardware, like .. RAID levels for the HD and making sure the TempDB is on a ...
5
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 ...
5
votes
4answers
512 views

Upgrading Sql Server 2000 to 2008

At my place of employment we have been thinking about upgrading from SQL Server 2000 to the latest (2008). We know that the DTS packages will have to be dealt with since the newer server software no ...
5
votes
3answers
2k views

Certain SQL queries performing very poorly in ESXI hosted environment

We recently set up a new machine with 8 dual-core CPUs, 20 GB RAM, and 3 1-TB drives set up in a RAID of some sort resulting in 2 1-TB drives we actually get to use (I'm not the hardware guy here). ...
5
votes
6answers
498 views

How to transfer a Database on a weekly basis for analysis purposes

Just wondering what kind of processes you guys have for transferring production data offsite for analysis purposes? I have read some of the literature but I am not sure of the overheads involved and ...
5
votes
2answers
1k 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 ...
5
votes
5answers
2k views

How do you configure a MS SQL Server to prevent exposing all database names and logins to any authenticated user?

I'm new to MS SQL and asking this question as a web developer with limited sysadmin experience who desires his service providers to use best practices. We have one database on a remote MS SQL server ...
5
votes
2answers
5k views

High-availability on SQL Server, cons and pros of solutions?

I'm studying about high-availability on SQL Server for my thesis. I've learned there're several solutions to archive this: Failover clustering Log shipping Replication As I know, these solutions ...