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)

5
votes
8answers
5k 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
32k 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
4answers
11k 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
1answer
8k views

SQL Server Browser: Why is it disabled?

I am attempting to start SQL Server Browser through the SQL Server Configuration Manager. However, not only is the "state" of SQL Server Browser stopped, but the options to Start, Stop, Pause, ...
5
votes
1answer
609 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
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
6k views

How do I restore a batch of transaction logs rather than one by one

I have a SQL Server database that backs up the transaction logs every 10 minutes, with an overnight full backup. Using SQL 2008 Management studio we seem to have to select each transaction log one ...
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
7k 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
644 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
2k 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
7k 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
434 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
509 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
6k 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
1k 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
459 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
3answers
2k 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 ...
5
votes
9answers
28k 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
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
10k 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
11k 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
1answer
455 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
3answers
290 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 ...
5
votes
3answers
12k 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 ...
5
votes
4answers
5k views

How can I get alerted when auto-growth occurs on a SQL Server database?

Our SharePoint databases are set to the (nonsensical) 1MB default autogrow out-of-the-box, and I need to "convince" our application owner that this is wrong. Is there a means to monitor the autogrow ...
5
votes
1answer
1k views

Should I Use the Default SQL Server 2012 Accounts or Make Specific Ones?

I'm installing the 180 day trial of SQL Server 2012 on a virtual machine with the intent of buying a license for it later on. From past experiences with installing SQL Server I would always make ...
5
votes
1answer
723 views

MSSQL 2008 R2 server roles: do server roles have implicit privileges over *all databases*?

I'm setting up a continuous integration solution involving .NET solutions and MSSQL 2008 Databases. All my build servers sit in an AD security group called Build Servers. I've created the ...
5
votes
1answer
6k views

Why does sp_send_dbmail fail inside SQL Agent jobs?

I have a simple query that I run to send email notifications to our AD account administrators when accounts have been disabled for more than 30 days. It works perfectly fine when I run it on my own, ...
5
votes
2answers
76 views

sql server backups: should i set them to run at the same time?

i have several databases that need to be backed up should i set the backup times the same? is there a good/bad way to do this? i am concerned that since they are going to be backing up at the same ...
5
votes
2answers
689 views

Undo Database Restore in SQL Server 2008

I accidentally restored a SQL Server 2008 database with a wrong backup. Is there any way to undo this and restore to previous version? -Vivek
5
votes
2answers
147 views

Impact of keeping 100+ Linked Server Objects open in MS SQL Server

I manage a large scale cloud based product that uses SQL Server as the database engine. The model is designed such that each customer using the product has its own instance of MS SQL Server. I'm ...
5
votes
2answers
3k views

Running SQL Server Express on Amazon EC2 Windows instance

I created a Windows Server 2008 Amazon EC2 instance with IIS and SQL Server Express pre-installed (using this AMI http://aws.amazon.com/amis/Microsoft-Windows/4801904273096347). After logging in I ...
5
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". ...
5
votes
3answers
4k views

Recommended service account setup for MS SQL Server 2005/2008

We have a number of MS SQL servers in our environment running either SQL Server 2005 standard/enterprise or SQL server 2008 enterprise. Currently the SQL services are running as local service or ...
5
votes
4answers
219 views

Building a Data Warehouse

I've seen tutorials articles and posts on how to build datawarehouses with star and snowflakes schemas, denormalization of OLTP databases fact and dimension tables and so on. Also seen comments ...
5
votes
3answers
2k views

Allow and restrict remote sql server access

I want to expose my sql server instance via the internet. I've been programming asp.net to sql server for a long time, but for the first time i'm hosting the sql server myself instead of the clients ...
5
votes
7answers
29k 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?
5
votes
3answers
537 views

SQL Server clustering options

Can anyone give an high-level overview of the options available for SQL Server clustering, their pros and cons? Is it better to use Microsoft Clustering services or SQL Server native clustering? Does ...
5
votes
2answers
1k views

How quickly will SQL Server release RAM when the OS signals a low memory condition?

From the SQL Server 2008 R2 Books Online: Server Memory Options When SQL Server is using memory dynamically, it queries the system periodically to determine the amount of free physical ...