Questions tagged [sql-server]

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.

The tag is for general questions related to Microsoft SQL Server and its various technologies. SQL Server is a very broad topic, much of which is perfectly suited for serverfault. SQL Server programming questions involving code, however, will be generally be better suited for stackoverflow.

If you have a SQL Server question, ask yourself the following questions to determine the best site:

  • Is the goal of my question to solve a SQL Server system administration (DBA) function? If not, then it's a good bet you should head on over to stackoverflow https://stackoverflow.com/ or superuser https://superuser.com/

  • Who would use the code that my question relates to the most, a developer or a DBA? If a developer, stackoverflow is your place. If a DBA, ask away here.

For information on how to handle installation errors related to the system language versus the installation media language, see SQL Server setup media does not support the language.

4775 questions
2
votes
3 answers

SQLServer Maintenance Plan Backups Failing to backup to Samba Share

I have a SQL backup plan that writes the backups to a SAMBA network share. I have a T-SQL net use (with persistent:yes) script that is the first part of the maintenance plan to access the share. This worked for a while but now it is failing now on…
Kyle Brandt
  • 83,619
  • 74
  • 305
  • 448
2
votes
3 answers

SQL Server Transaction logs full, how to empty and delete them

My transaction log file is full, i have 5 log files , 2 in D: drive & 3 in E: drive. all the log file is full, each log file is 10GB in size. I need to delete all 5 transaction log file and need to have one fresh truncation log file i have tried…
Dhiva
2
votes
3 answers

SQL Server 2005 backups for previous 5 days on disk?

My goal is simple. I want to have SQL Server keep a nightly backup of a DB for a rolling 5 days. So each night at some time I want a new DB backup made and one deleted such that I have a rolling 5 days on disk. I am trying to get a maintenance plan…
kacalapy
  • 147
  • 7
2
votes
3 answers

Create Secure External Connection To Sql Server

I run a little 1&1 web server with quite a few sites all powered by SQL Express Db's and have never allowed connections to SQL Express from an external resource (Anything not on the server), as I am paranoid of the databases getting hacked if I…
2
votes
6 answers

How best to script selected tables and data on SQL Server 2008?

The SQL Server Management Studio has the ability generate scripts. The problem is that it breaks on identity columns. I can't find a link to this bug at the moment but Microsoft basically declared it as a "feature". This is particularly important…
cletus
  • 9,999
  • 9
  • 37
  • 40
2
votes
1 answer

How to create a shared lock blocking an intent exclusive lock

As I understand it, a SELECT statement will place a shared lock on the rows that it will return. While that SELECT is running, if an UPDATE statement comes along and needs to grab an intent exclusive lock then that UPDATE statement will need to wait…
2
votes
1 answer

Boost SQL Server priority: should it be used?

I'm trying to optimize my SQL Server 2008 instances on Windows cluster (on Windows Server 2008). I'm having several SQL Server instances on two cluster nodes. I was thinking that should I enable the "priority boost option" on every instance? What…
user55656
2
votes
1 answer

Does the full backup truncate transaction log?

Does the transaction log get truncated when I take a full backup using command BACKUP DATABASE AdventureWorks TO Adventurewks GO Or do I have to take a log backup separately? BACKUP LOG AdventureWorks TO Adventurewks; GO Or is the log…
2
votes
1 answer

Tools for planning a SQL Database size requirement

I'm about ready to start setting up a SQL data warehouse for some SQL Server Analysis Services. The data that I am going to slice and dice lives in an off site database that I don't control, so my idea is to set up regular jobs that go out and pick…
2
votes
3 answers

What would be better solution a single database or multiple databases, one for each customer

I building a software that is going to have a lot of users (hopefully) I will have users that dont have much records or exceed normal data and I would also have the big users which will have millions of data rows in many tables. What would it be…
user55561
2
votes
2 answers

Easiest Way to Convert a SQL Server 2008 Database Down to SQL Server 2005?

I have a SQL Server 2008 database that I need to bring into my environment, but my production servers are all running SQL Server 2005. Upgrading the environment is not an option, at least not in the near term. I do, however, have non-production SQL…
Michael Gorsuch
  • 2,378
  • 1
  • 21
  • 24
2
votes
1 answer

Free software to synchronize two sql server databases

I am looking for a free software that can: Compare two MS Sql Server databases (Both schema & data) Also provide a method to synchronize the databases. Thanks. UPDATE: I am not looking for any mirroring solution etc. Not a server solution. Just a…
Gautam Jain
  • 119
  • 6
2
votes
2 answers

Can I use domain controller as one of my nodes in my cluster environment?

I want do some SQL Server failover cluster experiment on Windows 2008 R2 in VM. Now I created a domain controller(as DNS server too) DC. Also I created a server server1 and added into the domain. Can I just use DC and server1 to make the cluster? Or…
Yousui
  • 245
  • 3
  • 4
  • 9
2
votes
2 answers

SQL 2005 RESTORE DATABASE on a linked server

I'm trying to copy a database from one server to another by backup and restore. I've created steps in an agent job to backup the database to file and to xcopy the file over to the other server. I'm trying to do the restore now, and it's not working.…
Richard Gadsden
  • 3,686
  • 4
  • 29
  • 58
2
votes
1 answer

bcp import file how to ignore duplicates?

I want to import a csv file into a sql server 2008 R2 database table using bcp using a command like this: bcp Database..TableName in TableName.csv -n -T -E -S localhost My problem: the table contains one row which is also in the csv file (default…
Sam
  • 909
  • 5
  • 15
  • 28