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
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
0answers
440 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
5answers
18k 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
6answers
16k views

How to rollback a deleted table data?

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

Why would I take a database offline?

For what reasons and in what situations would you use the "Take Offline" / ALTER DATABASE dbName SET OFFLINE feature. What tasks can you perform with an offline database? What tasks can you only ...
5
votes
6answers
847 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
4answers
25k views

How to duplicate MSSQL database on the same or another server?

It is perhaps a bit stupid question, but I must admit I have very limited experience with MSSQL and yet has to accomplish this: Take a snapshot of the database and create and exact duplicate on ...
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
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
8k 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
11k 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
37k 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
1answer
626 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
12k 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
5answers
1k 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
2k 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
8k 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
686 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
8k 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
522 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
2k 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
218 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
3k 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
511 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
9k views

mdf file cannot be overwritten when restoring a database in SQL Server

I got a databse A. It has some data in it. I created a backup for A as A.bak file. Then I create a new empty database B. And then I try to restore B from A.bak. But the SQL Serve tell me the following ...
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
470 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
6answers
13k views

Auto-start the SQL Server Agent after a computer restart

I am using the SQL Server Agent to run some jobs every day, but the problem is that whenever the server (the machine itself) is restarted, the SQL Server Agent doesn't automatically start when the ...
5
votes
9answers
35k views

Can't remotely connect through SQL Server Management Studio

I have setup a SQL Server 2008 Express instance on a dedicated Windows 2008 Server hosted by 1and1.com. I cannot connect remotely to the server through management studio. I have taken the following ...
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
4k 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 ...
5
votes
5answers
11k views

Would the database compatibility level affect performance?

We just migrated our Microsoft SQL Server from 2005 enterprise to 2008 standard on the same specification hardware. The databases were backed up and then restored to a clean sql 2008 install. The ...
5
votes
2answers
2k views

SQL Server 2008 Trace Flag 4135

Does anyone have any idea what this flag does? There is no reference to it on MSDN. It is not a part of the article that lists available trace flags in 2008. There is a KB article that recommends ...
5
votes
2answers
13k 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 ...
5
votes
2answers
13k views

SQL Server 2012 with account NT Service\MSSQLSERVER access is denied in domain

A few months ago we installed SQL Server 2012 in Windows 2008 R2 under the virtual account "NT Service\MSSQLSERVER", all good. A few days ago, one of the admins of the IT dept installed Full Text ...
5
votes
1answer
493 views

MS SQL Server DB version without restoring?

Is there a way of telling which version of Microsoft SQL Server a database backup is from without restoring it?
5
votes
1answer
1k views

On Amazon Web Services what is the difference between SQL Server Standard and SQL Server Web?

I noticed that SQL Server Web is vastly cheaper than SQL Server Standard on Amazon Web Services. Why is that? What am I missing if I use SQL Server Web instead of Standard?
5
votes
2answers
8k views

How to update a CLR Assembly without dropping assembly from SQL Server

How can i update a CLR function (or procedure) assembly dll without having to drop and re-create the assembly in SQL Server (2008 R2)? As it stands now if i update an assembly (e.g. to add a new ...
5
votes
3answers
376 views

How can you recover a SQL Server database if the ldf file has been deleted

We had a drive die and lost the ldf file, but the mdf file is in tact. Is there a process for re-connecting to the mdf file, considering the ldf lost? I have searched without much luck.
5
votes
4answers
4k views

Should I run DBCC checkdb before full backups? Or after?

We have a mix of SQL 2000, 2005, and 2008 servers, and we've always run a DBCC CHECKDB nightly just before the full backups, under the theory that you want to make sure the DB is in good shape before ...
5
votes
3answers
2k views

Do I need to split a database to filegroups? It's 30gb now

I'm in the process of changing a database server at my company from Windows 2000/Sql Server 2000 to a Windows 2003 R2/Sql Server 2005 now. It holds 30 databases, each of the databases is about 7gb in ...