Questions tagged [sql-server-2008]
A version of Microsoft's database server, released in August 2008. This is different than SQL Server 2008R2.
1,806
questions
2
votes
1
answer
4k
views
SQL Database restore to different edition?
I have SQL server 2008 R2 standard in house server and want to move my database to SQL 2019 Web edition in VM in AWS cloud. Can I just backup database and restore it there? would that work? or ...
0
votes
1
answer
283
views
?Does SQL Server 2016/2019 Web Edition supports encryption
I trying to find out if SQL Server 2016 and 2019 Web Edition
supports encryption (on AWS)?
any help will be appreciated.
Thank you,
Moshe
0
votes
1
answer
215
views
Connecting to SQL Server 2008 R2 over Azure VPN
2 Windows Server 2012 VM's on MS Azure and access is via RDP over Azure Point to Site VPN using a client certificate.
I can connect to the VM's fine but I need to connect to SQL Server 2008 R2 which ...
0
votes
0
answers
692
views
SQL Server Username Length
I have a SQL Server 2008 running on Windows Server 2008. The database handles spatial data.
I have a select group of users that are unable to use their domain accounts when working in the database as ...
0
votes
2
answers
430
views
How to scrub or clean out company data before selling server
I'm looking to sell a used Dell Poweredge T310 server (Specs at the end) with Server 2008 Standard SP2 and MS SQL Server 2008 R2 on it. I'd like to sell the server as-is, with the OS and installed ...
0
votes
0
answers
611
views
Cant connect to SQL Server 2008 from Window XP SP2 But work fine with SP3 and 7 and above?
Yesterday our windows server 2008 R2 Updated after 7 years!
After that our Windows XP SP2 and Lower clients reported that the ERP software cant connect to server!
But Windows 7 and above clients ...
0
votes
2
answers
1k
views
How can I add the server name to the subject line of a SSIS subscription email?
How can I add the server name to the subject line of a SSIS subscription email?
In Microsoft SQL Server Integration Services (SSIS) RDL report files uploaded are often set with the ability to send ...
1
vote
0
answers
64
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 ...
-1
votes
1
answer
98
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
1
answer
686
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 ...
-2
votes
1
answer
8k
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
0
answers
111
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
1
answer
8k
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 ...
17
votes
2
answers
57k
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
1
answer
401
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
2
answers
6k
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
2
answers
111
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
1
answer
2k
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
1
answer
124
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
1
answer
438
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
1
answer
3k
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
1
answer
79
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
1
answer
54
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
1
answer
58
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
1
answer
379
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
1
answer
394
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
1
answer
559
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
1
answer
2k
views
How to change interface language of sql server 2008? [closed]
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
1
answer
143
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
1
answer
44
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
1
answer
85
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
1
answer
35
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
1
answer
3k
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
0
answers
132
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
0
answers
233
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
1
answer
109
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
1
answer
404
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
2
answers
6k
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
1
answer
31
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
1
answer
217
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
1
answer
798
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
1
answer
70
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
2
answers
108
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
0
answers
268
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
1
answer
77
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
1
answer
1k
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
1
answer
227
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
1
answer
910
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
1
answer
376
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
1
answer
207
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 ...