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)

1
vote
1answer
334 views

Local network speed appears to be being limited

I have a dedicated server setup that has just started causing us issues. Our immediate problem, is that last week, could log into an admin page of one of our websites just fine, now we can't. It does ...
1
vote
4answers
4k views

Error Connection to SQL Server using [HOSTNAME]\instance or [FQDN]\Instance, [IP]\instance working

This one's kind of weird, at least to me. I've got MSSQL server 2k5 (STD) installed on Server 2k3 R2 SP2 (on account of some legacy software that doesn't yet support x64 or Server 2008), using ...
1
vote
1answer
223 views

Managing mass SQL Server ODBC Changes when migrating to a new SQL Server

How do you manage changing out a SQL Server and updating all the clients that connect to it to point to the new server? If I have SQLSERVER1, then buy new hardware and call the new server SQLSERVER2 ...
1
vote
1answer
379 views

Error connecting to SQL Server 2008 Express over a LAN

We have a VB.NET application which uses SQL Server Express 2008. This application could have any number of users. One user will be the server, so there won't be any problem in connecting ...
1
vote
1answer
121 views

Removed SQLServerAgent account What should I do ?

I have removed by accident SQLServerAgent account and now I cant get access to the database. Connecting from management studio throws me error 26 and system log shows: SQLServerAgent could not be ...
1
vote
2answers
709 views

SQL Server variable size and increase it

It is not clear to me how a varchar(max) is declared or used in an SQL Server e.g. 2005 Is a variable declared as varchar(300000) for example considered as a varchar(max)? E.g. I am seeing in a DB in ...
1
vote
2answers
504 views

High Transaction System Recommendations [closed]

I am a SQL Server database administrator and developer and I also have many years experience as an application developer. I currently have a customer with a very big project who is looking to me for ...
1
vote
2answers
283 views

Problems installing SQL Server 2008 SP2

I installed a 90 day Eval version of SQL Server 2008 SP2 downloaded from Microsoft. I ran ths installation and it all went thru without any errors. Then i opened the Configuration menu to see if the ...
1
vote
4answers
226 views

How to look at what is going on in a pegged SQL Server instance?

I have a SQL Server instance that is pegging out my server. I'd like to look at what jobs are running, but it's so slammed that I can't even log in. Is there some secret way to get in and look at ...
1
vote
1answer
48 views

Migrate from SQLAzure

I was wondering if there were any resources available that provide information on Migrating a Database and its schema / data out of SQL Azure and back to a nice cozy sql server Thanks
1
vote
3answers
952 views

Sql Server management studio 2005 cant connect to localhost using windows authentication

I am trying to localhost using windows authentication with SQL Server management studio and I am getting a message that "Login failed for user..." (Error 18456). I made sure that all the services are ...
1
vote
3answers
199 views

basics of SQL Server 2008 backups

We don't have a DBA and I have to do backups. We have only one database that is 3gb (the others are less than 100mb). The 3gb database is write-heavy, and has very important data. I set up daily ...
1
vote
2answers
1k views

How to achieve the following RTO & RPO with logshipping only using SQL Server?

Trying to come up with viable backup restore & logshipping solution for achieving the following: 15 minutes Recovery Point Objective (no more than 15 minutes data loss at any time) 5 minutes ...
1
vote
2answers
3k views

How to allow TCP connection over the network to SQL Server 2008 Express?

I've installed SQL Server 2008 Express. I connected to it and created a Database with Microsoft SQL Management Studio. But I cannot connect (with same url, username and password) to the DB from my ...
1
vote
2answers
3k views

High Sqlservr.exe Memory Usage

I have a problem with sqlservr.exe (version 2008). It use a more memory. I checked on windows taskbar manager, sqlservr.exe usage ( Mem usage - 8GB Ram). I dont know how can I fix it.Got the following ...
1
vote
1answer
580 views

SQL Server 2008 Install fails error reading etwcls.mof

I receive the following error when trying to install Sql Server 2008 Standard on a Windows Server 2008 box. Error reading from file ...
1
vote
3answers
74 views

Transform data to a new structure

I've got an Access database from one of our clients and want to import this data into a new MSSQL Server 2008 database structure I designed. It's similar to the Access Database (including all the ...
1
vote
2answers
1k views

Viewing SQL's cache RAM usage?

I hope this has a really simple solution, but I have a feeling it won't. I've not been able to find any information on this anywhere else, which isn't a good start! Basically we're running SQL Server ...
1
vote
2answers
149 views

Performance issues concurrently running MySQL and MS SQL Sever

We're considering installing MySQL on the same database server that has been running MS SQL Server. From my research there are no technical issues running both concurrently, but I am worried that the ...
1
vote
2answers
4k views

Is there a way to change the serial number in SQL server without reinstalling it?

I have a SQL Server Standard installed on a server and used my MSDN subscription to download the installation media and install it while in development and test phase. I would like to know how should ...
1
vote
1answer
327 views

How to export a MySQL DB to MSSQL Database?

The ultimate goal in this task to to take a complete database in MySQL and export it to MSSQL. I was hoping to be able to do this with mysqldump. Thanks.
1
vote
6answers
3k views

SQL 2005 Database Not Accessible

I've moved a database from sql 2000 to a new 2005 server. Everything was fine until I logged into Sql Server Management studio with one particular user. It looks like i logged in successfully but when ...
1
vote
3answers
3k views

Restore SQL Server 2005 backup db on SQL Server 2000

I created a backup of a database on SQL Server 2005 and I wanted to restore the backup file on a SQL Server 2000. However, I am getting this error The media family on device [path] is incorrectly ...
0
votes
1answer
165 views

RAID 10 Cluster Size for SQL Dynamics AX Database

Many article read and many websites visited yet still no closer to a firm or concrete answer. We have created all our Arrays for our SQL 2012 installation with the appropriate LUN's and understand ...
0
votes
1answer
466 views

Sharing LINUX NFS Folder on Windows Server

I have some CSV files on Linux. I would like to load them into my SQL Server with a stored procedure. I'm looking for a way to share the files via NFS with my Windows Server. I was wondering if ...
0
votes
4answers
955 views

Two MS SQL Instances, one database file

Is it possible to have one database file attached to two different instances of SQL? Consider that the MDF is located on a NAS and I want a primary and secondary instance of MS SQL on two different ...
0
votes
1answer
4k views

SSIS DSN Not Showing as ODBC Data Source

I have been following the directions here: http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/05ccd778-b78c-4a83-a10a-c4ae412cc6e4 And ran into a problem where my System DSN ...
0
votes
3answers
3k views

SQL Server Setup failure

i uninstall sql server 2008 r2 and then install it but now i receive an error: TITLE: SQL Server Setup failure. SQL Server Setup has encountered the following error: MsiGetProductInfo failed to ...
0
votes
1answer
2k views

Best practice for transfering MSSQL Databases and all accounts to new server?

One of our customers has installed a new SQL server and needs to take down the old SQL box. Both servers are running Microsoft SQL Server 2008. The applications all access the current SQL server via ...
0
votes
3answers
1k views

Why cannot connect to SQL Server by the full server name with instance name?

For some reasons, I cannot connect to my SQL Server with full name + instance name (e.g. server_name\MSSQLSERVER) by SMSS. However, I can connect by simply using just server_name or localhost. When I ...
0
votes
2answers
163 views

The Transactional Log is Full

I am getting below error. The transaction log for database 'CRM_QA_V6' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases likely ...
0
votes
1answer
212 views

A utility to backup single tables on MSSQL?

Are there any Windows utilities that allow you back up single MSSQL tables? Having a lot or trouble finding any. I hear sqlbackupandftp is good, but as far as I can see, it doesn't back up single ...
0
votes
1answer
5k views

SQL Maintenance Cleanup Task 'Success' But not deleting files

I have a maintenance plan setup for a databases on a server. As part of the backup is a Maintenance Cleanup Task. SQL Version 2008 The task that 'succeeds' is setup as: Delete backup files Correct ...
0
votes
3answers
2k views

Failover clustering: tempdb on SAN?

We are considering clustering our SQL Server 2008 EE instances. The storage is on SAN. Can we put tempdb data/log files on SAN? What are the pros and cons on this solution? For optimal performance, ...
0
votes
2answers
90 views

SQL server connecting issue

We recently installed SQL server 2000 Std. edition on my new windows server 2003 R2 server which is the additional domain in our existing windows 2003 server domain. Now i am unable to connect this ...
0
votes
2answers
205 views

Replication keeps popping up on SharePoint databases

My typical discovery scenario: We receive an alert that the transaction log is growing quickly. We are in Simple Recovery so I go to check it out. Log is already sized to 100GB and is at 80% ...
0
votes
3answers
406 views

SQL Database is in Suspected Mode

I found that database is in Suspected Mode ...... How Can I Recover it from this Mode.
0
votes
1answer
217 views

Can't access SQL Server 2008 with anything but 'Windows NT Integrated Security'

In Management Studio, if I go 'Security' --> 'Logins' --> 'New Login' --> something simple like username='test' and password='test', I am still unable to use this login - why? Is there something ...
0
votes
1answer
386 views

what is the difference between SQL and ANSI SQL?

what is the difference between SQL and ANSI SQL?
0
votes
1answer
870 views

long access times and errors in iis application

I am having an issue with an IIS application (details of environment at the end of the message). The web site works great most of the time and I cannot reproduce any error in our test system. On the ...
0
votes
1answer
414 views

How can be cout \Process(sqlservr)\% Processor Time over 300 %

The counter, Process(sqlservr)\% Processor Time, is hovering around 361% on one of my database servers. This counter reflects the percent of total time SQL Server spent running on CPU (user mode + ...
0
votes
2answers
1k views

Remote MS SQL 2008 connections

Hello i am having problems setting my MS SQL server up so i can connect to it remotely. I have enabled remote access in the SQL Server itself, and enabled TCP connections in the config manager. And i ...
0
votes
2answers
566 views

Tools to manage sql 2008 database mirroring?

We are going to be moving about 20 databases that live on a single instance of sql 2000 to a sql 2008 r2 environment with database mirroring. What I'm looking for is a tool or scripts that will help ...
0
votes
3answers
4k views

MS SQL Server Firewall Ports

I've recently found myself in the position of quickly deploying a production app on SQL Server 2008 (EXPRESS), and I've been having some issues with configuring firewall rules between our web server ...
0
votes
1answer
2k views

Can I setup a link SQL server connection between servers on different networks?

We have a production SQL server hosted offsite at a hosting company, and we have a staging environment within our own network. We want to be able to setup a SQL job that copies content from a table ...
0
votes
8answers
7k views

SQL Server slowly hogging RAM, where do i start to optimise? [duplicate]

Possible Duplicate: SQL Server memory constantly going up, from 1GB RAM used to 7GB in a week. Hi There, We have a fairly new 2008 server with 4gb ram and SQL Server 2008. We're currently ...
0
votes
1answer
1k views

Installing both SQL 2000 and SQL 2008 on the same machine

Is it possible to install BOTH 2000 and 2008 on the same machine (and have them as different instances) Ideally, I want the 2008 to be default instance, with 2000 named "legacy" or something... We ...
0
votes
2answers
478 views

Running ASP.NET Website and Exchange Server on same machine?

At the moment I only have one machine available to me that is already hosting Exchange Server 2003 on it. I am going to be developing an ASP.NET website (possibly using MVC framework) which is going ...
0
votes
1answer
264 views

Monitor network drops between Windows Server 2003 servers

This is probably a ridiculously simple question, but here goes... I'm troubleshooting an issue where an application (SQL Server Analysis Services) becomes unavailable for anywhere from 30 to 60 ...
0
votes
2answers
159 views

Sql 2000 and AWE

I have a weird problem. I enabled AWE on a Sql 2000 sitting on a Windows 2003 server. The server has 20 gigs of memory but when i enable AWE sql process is showing as having only 128 MB. From perfmon ...