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)

1
vote
1answer
159 views

Can I set MSSQL permissions for individual users with a group login?

I have a lot of SQL 2005 servers with a lot of databases and a lot of Windows users that need access to all the servers but only a few databases, and that last part changes regularly. Managing these ...
1
vote
1answer
892 views

Restore SQL 2008 database fails with error on page xxx:xxx

This is the situation: Got a full backup (.bak file) of a SQL 2008 database, with partitions. The .bak file is 100gb. I need to restore this database on a different server, to a new database. ...
1
vote
1answer
109 views

Remote restore of DB in MSSQL 2008

I have a remote MSSQL server meant to centralize SQL for development projects. I hand out DB's and access to developers as they need it. I do not want to give them access to filesystem in any way ...
1
vote
1answer
317 views

NHibernate won't connect to SQL Server

I have 3 SQL Server instances running on our server (dont ask why)! 2xSQL Server 2008 Workgroup (Default and MSSQLServer2) 1xSQL Server Express 2008 R2 (sqlexpress) Now I have a Windows Service/App ...
1
vote
1answer
541 views

Help with repairing Dynamics CRM 2011 Server

As stated above, I had a bit of an issue with my CRM 2011 server last week. I run a small computer repair company and use it to manage my clients. I was running the server in a VirtualBox VM and the ...
1
vote
1answer
396 views

SQL 2005 Cluster - How to move MSDTC

We currently have a 2 node (Win2003) SQL 2005 Cluster running 2 instances. We need to move all drives to a new SAN but are pondering over how to move the DTC that is currently 'logging' te Quorum ...
1
vote
1answer
49 views

Troubleshoot DBMail in SQL Server 2005

On a SQL Server 2005 machine, I have DBMail setup and correctly configured. I am able to use "Notify Operator" and EXEC msdb.dbo.sp_send_dbmail to queue emails. But the problem is the queued mails ...
1
vote
1answer
268 views

MSSQL2008-R2 Scheduled Job Infinite Loop

I have two very similar jobs on a SQL2008r2 instance. Each one selects data from one of two structurally identical tables and exports it to one of two SQLAzure databases with the same schema every ...
1
vote
1answer
181 views

SQL 2008 R2 3rd Party Peer-to-Peer Replication, Global Site Distribution

We are looking at hosting 3 globally distributed SQL Server installations at different data centers. The intent is that Site A will serve web traffic and data for a specific region, same with Site B ...
1
vote
1answer
33 views

Adding Logical Drive in SQL Server 2000 Clustered Environment

I have a Sql Server 2000 Clustered (Active/Passive)Production box, My network guy is adding a new Logical Drive to the box. Also he is going to Add logical drive to cluster admin My Question is He is ...
1
vote
1answer
2k views

sqlcmd won't execute - Claims Native Client not installed properly

I'm trying to use sqlcmd to execute some SQL scripts. Using a test command with a simple query like: sqlcmd -S HOSTNAME -d MYDATABASE -Q 'SELECT Names FROM Customers' sqlcmd does not appear to ...
1
vote
1answer
557 views

SQL Server - VMWare Install - Transactional Replication causing 100% CPU

I am having severe trouble with a SQL Server - in particular, with transactional replication. We used to have a Windows 2003 physical machine, with SQL 2000. We call this “WebDB” The server was ...
1
vote
1answer
1k views

SQL Full-Text indexing not populating

We installed a clustered SQL 2005 installation on windows 2008 and reattached our san drives from another machine and restored to do a migration to new hardware. There have been a few minor issues, ...
1
vote
1answer
111 views

Best solution for a mailing list based on a custom SQL Server database AND sync to Outlook?

This is really a two-part question but I'm writing them in the same question because there might be solutions that could handle both. A customer has a custom LOB database based on MS SQL Server with ...
1
vote
1answer
301 views

SQL server 2000, replication over WAN

I seem to have big difficulties setting up the first replication ever between two SQL2000 instances. They both run in seperate WAN's (IP with port assigned for SQL-remote) but I have been able to ...
1
vote
1answer
52 views

Failover Config for SQL Server 2005 Professional on Win2k3 64x Standard (2 machines available)

I have MS SQL Server 2005 Standard on Win2k3 64x Standard (on 2 separate machines) How to setup fail over cluster on this solution? I don't have neither SQL or Win Enterprise and it's too expensive ...
1
vote
1answer
211 views

SQL SERVER 2008 R2 INSTANCESHAREWOWDIR Issue

I am trying to install SQL SERVER R2 Express Advanced Services on my VServer (Windows 2008 SP2 64bit). The server has also a sql server 2005 express instance for plesk... I am running in the strange ...
1
vote
1answer
63 views

SQL Database and ArcSDE Database

Is it possible to have sql database and ArcSDE database running on the same server - virtual machine? What are the benefits? What are the negatives?
1
vote
1answer
127 views

Best database structure for an Admin Portal to a web service

I am primarily a web developer, not a DB admin, so hence this question! We have a webservice that we have created which has a Database on our SQL 2008 server. We are currently creating a web portal ...
1
vote
1answer
777 views

SQL Server: “This filegroup cannot be used as a backup destination” error when attempting restore

When running a command like the following: "RESTORE FILELISTONLY FROM DISK='\\\\server\\folder\\DummyDB.bak'" I'm getting this error: Backup destination "\\server" supports a FILESTREAM filegroup. ...
1
vote
1answer
504 views

No PerfMon data through WMI

I'm trying to get \DBServer\SQLServer:Buffer Manager\Page life expectancy data through WMI. When I do this through perfmon, I get actual data. However when I try and pull this from either of these ...
1
vote
1answer
152 views

backup of TFS with DPM 2007 - different backup times

I have DPM set up to back up my TFS server every 30 minutes, the reason being it's a way better interface than the quirky SQL backup interface. I also do a full backup nightly using an SQL ...
1
vote
1answer
268 views

Download databasename.bak file

I have downloaded databasename.bak file from my hosting company, when i tried to restore that DB file in SQL server 2008 it is keep on giving me following error. The media family on device ...
1
vote
1answer
518 views

Don't see job schedule added by sp_add_jobschedule in SQL Mgmt UI

I'm running a script like below on a SQL Server box and, even though it finishes correctly, then when, on SQL Mgmt UI, I right click on that job's properties, go to Schedules, I cannot see the ...
1
vote
1answer
104 views

MS SQL server 2005 replication

I have a problem with replication between 3 servers. I made something like this: server A replicate (transactional replication) to server B (to 'mydb' database), then server B replicate 'mydb' (using ...
1
vote
1answer
90 views

Database BackUp Procedures and Responsibilities(SQL Server)

Any detailed document available on Database BackUp Procedures and Responsibilities(SQL Server)?
1
vote
1answer
456 views

Delay index build until SQL Server table load is complete with SSIS

I have a large table that I am updating. Is it possible to disable index updates on the destination table until the load is complete? It seems like a waste for it to be constantly updating the index ...
1
vote
1answer
383 views

linked-server sql - access

I have a SQL server 2000 and an Access database mdb connected by Linked server on the other hand I have a program in c # that updates data in a SQL table (Users) based data base access. When running ...
0
votes
1answer
40 views

SQL Server Multiple Instances but showing the same databases

I am running SQL Server 2008 R2 Standard Edition and need to have multiple instances which I have installed. However, when I restore a database onto one instance, it is showing up on the other ...
0
votes
1answer
80 views

Exporting a Subset of Data in Microsoft SQL Server to Script

We are running a Microsoft 2012 SQL Server and are looking at a way to dump a subset of data (based on queries) to .sql scripts we could then run on another server to pull that data back in. We have ...
0
votes
1answer
58 views

Easy way to alias the default SQL Server instance to a named instance?

I have SQL Server Express installed on my machine as the default instance. "server=.;database=...." I'm now working with a new client where their config files are all checked into the repository. They ...
0
votes
1answer
445 views

Active Directory SQL Server Random Handshake Timeouts

We've installed active directory on a new server and joined our database server and web servers to this new domain. However, randomly, we'll get the following error. What would be the cause of the ...
0
votes
1answer
107 views

Sql Server Transaction Log Backup Fails

I have a Sql Server 2008 Standard version. Mirroring is set up on the server in full safety mode. Its been working fine till today. The transaction log back-up fails every-time with an error "Error: ...
0
votes
1answer
650 views

sqlcmd is not recognised as an internal or external command, operable program or batch file SQL2014

I have written an installer that is supposed to install SQL Server Express 2014, create an instance, and then use sqlcmd to connect to the instance and build the database from a schema. It works by, ...
0
votes
1answer
100 views

Sql Server 2012 Disk I/O Too high

I am running SQL Server 2012 on windows azure VM Windows server 2012. This is a live Database, about 250GB, with high usage. I applied some best practice articles for the temp-db long ago, and also ...
0
votes
1answer
288 views

MSSQL 2014 and Dynamics CRM 2013 SP1 (springwave)

Microsoft says MSSQL 2014 is not supported with MS Dynamics CRM 2013 (SP1 springwave '14). Is this because there are known problems with that configuration? Or does it just mean that Microsoft did ...
0
votes
1answer
65 views

What happens when Core Cluster Group is failed over to another node? Will it take the whole cluster down? Single point of failure?

http://bit.ly/1lKJFIa "Cluster group" fail-over will cause cluster go offline. Really? Single point of failure? Am I missing something? What happens when Core Cluster resources (Cluster Group) are ...
0
votes
1answer
87 views

Connect to Windows Server 2012 Essentials without creating new user login for Windows

Is it possible to connect to a Windows Server 2012 Essentials without having to create a new user login for Windows? I want to just take someones Windows 8 machine and connect it to the server to ...
0
votes
1answer
68 views

Rebuilding MS Agent Jobs from MSDB table

This morning our DB server died. They restored backups to another server but these didn't include the many MS Agent jobs. Anyway I have managed to get a backup of the old MSDB table where all the ...
0
votes
1answer
74 views

How to locate the cause of a excessive memory in ms sql

We are experiencing memory issues with MS Sql 2008 R2. There appears to be a memory leak that is consistently increasing in memory usage until it gets to about 1.5 gb and then stops. We have used ...
0
votes
1answer
51 views

Perfmon % Processor Time unbalanced

I am somewhat of an accidental DBA, and I'm troubleshooting a SQL Server box where performance has been notoriously poor (as reported by the customer). I was not involved in the initial planning of ...
0
votes
1answer
248 views

Installing SQL remotely using Invoke-Command

i'm trying to install SQL Server 2012 on Win 2012 r2 server remotely via Powershell using Invoke-Command, but it fails with this error "Validation for setting 'SQLSVCACCOUNT' failed. Error message: ...
0
votes
1answer
175 views

Can Ping but Cannot Telnet directly to SQL Server 2012 Cluster Nodes

We have a monitoring tool (Solarwinds Orion) that needs to connect to a 2-node failover SQL Server Cluster. For reasons outside of our control -- we cannot monitor the CLUSTER IP directly at this ...
0
votes
1answer
29 views

Hide a SQL server table partition

Is it possible on SQL Server Enterprise to hide a specific table partition from users including admins? encrypting the data is not an option for us.
0
votes
1answer
78 views

SQL Reporting service unable to start after restoring on new hardware

I have a SQL server that the hardware is failing. As a solution we restored the image of the server on a multicore (more less new) server. The problem is that SQL 2000 cannot be started if number of ...
0
votes
1answer
108 views

Scheduled copy of production database into test database

My question is similar to this one. I've Two different severs (both SQL Server 2014 Std Edition). Production and Test. I want my test server to connect every night to the production server and ...
0
votes
1answer
33 views

SQL Server 2014 Data Collection and Exception

I am trying to create a data collection in SQL Server 2014 but when I try to run one against the disk summary it throws the following error: Exception has been thrown by the target of an invocation ...
0
votes
1answer
301 views

SQL Server Timeout issues at random times causing performance degradation

I am having random timeout during a brief period of time on certain days. My CPU, Memory looks fine. So I ran Performance Monitor during these spikes and found my average disk sec/read was 5.8 ...
0
votes
1answer
647 views

Unable to run query in SQL Management Studio because of JIT debugging error

Recently I have built a Windows server 2008 and installed SQL Server 2008 and Dynamics CRM 2011 on it. Everything is working fine but when I open the SQL Server management Studio and try to open a new ...
0
votes
1answer
518 views

Uninstall Older Sql Server After Upgrade

Is it ok to uninstall older versions of SQL Server after an upgrade? I have 2008/2008 R2 installed, but using 2014 since it was just upgraded.