Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [sql-server-2008]

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

0
votes
0answers
17 views

Restoring SQL Database with NoRecovery stuck

We are moving from a SQL 2008 standalone instance to a SQL 2016 HA Failover Cluster Instance (FCI) with an AlwaysOn Basic Availability Group (BAG) configured to replicate to a standalone DR instance ...
0
votes
0answers
16 views

SQL Server 2008 R2 VSS Image Backup Performance Issues

We’re using a ShadowProtect backup solution to provide volume backups for a large SQL Server. It’s got a pretty good I/O subsystem, using several raided SSD drives. The data drive has no writes to ...
-1
votes
1answer
32 views

Firewall refuse my connection to DB

We are working on software that require to connect to database on the server (Win2012)(LAN), after activating windows firewall, we couldn't connect to DB. I've set a rule for inbound and I Excluded ...
0
votes
1answer
47 views

SQL Server Sort Order to Binary Search on SQL Server 2008 SP1

I am installing an OLT Software that requires Windows SQL Server 2008. I am getting this error below; The database sort order must be "binary sort". Please run the Transact-SQL command ...
0
votes
0answers
32 views

Why does BIDS installation for SQL Server 2008 fails with error 1911?

I am trying to Install Business Intelligence Development Studio and I get this error message: Error 1911. Could not register type library for file C:\Program Files (x86)\Common Files\Microsoft Shared\...
-4
votes
1answer
422 views

sql server can't start error code 1814

My pc can't start sqlserver 2008 R2. this is my sql server errorlog 2018-05-02 16:32:47.26 Server Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) Apr 2 2010 15:48:46 Copyright ...
1
vote
0answers
50 views

SQL Merge Replication Triggers Missing

In MS SQL Server 2008R2 SP3 Standard, I'm seeing an issue where reinitializing a merge publication with a new snapshot deletes all of the merge triggers from all of the tables, and then when snapshot ...
0
votes
0answers
98 views

SQL Server Error Log error: 17120, 17826,17182,26054

In our SQL server environment we have SQL Server 2008 R2 Enterprise edition installed in Windows Server 2008 R2 SP1 clustered environment. One of our vendor accidentally deleted the virtual server ...
0
votes
0answers
233 views

sqljdbc4.2 cannot connect to SQL Server 2008 R2 after disabling TLS v1.0

There is a vulnerability reason that we need to apply a patch to disable TLS v1.0, and after that, our JDBC driver failed to connect to SQL Server 2008 R2. Environment: JRE 1.8 (Not able to downgrade ...
0
votes
1answer
2k views

SQL 2008 on windows 2008 R2 not working when TLS 1.0 and 1.1 is disabled

I have a problem with SQL 2008 on windows 2008 R2 when TLS 1.0 and 1.1 is disabled. After I disabled TLS 1.0 and 1.1 I cannot start SQL Service. and event viewer shows these errors : i searched ...
9
votes
2answers
7k views

Microsoft SQL Server login using Active Directory Credentials

Our Microsoft SQL Servers are running on Windows Servers which are part of an Active Directory domain. For easy user management, our SQL authorization is set up by using the Active Directory User ...
0
votes
2answers
224 views

SQL: server 2008 database stuck in Restore

I have two SQL Server 2008 R2 servers one for PROD and the other for DR. I am trying to add log shipping for a database called School. Steps so far Back up School database Restore with database ...
3
votes
1answer
1k views

What is the “Microsoft SQL Server 2008 R2 RsFx Driver” and can I run SQL Server without it?

Our German hosting company complains about licensing issues with our SQL Server Express installation and demands us to uninstall (or re-license) the following components: Microsoft SQL Server 2008 R2 ...
0
votes
2answers
101 views

Server 2008 R2 Replication Small Issue

I have two 2008 R2 Servers. When I Connect those two Servers By Name, I Can Use Replication. But When I Connect This Two Servers By IP Address, I Can't Use Replication. I Get Error Like: SQL ...
0
votes
1answer
436 views

Programs crash after joining the server into a Domain

UPDATE: Problem solved We decided to upgrade the computer from Windows Server 2008 to Windows Server 2008 R2, after reboot, all the problems where fixed. Every app can be executed from domain users. ...
4
votes
1answer
101 views

Migrate SQL 2008 database to Azure

I am migrating a SQL server 2008 R2 production database to Azure SQL database service in the cloud. Is it possible to mirror/replicate the Azure database from the 2008 R2 database? So I can just ...
1
vote
1answer
195 views

Move SQL 2008 database to Azure

I need to move a SQL 2008 R2 on-premis database to an Azure SQL cloud database. The database is to big to script out with data and Azure SQL cloud cannot restore a standard .bak file. Trying to use ...
3
votes
1answer
774 views

How can I resolve CPU utilisation nearing 100% on IIS

I have a .net web API application and the required SQL server hosted on an IIS. The task manager shows 100% CPU utilization most of the time, but memory usage is fine. How can I analyze and fix what ...
0
votes
1answer
58 views

SQL: Re-Index/Re-Build Entire DB

I am tired of re-indexing/re-building every table I have, is there any way to do this to an entire database?
0
votes
1answer
23 views

how do i make a schema for sql server 2008

Brand new Jr. Sys Admin here, trying to wrap my head around the system in place. We've got a DB on Microsoft SQL Server 2008 and I want to get a visual on what tables & Fields are in place. Just ...
0
votes
1answer
40 views

sqlexpress 2008 connection error 40 when connecting through internet static ip

I installed SQL Server 2008 on a workstation running windows 7 SP1. I am trying to connect to the server through the internet using a static IP address and port 1433. I can connect with this IP ...
0
votes
1answer
223 views

SQLServer 2008 services broken after Visual Studio 2015 installation (sqlcmd shows nothing) [closed]

This is my SQL Server. MSSQL 2008 (not R2): Sql Server 2008 MSSQLSERVER MSSQL10.MSSQLSERVER Database Engine Services 1033 10.0.1600.22 After installing Visual Studio 2015 with SQL ...
0
votes
1answer
291 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
1answer
186 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
1answer
1k 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
1answer
114 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 ...
0
votes
1answer
35 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 ...
-2
votes
1answer
74 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.
1
vote
1answer
28 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 ...
3
votes
1answer
1k 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
0answers
73 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 ...
0
votes
0answers
90 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 ...
1
vote
1answer
63 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 (...
2
votes
1answer
168 views

Is there any gain from using multiple files in SQL server for raid-5 configuration?

We are setting up a server with five 240GB ssd as raid-5 configuration into one logical drive. We're planning to partition the logical drive into four drives on windows server. In SQL server, would ...
1
vote
2answers
738 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 90%...
0
votes
1answer
20 views

sql server 2008 cant insertproduct key

I am trying to install SQL Server 2008 in a Windows Server 2008, but when i have to enter the product key, all option are blocked, and I can´t put the key or select a evaluation version.
1
vote
1answer
178 views

Using Linked SQL Servers from a different server

I have 3 machines that are involved in running a SQL script: JumpBox - A machine that serves as a stable point for automation to run. ReportBox - A machine that holds reporting databases and logic. ...
1
vote
1answer
312 views

MSSQL - Can Maintenance Plan wait for Agent Job Task to be completed?

I did start a Maintenance Plan project with Execute SQL Server Agent Job Task box. I added another task on success event. I realized that I was wrong. The second task is executed in parallel, because ...
-3
votes
1answer
49 views

System databases are in standby…how can I make them editable?

My System Databases are stuck in a standby/read-only state. RESTORE DATABASE msdb WITH RECOVERY does not seem to have had any affect. How can I get them out of the standby state?
-1
votes
2answers
87 views

Database sql server Mirroring or replication

I have SQL server 2008 R1 with standard edition. I have a large database i.e. 500GB that i.e. growing rapidly 10GB a month .It is a cloud based solution. We have another data center where the ...
1
vote
0answers
183 views

What are the limitations of using a scheduled Windows Server Backup instead of SQL Server backups?

We've taken over development and server admin for an e-commerce site, and the client has opted for a well-specced dedicated server, including a second drive for daily Windows Server Backups. However ...
0
votes
1answer
61 views

How to handle a large table on SQLServer

There is a database on our server that has a 120GB backupfile. The server has limited diskspace and I cant even restore a second copy of that database. There are mainly 2 tables in the databse that ...
0
votes
1answer
747 views

PHP Trouble Configuring SQLSRV

I am working on learning PHP, and one of my goals is to be able to connect to an SQL Server database. I am on a virtual Windows 2008 Server and have 32-bit PHP 5.6.0 installed. I have downloaded the ...
-1
votes
1answer
166 views

Use reporting service configuration to configure the database source name

So im upgrading to R2. When i get to the Reporting Services Authentication step i get the error: There are validation errors on this page. Click ok to close this dialog box. Review errors at the ...
0
votes
1answer
482 views

SQL Server 2008: Delete database while Rollback is in progress

I am trying to remove a test database in which a database modification failed. The resources being consumed by the rollback action in SQL are affecting production databases (users reporting slow ...
1
vote
1answer
306 views

Does the SQL Server 2008 Recovery Model and Log Size Impact Memory Usage for sqlservr.exe process?

Problem We have a SQL Server instance (2008) running our software with what we consider a small number of users (about 30 concurrent connected to the server at any given time) As a vendor, we're not ...
0
votes
1answer
107 views

SP with xp_cmdshell gives an error in the MessageQueue, but executes successfully in Management Studio

I have a SP, which calls xp_cmdshell in it. This SP is being used in a MessageQueue. The SQL server and Agent services are configured using a Domain service account, and this service account has a ...
0
votes
1answer
42 views

Transferring 3 SQL databases from both SQL Express 2005 and Standard to a new physical server

I am trying to figure out the best method for transferring SQL 2005 databases from 2 different physical servers to a new server running windows server 2008 64bit. I own a fully registered copy of ...
1
vote
1answer
134 views

Single row user security in MS SQL 2008 R2

I have a SQL Server 2008R2 question regarding making a single row in an odd way. situation: I have a student records database in which ~ 100 students might in-process in a given day. They enter a ...
-1
votes
1answer
183 views

Using multiple IPs on one machine for web and game server

We are looking to host a game server. The game we are going to be setting up a server for is subject to DDoS from other servers, players, etc. Many other server and administrators have pointed out ...