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
0answers
7 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
10 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 ...
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 ...
-1
votes
1answer
23 views

Unable to Repair MSSQL 2008 R2 after Promoting to Domain Controller [on hold]

I had to promote a MS SQL Server running MSSQL2008R2 to a domain controller. Running Windows Server 2012 R2. Afterwards MSSQL service will not start, I know it's because it was using local privileged ...
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
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 ...
0
votes
3answers
3k 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
0
votes
1answer
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 ...
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: ...
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
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 ...
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 ...
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 ...
0
votes
0answers
14 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 ...
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 ...
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 ...
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
97k views

Adding an administrator user to SQL Server 2008

How do you add an administrator user to SQL Server 2008?
2
votes
3answers
356 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
29 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
6k 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
23k 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
22 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
5k 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
49 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
51k 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
13k 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
21 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
398 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
12k 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
13k 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
43 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 ...
2
votes
3answers
2k views

Database Mirroring Properties Page Missing

I am having a problem with one database on my SQL Server 2005 production server. A number of databases are already set up for mirroring, however when I right click and go to properties in SSMS, on ...
1
vote
1answer
23 views

How to handle replication post SQL Server 2000/2008 migration?

I have two servers; server A host SQL Server 2000 and server B ( a remote server) host SQL Server 2005. I replicate data between these two servers using transactional replication. I recently migrated ...
3
votes
0answers
151 views

Exit code 0x84C40013 in silient installation of SQL 2008 service pack 3 installation

Following Command is utilized for installing SQL SP3 pack in Windows server 2008 R2. start /WAIT C:\Temp\SQLSP3.exe /quiet /IAcceptSQLServerLicenseTerms /Action=Patch /AllInstances This complete ...
1
vote
2answers
95 views

How to free up disk space on a drive which has BiztalkMsgBoxDB_log file in it

I have been asked to analyze a issue regarding one of the biztalk servers. I was asked to free up space on a particular drive, where I found the only file BiztalkMsgBoxDB_log.bak is taking up close ...
3
votes
2answers
30k views

how to change sql server product key

my version of sql server 2008 Enterprise edition has expired and I have a new key how to change the old key without uninstall or any modification to the installed server or instances.
0
votes
1answer
669 views

SQL service log on account

I installed SQLServer 2008 Express and pretty much took all the defaults. After about a week of running an app that hits this database I changed the administrator password for the server. About a day ...
1
vote
0answers
17 views

Repeatedly prompted to restart the computer when installing SQL Server 2008 R2 on a x64 Win 8.1 machine

I am trying to install SQL Server 2008 R2 on a Win 8.1 x64 bit machine. When running the installer, I get the Reboot Required check failing the install. I have tried rebooting, no difference. I ...
8
votes
6answers
13k views

How can I have SQL Server Management Studio 2008 connect to my instances automatically?

I'm running a server with 3 database instances. Right now, when I open Management Studio, it opens the "Connect" prompt that lets me choose which instance I want (or connect to anything else). Would ...
0
votes
0answers
33 views

Running SQL Server based Program Via VPN

I have recently set up a site-to-site VPN. Location A has a PC running windows 7 (we'll call it Computer1) that acts as a server for a point of sale program. The program uses SQL Server 2008 to store ...
10
votes
2answers
76k views

What is a SQL Server instance?

When I install SQL Server 2008 Express in prompts me to create an instance and aborts if I don't. Then I see that information in an entry in Sql Server Configuration Manager on SQL Server Services. ...