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)

0
votes
2answers
124 views

Why isn't sql server using all of the available memory

I Have SQL server 2012 standard 64bit with 64GB RAM and 40 CPU cores. In the server properties, I can see that all the RAM is listed in the memory field on the general tab. Underneath the Memory tab, ...
0
votes
2answers
40 views

Build a IIS and SQL Server replicated cluster [closed]

I have four Microsoft Windows Server 2012 R2 Standard virtual machines on three physical nodes. Two will be dedicated for IIS, and two for SQL Server 2014 Standard. I have to replicate them (IIS1 to ...
0
votes
1answer
165 views

Seperate SQL databases for Web Applications? Or host both web apps on same SQL?

Ok, my Hyper-V Server 2012 looks like this: we currently have 2 VM's in production, one is running SharePoint 2010, and the other is hosting the SQL Server 2008 R2 for SharePoint. We're getting ...
0
votes
2answers
9k views

How to clean up database log file automatically to prevent errors?

I host website and sometimes get an error: The log file for database '%.*ls' is full. and have to contact my hosting provider for cleaning database log file. How I can disable logging or configure ...
2
votes
2answers
2k views

Determine Who Dropped a Database?

I have a SQL Server 2005 database that has been deleted, and I need to discover who deleted it. Is there a way of obtaining this user name?
0
votes
1answer
33 views

interpret unknown piece of powershell related to SQL Server

I am migrating from SQL 2008 on Win2003 to SQL 2014 on Win2012. One of the jobs from the old system has this step: if ('$(ESCAPE_SQUOTE(INST))' -eq 'MSSQLSERVER') {$a = '\DEFAULT'} ELSE {$a = ''}; ...
2
votes
1answer
326 views

Index reorganizing slow after index rebuild

Why does index reorganizing take 3 times longer after I make an index rebuild? I wasn't sure if this happens every time, so I made a test for the last month. I configured SSMS to execute Index ...
0
votes
0answers
34 views

SQL Server service dependency not working

I have an service that tries to connect to a MSSQL DB on startup, but when I start the computer it throws an error becouse it's not able to connect to the DB. This happens becouse the specific DB was ...
0
votes
2answers
3k views

SQL server agent job to execute SSIS package fails, package succeds if run manually

I've got a SSIS package installed on a SQL server (SQL Server 2012). It's fairly simple and just fetches data from a remote data source and adds it into a local table. The remote connection string is ...
1
vote
1answer
122 views

Activity Monitor not showing stored procedures?

This is SQL Server 2008 R2 running in Hyper-V virtual machine with 4 virtual cores. Task Manager is reporting sqlservr.exe to use at least 50% CPU, sometimes 100% for minutes. I/O is very low. The ...
7
votes
7answers
4k views

Is there anyway to determine who dropped a table?

A table in the production database has 'mysteriously' disappeared. Does anybody know of any way to diagnose what the heck happened to it? And who did it? Edit 1: This is an internal app, with weak ...
0
votes
1answer
35 views

Can a database created in MS SQL Server Express be exported to MS SQL standard?

As the title states, can a databse created in MS SQL Server Express be exported to MS SQL standard? For the inent of the question, the version in question is 2008.
26
votes
5answers
3k views

How can I prevent accidentally jacking with a production database?

Just recently, I had a developer accidentally try to restore a database to production, when he should have been restoring to a staging copy. It's easy to do, given that the db names are similar, i.e., ...
0
votes
0answers
67 views

How to execute unicode .sql file on azure sql via sqlcmd?

I have an Azure blog created via "Brandoo WordPress" template (wordpress website and azure sql server). All works fine, but if I populate wordpress tables from .sql file with unicode characters via ...
2
votes
3answers
3k views

Which ports to open for DB Mirroring

We have two physical servers on the different area protected by firewalls. We need to use DB Mirroring for our purpose. So which ports we need to open between two area for using MS SQL 2008 DB ...
2
votes
3answers
7k views

SCCM 2012: SQL Server service running account

When installing System Center Configuration Manager 2012, one of the problems I encountered during the Prerequisite Check was "SQL Server service running account". The detail of the prerequisite check ...
5
votes
4answers
23k 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 ...
2
votes
2answers
1k views

Sql Server Management Studio 2008 has suddenly become unresponsive

I'm getting a very strange error when I try to launch SSMS from my taskbar. It seems to open in normal speed, but responds to any input with just a beep. CPU usage is 0% in Task Manager, and there is ...
4
votes
2answers
1k views

How to create aliases without installing SQL Server 2005 Client Tools

I need to configure SQL Server aliases on a public-facing production server. To do that, I need to install SQL Server Configuration Manager. I was not able to find a standalone installer for that, so ...
0
votes
2answers
51 views

What is optimal sql server cluster storage solution?

I have been assigned a project where sql server is running on a single server with single raid 1 volume. This setup has worked fine until hardware failure resulted in about a day worth of downtime ...
-4
votes
2answers
55 views

websitepanel - Is web site panel support sql server 2014 in its services? [closed]

I have server that website panel installed on it for web hosting, my question is that Is web site panel support sql server 2014 in its services?
0
votes
1answer
103 views

SQL 2008 R2 automated install w/ configuration file - The credentials you provided for the SQL Server Agent service are invalid

I am doing an automated installation of SQL Server 2008 R2. I have a new VMware guest with Windows 2008 R2 and ran the SQL Server 2008 R2 setup to create a configuration file. I am only installing the ...
0
votes
1answer
393 views

Installing SQL Server on a Domain Controller [closed]

I want to install SQL Server on a Domain Controller ( windows server 2003 R2) but i have an error because SQL Server services can not run under a local service account or a network service account.
2
votes
1answer
269 views

Mirrored local accounts to connect to database on different server and domain

My database client and database server are on different machines and are not connected to the same domain (this is not supported with my web host). I'm not keen to send username/password details via a ...
-1
votes
2answers
2k views

SQL Server queries running more than the timeout values set in IIS 7.5 and SQL Server query timeouts

Which time out value does SQL server take into consideration while executing a query or stored procedure? The application timeout is set at 20 minutes. The SQL query/command timeout is set at 10 ...
3
votes
4answers
3k views

can SSIS connect to another sql server?

Can an SSIS package run on one SQL Server instance but process data that is located on another SQL Server instance? I'd like to know this before I attempt to install SSIS and require a possible ...
0
votes
3answers
869 views

SQL Server Migration Assistant for Oracle

I've recently installed SSMA and after connecting to both the Oracle instance (which holds the database to be converted) and the SQL Server I've mapped the necessary schemas from Oracle to MSSQL. The ...
1
vote
2answers
329 views

MySQL Migration Toolkit syntax error when creating Sql Server diagram object

I have another syntax error when migrating a diagram. I'm not certain this diagram is necessary, but it would be nice to have a smooth migration, and this is all that's standing in the way. The error ...
3
votes
1answer
41 views

Architecting for Load Testing

I'm trying to architect a set of web and database servers so that we can load test them. I'm running into some problems given the constraints I have to work with: We can't load test against ...
-1
votes
1answer
53 views

SQL Server Express 2005 cannot accept connection (but ODBC working from external and local server)

I'm having a problem with SQL Server Express 2005 edition; it's unable to be contacted from an application (3rd party monitoring utility software). I have perform the following tests, all of which ...
3
votes
1answer
136 views

Find Full or Differential backup from .bak (with powershell or by any other means)

I'm trying to determine whether an MS SQL backup file (.bak) is Full or Differential. Is there an easy way to do this? A way of doing this in powershell?
0
votes
2answers
816 views

SQL server performance over long distance

Is it reasonable to expect decent performance from a SQL server connected via fiber private WAN - 5000 km's away. The carrier is telling us that this network is the 'best' possible, and will ...
0
votes
1answer
4k views

RESTORE detected an error on page (0:0) in database <database> as read from the backup set

I'm attempting to restore a SQL Server 2012 .BAK file to my local server. I've successfully restored this .BAK file before. However now, when I try, I get the following error: RESTORE detected an ...
1
vote
3answers
70 views

Migrating Mssql databases from different instances to a new server

I have 3 instances of Sql (2008 R2) on 3 different servers. The versions are (10.50.2550.0 SP1 Standard Edition (64-bit), 10.50.2550.0 SP1 Standard Edition (64-bit)). The goal is to migrate all the ...
0
votes
1answer
46 views

How to upgrade a MSSQL Server?

As we were updating a service on an older enviroment, we experienced compartibility issues because the service we were updating is working with MSSQL Server 2008+ only. Now we have the issue that we ...
2
votes
1answer
127 views

Azure IO performance sql server [duplicate]

We are in the process of migrating our on-premises sql server to Azure and I am having trouble with the IO performance. I have created a new D14 instance and attached 16 virtual disks at 100GB in ...
4
votes
4answers
7k views

Optimising MSSQL 2008 server inside VMWare ESXi

I normally run my MSSQL servers on dedicated servers, but we've taken on a client who is running their SQL Server inside a VMWare ESXi 4 host, and quite frankly it's running like crap. We have ...
3
votes
1answer
2k views

Monitoring SQL Server 2008

I understand SQL Server doesn't release the memory unless the OS needs it. Then, monitoring Available Bytes (free memory) is not the best way to monitor the service. What other variables can give me a ...
41
votes
22answers
15k views

PowerShell? Do you use it? Can you show me some cool system administration things I can do with it? [closed]

I keep reading everywhere that PowerShell is the way of the future. When it was first released I did a whole bunch of virtual labs, but since then I still haven't used it in a production environment. ...
5
votes
1answer
1k views

SQL Server 2008 R2 cluster, “available storage” shows “offline”

I've installed a SQL Server 2008 R2 cluster and I found the resource group "available storage" shows "offline" status. What does it mean? It seems I can't take it online. I tried to use the cluster ...
-2
votes
3answers
79 views

SSDs for MS SQL Server 2008: slc or mlc: what is expected life for mlc? [closed]

Until recently, Dell et all would only provide slc drives for servers. It appears the winds have shifted and now the cheaper mlc drives are avail for servers. In a sql environment, will mlc give ...
2
votes
1answer
323 views

IIS 7.5 web application failing with NT Authority\Anonymous Logon

I am finding various google results, but none seem to fix my problem. I am setting up a new WINDOWS 2008 R2 box at work that is to communicate with an existing SQL 2012 box via web tools running in ...
-2
votes
1answer
187 views

SQL server slows down

We have a java application running on Tomcat and we are using SQL 2008 and 2005 as database. Our databases sometimes slows down really significantly and we don't see any blocking, deadlock, etc. I ...
2
votes
1answer
43 views

Will SQL Server Express do in this specific situation

I'm doing research on the best suitable database for an in-house web application for our (non-IT) company. It's a web information system with few database-heavy tasks. Users can add new customer ...
3
votes
5answers
2k views

SQL Server 2008 R2 transactional replication over VPN

I'm having difficulty setting up replication over a VPN. I have a SQL Server 2008 R2, Enterprise Edition database on a Windows 2008 R2 Server. SQL Server is running on a non-standard port. I have ...
2
votes
3answers
7k views

DBCC CheckDB The operating system returned error 21(The device is not ready.)

The operating system returned error 21(The device is not ready.) to SQL Server during a read at offset 0x0000000001c000 in file 'E:\SQL Database\S***d\NewAdvWorks.mdf'. Additional messages in the SQL ...
4
votes
1answer
997 views

netlogon errors

I have two instances of mssql 2005 and am using CA XOSoft replication. The master is a failover cluster and the replica is a standalone server. They are all running Server 2003 sp2 x64. Same patch ...
1
vote
1answer
108 views

SQL Express Reporting Server 2014

I have a problem getting my SQL SSRS service working. Version: SQL Express 2014 When I try to start SQL SSRS in services, the service starts, but looking at the event viewer it fails to connect to ...
0
votes
0answers
29 views

EMC AVAMAR Compatibility with SQL Server 2008 R2 in Active/Passive Clustered Mode

We are currently using EMC AVAMAR as part of our backup policy for backing up all our servers. We also have a SQL Server 2008 R2 active/passive setup. Does anyone know if EMC AVAMAR is compatible in ...
0
votes
1answer
21 views

FIM2010 R2 SP1 service account requirements on database after installation

We're in the process of updating our Forefront Identity Manager to 2010 R2 SP1. The SQL Server instance for the old installation has the FIM service account in the sysadmin role, as is required for ...