SQL Server 2008 is Microsoft's version of SQL Server following SQL Server 2005. A list of the new features can be found here
1
vote
1answer
31 views
Windows Server 2008 Memory Usage with SQL Server 2008?
I have the following kit:
windows server 2008r2
Microsoft SQL Server 2008r2
Dual Quad Core Xeons
52GB Ram
The Ram usage on the server is currently at 98% which is fine, SQL server is happily ...
1
vote
2answers
19 views
Improve automatic failover scenarios in SQL Server 2008
We have SQL Server 2008 set up in with a principal, mirror and monitor server, the mirror is synchronized and set to automatic failover. We recently saw a situation where we ran out of space on the ...
1
vote
2answers
36 views
Transaction log backups
I'm studying for the 70-432 (SQL Server 2008) exam, and I'm a bit confused about how the transaction log works.
From what I understand, (correct me if I'm wrong...) the log is actively stored in ...
0
votes
1answer
37 views
Data transfer between servers extremely slow
I have an application running on a Live environment with a Web Server which is running Windows Server 2008 R2 with a QuadCore Xeon processor with 8GB of ram and a Database Server with the same ...
1
vote
2answers
67 views
Ridiculously slow queries on Microsoft SQL Server 2008 R2
I'm getting really slow queries in MS SQL Server 2008 R2 on my dev machine. This problem has been plaguing me for about a month. Other developers don't have the same problem, but we all run the same ...
-1
votes
1answer
26 views
How much ASP.NET and SQL Server will cost me more?
I want to develop a web application using ASP.NET and SQL Server. However, my friend told me that using MySQL will cost me far less. I just want to know how much SQL Server cost me more than MySQL? Is ...
0
votes
2answers
42 views
Maintaining SQL Log Files
I get an email today stating that we have a log file that's grown to 278GB, and asking if anyone is maintaining it. I already know the answer to that is no because we don't have a dba (other than ...
-2
votes
0answers
29 views
What are some cloud hosting solutions that give me VPS flexibility? [closed]
I've currently got a VPS solution that I'm paying about $60/month for that gives the flexibility of installing my own Windows services, has SQL Server 2008R2 and allows me to host apps. I also have ...
0
votes
1answer
21 views
SQL Server NIC Power Saving
We have a server running Windows Server 2008 which is dedicated to hosting a SQL Server 2008 Database.
Whilst auditing the server OS we have noticed that the NIC Power saving feature is enabled. ...
1
vote
2answers
42 views
I want to connect to SQL Server Express remotely through windows firewall
I have a VPS windows 2008 with SQL Server Express installed on it. I want to access the SQL Server Express database from my PC. I can access it when I disable windows firewall, otherwise I cannot.
...
2
votes
1answer
49 views
Being Flooded with Security Event ID 4793 - Windows 2008 R2
I have a SQL server that is a domain member running Windows 2008 R2. It is a cluster node in a failover cluster. The security event log is getting flooded with these:
Log Name: Security
...
0
votes
1answer
20 views
Adding SQL Server 2008 R2 (sqlexpress) datasource in CF Administrator
I am using coldfusion 9 and SQL Server 2008 R2. It is set up as sqlexpress When I try to add a data source (sql) I get this error:
Connection verification failed for data source: test_cursor
...
0
votes
1answer
20 views
Updating my UAT database to recent copy of live (MS SQL Server)
I have one sql server instance with two databases :
myDB_LIVE
myDB_TEST
both point to separate mdf and ldf files and are backed up each night. I want to take a copy of LIVE and put it in TEST. I ...
2
votes
1answer
36 views
Failed Account Logon Events
We have a server running SQL 2008 R1. We have a web server in the DMZ that connects through the firewall to the SQL server and executes SQL Reporting Services reports using a domain user account.
On ...
0
votes
0answers
24 views
Update SQL server express to R2, 10.00.5500 > 10.50.1600
Is their any easy way, or do I have to just install a new instance, if I put sql server express 2012 is that compatible wih 10.50.1600.
0
votes
0answers
45 views
SQL Server Management Studio 2008 won't open
I'm trying to open SQL Management Studio 2008 to attempt to work with a server I have just set up, and to import an .sql file, but for some reason when I attempt to install and run the software it ...
3
votes
2answers
69 views
How to change max server memory in SQL Server
I was trying to change the max server memory for my database server, and I accidentally saved it as "4" instead of the number I wanted to enter.
Now I can't even connect to the server.
Is there a ...
0
votes
5answers
53 views
How much memory should I put in our SQL server 2008 server?
Currently our SQL server 2008 machine has 24 gb of memory.
After analyzing some reports (PAL) and performance counters, I came to the conclusion that the server could use some more memory.
What is a ...
1
vote
1answer
29 views
SQL 2008 Find out what licensing it is using.
How can I tell the licensing that is setup on a production SQL server?
0
votes
0answers
21 views
Can't redeploy application in Glassfish - XAResource.start
I'm experiencing an strange problem that is slowing the development of my application. Every time I try redeploy the web application on glassfish 3.1.1 I receive these exceptions:
...
0
votes
1answer
68 views
Can I downgrade SQL Server 2008 R2 Standard To Web Edition?
We are running a SQL Server 2008 R2 Standard Evaluation version. The client has decided they don't want to pay for full SQL Server standard and feel the Web edition is suitable. Can I downgrade SQL ...
0
votes
1answer
27 views
SQL Server filestream access from another computer using system account
I have a SQL Server 2008 set up to use filestream. SQL Server runs under a domain account with SPN set and delegation enabled.
Accessing filestream from another computer using a domain account works.
...
1
vote
2answers
39 views
Migrating to a new SQL Server machine: should master database be restored?
I'm currently working on a migration plan to migrate our SQL Server to some new hardware.
The current installation is SQL Server 2005 standard: it used to be clustered but the node got removed at ...
0
votes
0answers
20 views
how can connect from client to sql server 2008 via proxy
I have SQL Server 2008 in dedicated server and all port of SQL Server is blocked with firewall.
I have VPS with CCProxy on it.
I opened all ports in dedicated server for my VPS server IP.
I set proxy ...
1
vote
0answers
59 views
SQL Server 2008 is suddenly slow as a sloth
We run an SQL Server 2008 R2 Standard install on a 4core xeon with 8gb ram (of which sqlserver is allowed to use 6gb). I have a VB6-app that runs queries on the data in this database to generate ...
1
vote
2answers
41 views
SQL Server 2008 - Service account for backups
I am setting up a backup software to backup all the databases on my MS SQL Server 2008.
I want to configure a service account with administrator rights on the database. The service account have ...
0
votes
0answers
45 views
Can't install SQL Profiler, it's greyed out in the feature selection list
I got a problem when trying to install Management Tools - Complete on my MSSQL 2008 R2. At the Feature selection screen the Management Tools - Complete is greyed out and can't be interacted with. In ...
0
votes
2answers
26 views
what is a good frequency for setting up snapshot replication in sql server 2008
My requirements:
I have a publisher database from which I intend to replicate to a subscriber.
Not all tables need to be replicated.
Amount of data could be ~20-30GB.
Given the above:
is ...
0
votes
0answers
34 views
MS SQL 2008 - Restoring a Differential backup [closed]
I do backups of every single database on an MS SQL server 2008.
A full once every 2 weeks, and between fulls, I do a differential every day.
For the backups, everything is fine. But I would like to ...
0
votes
2answers
47 views
SQL Server 2008 - Backup Databases with more than 50 characters
I am using T-SQL to backup my MS SQL 2008 databases:
BACKUP DATABASE @name TO DISK = @fileName
The problem occurs when it comes to the databases with their name length greater than 50 characters ...
1
vote
2answers
36 views
Which Service Account should I use in SSRS?
I'm a newbie in SSRS, so my experiences are limited in this topic. In the SQL Server Configuration Manager, there are several options to set the Service Account. I have the option to either use a ...
0
votes
1answer
33 views
Execute Stored proc for 10000 times [closed]
I want to call a stored procedure for 10000 times and I want to pass different values for the parameter everytime.
Can some one help me to do that
For example
I want to call/execute " EXEC ...
0
votes
0answers
13 views
Column level Data in sqlserver 2008
My company uses laptop to Enroll customers in the remote villages.
At the end of each business day the records are sync to the Central Database(SQLSERVER 2008).
I want to Encrypt all the column in my ...
2
votes
1answer
23 views
How Do I Use the “Backup Database” Statement to Overwrite an Existing Database Backup?
I'm trying to write a database backup statement that will overwrite the existing backup but I'm not having any luck. I've tried various combinations of the INIT, FORMAT, and RETAINDAYS =x clauses but ...
0
votes
1answer
25 views
sql server 2008 r2 can connect with connection manager but noway else
I have installed (3 times on 3 machines) sql server 2008 r2 can connect with connection manager but other program cannot connect.
I can connect to remote sql servers with heidisql or with my ...
0
votes
1answer
68 views
SBS2003 -> 2011 Migration - Some Sharepoint Calendar Items not Showing in Calendar View but Show in All/Current Events
Bascially I've followed the Microsoft guide on SBS 2003 -> 2011 Migration. Performed it over the weekend to try and give zero downtime for users. It's pretty much worked fine except this issue. (I ...
2
votes
2answers
20 views
SSMS import large table
I'm trying to move several tables of data between 2 MSSQL 2008 databases, I have generated data insert scripts for one table which is quite large (around 3.5M rows) The script is around 3GB. When I ...
0
votes
1answer
49 views
Connecting to a SQL Server instance via connection string does not work
Why does this work to connect to my remote SQL Server database:
var srvConn = new ServerConnection("sql01");
srvConn.LoginSecure = false;
srvConn.Login = ...
1
vote
2answers
129 views
C#/SQL Server: Login failed when connecting from remote machine
I've got an SQL Server 2008 Express set up on one machine and am trying to connect with my C# app to the server from another machine (both Win 7). The server machine has a user account for me in the ...
0
votes
1answer
40 views
SQL Server 2008 service pack installation error
When I am trying to install the SQL Server 2008 service pack I am getting the error as:
There are no SQL Server instances or shared features that can be
updated on this computer, and The version ...
1
vote
1answer
30 views
SQL Server Log Databases Starting Up Every Hour
I have been doing an audit of my SQL Server log, as I 'thought' it was locked down but appeared to be open and we were getting a lot of password attempts on the SA account.
After sorting that, I have ...
1
vote
0answers
20 views
Can the table spool operator be parallelised?
Is there something inherently unparallelisable about the table spool operator in SQL Server? I've got several queries that use parallel operators throughout due to the size of the tables, but by ...
0
votes
1answer
39 views
Database server migration and SQL Server 2008 licensing [closed]
Possible Duplicate:
Can you help me with my software licensing issue?
We currently have a dedicated server that hosts a number of websites and also has SQL Server 2008 Enterprise running on ...
0
votes
1answer
26 views
SQL Server 2008 R2:error
insert into [ULGP_CARES TEST].[dbo].[person](date_of_birth)
select [Dtest].[dbo].[ContactBase].[BirthDate]
from [Dtest].[dbo].[ContactBase]
where
[Dtest].[dbo].[ContactBase].[FirstName]=[ULGP_CARES ...
0
votes
1answer
40 views
Unable to save view: “There is already an object named 'Quotes' in the database.” - Error 1222
I often get the aloof error message above, after trying change a view in SQL Managment Studio 2008. I right-click on a view, select 'design', make a change (or not), and click the Save button.
It ...
0
votes
0answers
25 views
Perfmon - Migrating Win2008 counters in XML format on Win2003 server
I have an XML file containing SQL 2008 R2 counter sets for Windows 2008 Perfmon. I would like to migrate these to a Windows 2003 server with SQL 2005.
How can I do this? Thanks!
0
votes
1answer
33 views
ASP.NET Application Connection String and SQL Server Security / Permissions
I am deploying an ASP.NET application and SQL Server (2008) database on a live (production) server. The physical server is running both SQL Server 2008 and IIS 7 - it is provided by a hosting company ...
0
votes
3answers
50 views
“Virtual” shared storage for SQL Server 2008 R2 Cluster
I am trying to set up a virtual test environment for a SQL Server 2008 R2 Cluster (2 nodes) running on Hyper-V. The cluster requires a shared storage to function properly, however in this test ...
4
votes
2answers
230 views
MS SQL access to restored database without sysadmin role
I have databases from different projects on one server. I can't give all developers administrative (sysadmin) access to the databases. They have to have the permissions needed to create and restore ...
0
votes
1answer
48 views
Rebuilt nonclustered indexes quickly get fragmented again
I've got a couple of nonclustered indexes on tables that have rows inserted quite often. These indexes are currently around 90% fragmented, according to SQL Server. If I rebuild them, they go down to ...
