SQL Server 2008 is Microsoft's version of SQL Server following SQL Server 2005. A list of the new features can be found here
0
votes
1answer
28 views
MS SQL Server Query Timeouts
I've got a server hosted at Rackspace that is a pretty beefy machine (dual hex core, 48 GB of RAM) and our database isn't all that big (100GB or so). SQL Server 2008 R2 Standard 64 bit.
Normally, ...
1
vote
0answers
21 views
SQL Server 2008, switching to simple recovery mode [migrated]
Currently our transaction log is 50 GB; impressive huh?
I want to switch to simple recovery mode and remove the transaction log entirely.
Do I need to stop any user activity and detach the database. ...
-1
votes
1answer
24 views
Two SQL Server Instances / Two Different Domains
We have two different active directory domains. Is it possible to have to SQL Server 2008 instances running on the same machine and have each instance tie to a separate domain?
0
votes
1answer
17 views
sql script mssql express 2008 windows 2008 server R2 x64
Scenerio:I need to run an update sql script after another scheduled task.
server=Windows Server 2008 R2 x64
db = Sql Express 2008
when? - Everyday buy Sunday(i know how to do this)
Why? A third party ...
3
votes
1answer
66 views
Unable to start SQL Server 2008 service
I am running SQL Server 2008 R2, and I am having an issue with my local server instance. At first, this only happened occasionally and seemingly completely randomly, but was fixed when I restarted my ...
2
votes
1answer
46 views
Do I need to back up the SQL Server Encryption Password and Symmetric Key?
I'm trying to setup SQL Server to use Cell-Level Encryption on some sensitive data. It seems straightforward per this example on the MSDN:
Create the Master Key with a strong password.
Create a ...
3
votes
1answer
28 views
SQL Server PowerShell cannot find path error
I cannot use Set-Location to change to a database. I have loaded the SQL Server snapins. I can use Set-Location to get to SQL\Localhost\SQLEXPRESS\, and I can show the paths under the server node with ...
0
votes
1answer
37 views
Using different ports with multiple instances on SQL Server
In our development environment, we have numerous named instances of SQL Server 2008 running. I have recently added a new one it doesn't work as expected. Here is our set up:
DEFAULT on ...
1
vote
0answers
8 views
Executing Stored Procedure that accesses another SQL instance [migrated]
I apologize if this question repeats another already asked. I have searched for hours and have not found one that fits my situation.
Desired Outcome
A user using SQL authentication has execute ...
0
votes
0answers
6 views
securely exposing sql server 2008 for windows authentication [migrated]
we have an internal sql server 2008. currently we do not expose the IP to the outside.
we will have 100 users connecting to this database remotely, and now we will have to expose the IP to the ...
1
vote
1answer
44 views
How to clear stale Server Name entries in the Sql Server Management Studio Connection Dialog?
All but one of the following entries are stale/don't exist and I just want them out. I've Ctrl-F'd the registry but to no avail. Any ideas?
0
votes
1answer
64 views
Can I install SharePoint Foundation 2010 with full SQL Server 2008?
I cannot find out how do I install SharePoint Foundation 2010 with full SQL Server 2008, it seems that installation wizard forces me to use Express edition. Is there a way to use Foundation with ...
0
votes
1answer
97 views
Can't update SQL Server 2008 to SP3, it only offers the option to create a new instance
A colleague is attempting to update our server's SQL Server 2008 version 10.0.1600.22 (not R2) install up to SP3. Unfortunately, we can't work out where the "Update" button is; the installer seems to ...
0
votes
1answer
20 views
SQL Server 2008 Management Studio Express: won't recognize local instance
I’m having a lot of trouble getting Management Studio Express 2008 to recognize my local instance of SQL Server 2008 (SQLEXPRESS).
Background: I’ve installed SQL Server 2008 x64 a few times today; I ...
0
votes
1answer
27 views
SQL Server reporting services shutting down without log info
Using SQL Server 2008 Reporting services. Finding that the service is shutdown without anything in the windows event log or in SQL Server events. I see the log entry for the service starting when I ...
0
votes
1answer
39 views
Setting Local Policy not working?
What could I be doing wrong here?
Added Everyone to local security settings (testing purposes only)
Forced the policy to update with gpupdate /force
ran whoami /priv
The permission I added is ...
0
votes
2answers
61 views
Can't Connect to (local) database
I have SQL Server 2008 and was forced to make a new windows 7 profile. I no longer can connect to my (local) databases.
Everything I try to use windows authentication to login I get
Cannot ...
0
votes
2answers
40 views
Upgrade sql server 2008 to 2008 R2, in-place upgrade or new install
When upgrading we normally create a new install and migrate databases over, but we are going to test out in-place upgrade from sql server 2008 to sql server 2008 r2 (standard) in our development ...
1
vote
3answers
69 views
Can we restart a SQL Server instance remotely?
I am connecting to SQL server 2008 R2 from a remote machine, but when i right click on the instance in object explorer it shows me Start,Restart,Stop, Pause, Resume options disabled
I am connecting ...
1
vote
1answer
12 views
FTS - Index rebuild causing CPU issues (SQL Server 2008 R2)
I am encountering some critical issues on SQL Server 2008 in a production environment; We have a database that contains a FTS index; we also have a maintenance job that rebuilds the FTS index and ...
-1
votes
2answers
63 views
New server: use for SQL Server or Windows (Web)? [closed]
I picked up a new Dell R410 2.8 Ghz 12M cache 32 GB Ram RAID-1/RAID-1 for a good year-end deal. It was purchased mainly to replace my Dell PowerEdge 2850 which is my main WEB server. I run Windows ...
0
votes
3answers
36 views
How do I update the SQL Server 2008 to include the studio?
How do I update the SQL Server 2008 to include the studio?
Here is what I currently have on my machine:
I assume I am supposed to clidk on "SQL Server Installation Center"
From there I get this ...
1
vote
5answers
132 views
database sync across servers in SQL 2008R2
as we are in the process of expanding of businees, now we are stepping a ahead to add few more datacenter, now we have a requirement where we need to sync the production database with other ...
0
votes
3answers
72 views
Does sql server standard come packaged with windows server 2008 r2?
Does sql server standard come packaged with windows server 2008 r2?
0
votes
1answer
59 views
Scripts to automate maintenance on thousands of databases?
We have a web application that, for government-regulated security reasons, requires each client to have their own database. As a result, we have a few thousand small databases that all have the ...
1
vote
1answer
29 views
SQL 2008 SSMS cannot connect to local default instance. Error 87
SQL Server 2008 Std SP1 CU2 (10.0.2714.0) on Windows Server 2008 Std SP2.
I have multiple instances running on this server. With SSMS I can browse and connect to other named instances on this server ...
1
vote
1answer
45 views
Creating a clone of a SQL Server database via backup/restore
So I'm trying to 'clone' a SQL Server database by making a backup of the template, then restoring it to the new name. However, there's either something I'm missing or something I don't understand ...
0
votes
2answers
41 views
Efficient way of importing large amount of data into SQL Server 2008 from MySQL
Alright, to start, please don't comment on the switch from MySQL to SQL Server 2008 - I tried to resist this decision - I know it's not ideal, but it's the reality of what I am trying to do. I'm ...
0
votes
1answer
16 views
SSIS package hangs on Setting Source Connection
I have an SSIS package that has been executing successfully for the last 7 years.
All of a sudden the package won't run and hangs at the Setting Source Connection step and has to be closed down via ...
0
votes
0answers
28 views
Sql Server 2008 Full Text Seach performance issues
We have the following setup for an web application:
Server
Intel Xeon E5606 @2.13GHz (2 processors - quad core)
24GB RAM
Software
SO: Windows Server 2008 R2 Standard (SP1) x64
Microsoft SQL ...
0
votes
1answer
96 views
SQL Server Partitioning, best practices for creating partition scheme's and functions
I'm implementing Partitioning for the first time in SQL Server 2008r2. I've several large tables that I am partitioning.
My main question is should I use the same Partition Scheme and Function for ...
0
votes
0answers
39 views
“Could not load file or assembly” Error in MS SQL Server 2008
I reinstalled MS SQL Server 2008 after uninstalling it. I ran into an issue where two previous instances where still on my OS (Windows 7 Professional 64-bit); I could not remove those instances. I ...
2
votes
1answer
42 views
Database unusable whist doing a database restore (SQL Server 2008 R2)
I was asked to create a database from a backup for reporting and whilst transferring the file from backup to a disk on the server the database became unusable.
Then again whist running the restore ...
1
vote
1answer
92 views
Can't re-install Microsoft SQL Server 2008 R2 with Default Instance
I installed MS SQL Server 2008 R2 and I named my default instance "MSSQLSERVER". I want to uninstall that instance and start over. I used the Programs and Features control panel to completely remove ...
2
votes
1answer
48 views
'Service does not respond in a timely fashion' error when restarting Sql Server
When I try to restart my SQL server, I get the following error:
Why this error happens and how to solve this?
0
votes
1answer
23 views
Cannot install SQL Server 2008 R2 service pack 1
upgraded SQL 2008 t0 2008 R2 the other day.
Rebooted the server had the software team check the databases.
Everything worked fine
I tried installing 2008 r2 service pack 1 and the installation ...
0
votes
1answer
35 views
Is it possible to install SQL instances with different Collations in a SQL Cluster
We have a two node active-active SQL Server 2008 Cluster. Running on Windows Server 2008 R2.
The three excisting instances have Latin1_General_CI_AS as the Server Collation. I need to add an instance ...
0
votes
1answer
35 views
Can't Open SQL DTS Packages
We have a SQL 2008 server. When trying to open DTS packages we'd get this error:
"SQL Server 2000 DTS Designer components are required to edit DTS packages."
Installing SQL Server 200 DTS Designed ...
1
vote
1answer
110 views
Install & Configure PHP to MS SQL Server on Windows 7 (64bit)
I have been striggling to set up the following scenario:
Apache 2 (64bit) running on Windows 7 (64bit)
PHP (64bit)
MS SQL Express 2008 as (local)
I have managed to install and configure both ...
0
votes
2answers
43 views
Unable to shrink the transaction log file in Sql Server 2008
Am using the below to script shrink the transaction log
*USE AVPC
GO
BACKUP DATABASE AVPC
TO DISK = 'H:\DBBackup\AVPC\FullBackUp\AVPC.bak'
USE AVPC
GO
BACKUP LOG AVPC
TO DISK = ...
0
votes
2answers
49 views
SQL server backups - backwards situation
Hi I'd like to know if it seems feasible to do things in this manner.
We have several application servers (a web server for intranet applications, a couple of different app servers). Each server is ...
0
votes
1answer
89 views
MSSQL techniques to archive-backup content
We are now moving from a MySQL to a MSSQL 2008R2 database. As the project is a web application that we need to be able to scale well, we need to rework the way the DB handles data.
We have 3 separate ...
0
votes
1answer
20 views
MS SQL Agent fails with domain account fails to restart MSSQLSERVER Service (2008R2 Standard)
I recently was asked to bring a new SQL server online. Having no experience with this I of course did quite a bit of research on best practices. The install went without any issues with the exception ...
0
votes
1answer
50 views
One SQL, lots of SharePoint 2010 Servers, and lots of Databases to clean
I have a dedicated server running SQL server and many web servers running SharePoint 2010 installations. All the SharePoint web servers are using the same SQL server for storing/creating databases.
...
1
vote
1answer
125 views
The package failed to load due to error 0xC0011008 Error Loading from XML
Environment:
Windows Server 2008 SP2 Enterprise Edition 64-bit
SQL Server 2008 SP3 Standard Edition 64-bit
Previously had SQL Server 2005 Developer Edition 32-bit Integration Services. That has now ...
0
votes
2answers
43 views
SQL Server 2008 Express R2 restores after restart (and fails)
Almost every time I restart the machine hosting a SQL Server 2008 R2 express server, the database goes through the restore process. Most of the time, the database will become stuck in the restore ...
6
votes
5answers
311 views
Virtualizing Microsoft SQL Database server
My company is looking to virtualize our Microsoft SQL server. I read on another question that databases on VM's suffer from a IO bottleneck which is not very good for us. But I was wondering if ...
0
votes
0answers
14 views
CPU specification for implementing SQl cluster DB merge replication between sites?
I wonder if I need 8x vCPU for the Database server which performs weekly Merge Replication, because at the moment I've build like the following:
Windows Server Enterprise 2008 R2 SP1
SQL Server 2008 ...
1
vote
1answer
55 views
Server license - to purchase or not? [closed]
Possible Duplicate:
Can you help me with my software licensing question?
As an sys admins we need to provide our development team with both an integration and development environment. ...
6
votes
2answers
164 views
Windows File Cache drops suddently
I have a 64-bit Windows 2003 server with 48 CPU cores and 128GB of RAM running a single application (SQL 2008 Analysis Services). SSAS is currently using about 50GB of memory.
SSAS relies to a ...
