A version of Microsoft's database server, released in August 2008. This is different than SQL Server 2008R2.

learn more… | top users | synonyms

1
vote
1answer
2k views

Exception Enumerating SQL Server Instances with SMO WMI ManagedComputer

I'm trying to use the SMO WMI API/objects in PowerShell 2.0 on Windows 7 with SQL Server 2008 R2 installed to get a list of SQL Server instances on the local computer using the Managed Comuter object. ...
1
vote
2answers
4k views

Could not continue scan with NOLOCK due to data movement during installation

I am running Windows Server 2008 Standard Edition R2 x64 and I installed SQL Server 2008 Developer Edition. All of the preliminary checks run fine (Apart from a warning about Windows Firewall and ...
0
votes
1answer
2k 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 ...
1
vote
1answer
1k 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. ...
0
votes
3answers
4k views

Disable remote access for one user/database in SQL Server 2008

is this possible to disable remote access for one user or database in SQL Server 2008? Thanks
10
votes
8answers
29k views

Activity monitor is unable to execute queries against server

Is there any fix to get SSMS activity monitor working? Problem: SQL Server Activity Monitor fails with an error dialog: TITLE: Microsoft SQL Server Management Studio The Activity Monitor is ...
1
vote
0answers
16 views

Appropriate clustered file system for SAN drive connected to two windows hosts [closed]

I am a SQL Server DBA and my questions is a sysadmin one...so please forgive me for being blunt in some terms or phrasing things weird. I am looking for a solution to connect a iSCSI SAN drive to two ...
1
vote
2answers
980 views

Backup microsoft SQL server 2008 to OneDrive [closed]

Is there an option to automate a backup to Microsoft Onedrive every night? The machine is a Windows server 2008 R2. I would like to to able to automatically upload my backups to OneDrive. I was ...
0
votes
2answers
4k views

Error: Package 'Microsoft SQL Management Studio Package' failed to load. In SQL Server Management Studio

I had installed SQL Server 2008 R2, the installation was succesful. But I can't open the Management Studio because this error is shown: Package 'Microsoft SQL Management Studio Package' failed to load....
0
votes
1answer
1k 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
2answers
2k views

SQL 2008 install failed - Could not find the Database Engine startup handle

My SQL 2008 install failed, I'm getting this error: Could not find the Database Engine startup handle This happens after uninstalling SQL Server 2008 and trying to install SQL Server 2008 R2, any ...
2
votes
1answer
2k views

SQL Server instance shuts down

I'm currently developing a new ASP.NET project hosted on a Windows Server 2008 RC2 with an SQL Server 2008 Express database. I have three SQL Server instances (for different purposes) running which ...
0
votes
1answer
2k 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 ...
3
votes
2answers
1k views

Unable to uninstall SQL Server express

When I try, I receive the following error message: A computer restart is required. You must restart this computer before installing SQL Server. Of course, I have restarted the computer :-) ...
2
votes
1answer
1k views

How to backup/restore excluding filestream varbinary in SQL Server 2008?

There is an application used in a production site that uses SQL Server 2008 as its DBMS. The database schema uses Filestream Varbinary to save binary data on the filesystem instead of directly into ...
0
votes
1answer
1k views

SQL Server 2008 (SP2) Exception has been thrown by th target of an invocation (mscorlib)

The following error started after renaming my SQL Server 2008 (SP2) Instance with a new name. Now unable to open the maintenance task that previously running with the old instance name, also the web ...
1
vote
3answers
19k views

MS SQL Server 2008 R2 Product Key

We are needing to perform a repair installation of our MS SQL Server 2008 R2 installation and cannot locate our original product key. Is there some way in which we can recover our product key from ...
0
votes
1answer
2k views

Cancel/Kill SQL-Server BACKUP in SUPSPENDED state (WRITELOG)

I have a SQL 2008 R2 Express on which backups are made by executing sqlmaint from windows task planer. Several backups ran into an error and got stuck in state SUSPENDED with wait type WRITELOG. How ...
1
vote
2answers
4k views

SQL 2008 R2 replication error: The process could not connect to Distributor

I have two servers running SQL 2008 R2 Standard, each with an instance named "MAIN". I have a small test database on my primary server (one table, 13 rows) that I want to replicate to a second server ...
1
vote
1answer
4k views

Why does RDP freeze on Windows Server 2008 R2 in a virtual machine during high load?

We have noticed a problem where remote desktop sessions to a server will freeze when the server has high CPU load. Environment: VMWare ESX 4.0u1. Guest OS is Windows Server 2008 R2 (this is the ...
3
votes
1answer
5k views

The OLE DB provider “SQLNCLI10.1” has not been registered.; 42000

I have a SQL Server 2008 Analysis Services Project. In the Data Source View I have a Named Query which references a single Data Source containing three tables. The Project processes successfully and ...
3
votes
2answers
5k views

AclPermissionsFacet fault install SQL-2008-R2

While attempting to do an installation repair of SQL-2008R2, I'm failing the pre-check rules. Module that is failing is AclPermissionsFacet - with this message "The SQL Server registry keys from a ...
0
votes
1answer
35 views

Cdrive out of space,How to extend from another disk

We have a Windows Server 2012 with only C drive with 278 GB space.now c drive have only 20 GB free space,here running ms sql server 2008.how can i extend volume C from another disk without data loss? ...
0
votes
3answers
7k views

windows could not start sql server ( error 1067 the process terminated unexpectedly)

When i start SQL Server 2008 in my computer this error windows could not start SQL Server (mssqlserver) service on local computer error 1067 the process terminated unexpectedly.
1
vote
1answer
3k views

Why does Server 2008 running SQL 2008 produce a FlushFileBuffer exception?

Hi I run 64bit SQL2k8 on 64bit WS2k8, and backup a database to a UNC file. The backup creates the file, copies the data, and when finishing, crashes. Backup database Infovest to disk = '\riscsrv-...
0
votes
1answer
9 views

ODBC--connection to 'systemDSN' failed

We have a Microsoft Access 2010 database (ACCDB). This ACCDB file is just a front end to a Microsoft SQL Server 2008 database. Authentication to the database is accomplished by Windows integrated ...
0
votes
6answers
6k views

MS ReportServer refuses to work with domain account

I have installed SQL Server 2008 ReportServer on dozens of servers, all virtually identical. It was always possible to configure it to use a domain account (the same one on all those servers). However,...
0
votes
0answers
30 views

Same Query,Same execution plan ,Same argument why different duration

I have a query which some times takes longer than normal .the thing is query and parameter and execution plan and reads and cpu are all the sam every time but sometimes it is slow .there is also no ...
0
votes
1answer
29 views

How to change interface language of sql server 2008?

As you can see in the image below, the SQL Server Interface language is in Spanish and I want to change to English. I tried my best to find a way to change it without uninstalling this Spanish ...
0
votes
0answers
17 views

SQL Server SSMS/Other Processes Allow Login from Untrusted and Unassociated domain

We have a Windows/SQL server development environment which is completely separate from our developers primary systems, including completely separate domains (no forest association, etc.) Our SQL ...
3
votes
1answer
2k views

Possible to join an Amazon RDS SQL Server 2008 instance to a Windows Domain?

We're planning on using an Amazon RDS MS SQL Server 2008 instance in our Amazon VPC. Since we don't have access to the underlying OS for RDS, I was wondering if it's at all possible to join an RDS ...
23
votes
5answers
100k views

Adding an administrator user to SQL Server 2008

How do you add an administrator user to SQL Server 2008?
2
votes
3answers
358 views

How do I restore a SQL Server database from last night's full backup and the active transaction log file?

I have been told that it's good practise to keep your SQL Server data files and log files on physically separate disks, because it'll allow you to recover your data to the point of failure if the data ...
1
vote
2answers
1k views

Installing SQL Server 2008 SP2 fails in 2003 cluster setup

When I try to install SP2 (or simply "repair" the SQL Server installation), the dependency check finds the following problem: Rule "Not clustered or the cluster service is up and online." failed. ...
0
votes
1answer
89 views

SQL Server database restore to same pc

I am trying to restore sql server database bak file to same server but with different name. When i run restore original database starts showing restoring. I have changed old database Logical Name and ...
4
votes
3answers
7k views

How does SQL Server handle simulataneous read/write requests?

Background: We have an application which uses an SQL Server 2008 database heavily. We are trying to optimize this application. It was single threaded, and we noticed through logging/ profiling of the ...
4
votes
5answers
26k views

How to recover the database which is accidently deleted using sql server 2008

How to recover the database which is accidently deleted using sql server 2008?
0
votes
1answer
23 views

SQL server 2008 R2 - Hardware Requirement

I have to give SQL server hardware requirement for the below specifications Number of instances <= 5 Number of databases per instance > 50 Number of concurrent users per instance <= 2000 Daily ...
0
votes
3answers
6k views

Restore SQL Database From BAK File using a SQL Query

I have my database backing up to the hard disk in the format of BAK file. I am trying to restore that backup, but I unable to do so. Here is my query: ALTER DATABASE DBASE SET SINGLE_USER WITH ...
3
votes
6answers
1k views

SQL Clustering on Hyper V - is a cluster within a cluster a benefit

This is a re-hash of a question I asked a while back - after a consultant has come in firing ideas in to other teams in the department the whole issue has been raised again hence I'm looking for more ...
-2
votes
1answer
51 views

SQL Server Backup Procedure and different types of backup [closed]

Need to know perfect solution on how to backup SQL server Database Version SQL server 2008 R2.
9
votes
3answers
54k views

How can I see who is connected to my db?

I was trying to rename a database and it said that it needed to be exclusively locked to perform this operation ... How can I check who is connected to it?
2
votes
5answers
14k views

Error when restoring database (Windows 7 test environment)

I have a windows 7 operating system as a test environment. I have SQL Server EE installed with two instances, named as test and production. I took a full backup from AdventureWorks database from test ...
1
vote
1answer
23 views

MICROSOFT SQL SERVER MANAGEMENT STUDIO 2008R2, new schedule, what it does and where it goes?

I just clicked sql server agent -> new schedule -> named it thisisjustatest and scheduled it to run tomorrow at 1 am. I would like to find that schedule and delete it. I can't find it anywhere. The ...
0
votes
1answer
406 views

Dynamics AX 2009 Falls Over when SQL Cluster Rolls

We had an issue on one of our production database nodes which caused it to fail over to another. This caused a brief outage whilst the service rolled. This temporary glitch however was enough to ...
2
votes
3answers
1k views

What SQL Server Query will set perfmon counter “Longest Transaction Running Time” > 0

I'm trying to decide whether this performance counter is worthwhile monitoring: \\SERVER\MSSQL:Transactions\Longest Transaction Running Time. So during testing I tried to create some long running ...
4
votes
9answers
18k views

How do I solve MSSQL 2008 install error, “The MOF compiler could not connect with the WMI server”?

Possibly related to: SQL Server 2008 Install fails error reading etwcls.mof After manually removing MSSQL 2008 from my system (uninstall failed to remove two instances), I receive the following ...
-2
votes
4answers
13k views

How to make SQL Server visible on internet? [closed]

This is embarrassing for me, but I have no idea what to do. I want to connect to SQL server from my home and field office; what else should I tweak? I could use VPN (it works), but I* prefer to ...
7
votes
4answers
14k views

Is there a way I can use SQL Server management studio to find all columns that have column names that contain a certain substring?

I'm using SQL server management studio 2008. I have a huge legacy database with thousands of columns. It would be nice if I could search for all columns whose names contain a certain substring. Does ...
0
votes
0answers
53 views

SQL Server - Database Transaction Log Backup. Appended or seperate files?

we have 30 productions databases in our SQL server. top big DBs are 60GB, 40GB, 8GB, 5GB and the rest are 1GB or less. we have incremental transaction-log backup set-up currently every-hour by ...