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
0
votes
1
answer
2k
views
Backing up database fully from remote server, and restoring to another remote server
I currently have three copies of my website (Live, Staging, and Development), with the database for each on three separate servers. More often not, a bug will appear that requires an up-to-date ...
- 123
0
votes
3
answers
371
views
SQL Instances and Servers
I have two installations of SQL on two seperate boxes (I have "Inherited" these).
A SQL 2005 Installation, with instance called SQL2005 - I connect to this via SQL Studio Manager and when I connect ...
- 1,684
2
votes
2
answers
108
views
Migrating to the Cloud: Private or Public [closed]
This is a matter of opinion but I'm looking for some advice regarding an upcoming migration of physical servers to the cloud. I'm looking for some perspective - any opinions are welcome.
Scenario: ...
- 170
1
vote
1
answer
146
views
sql server 2008 express, how login as admin
I am pretty newbie on sqlserver.
I just want to logon by Management Studio on a sqlserver just for backup a db.
But it seems that I haven't enough permissions because I am guest.
Anyone could explain ...
- 311
0
votes
1
answer
1k
views
Not able to connect to the MS SQL server
Am getting error as show below. It was working fine with no issues but recently started taking long time in query execution and connection:
Cannot connect to <serverName>.
====================...
- 1
0
votes
1
answer
126
views
Need to DROP TABLE from 100s of SQL backup files
I have MS SQL Server 2008 available to me. Is it possible to script (perhaps with Powershell?) the processing of all my backup files to drop a table (or two) from each one? I used 7-Zip on the command ...
- 979
-2
votes
2
answers
151
views
Is it Safe to Install SQL Server 2012 on a machine which have SQL Server 2008 R2 running?
I am using SQL Server 2008 R2 quite a while. It is working great. Now I need to use SQL Server 2012. Will this effect my existing database. How much Risk involved in installing SQL Server 2012 on a ...
1
vote
1
answer
6k
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. ...
- 978
1
vote
1
answer
4k
views
How to change the product key of SQL server 2008 R2
I am currently using SQL server 2008 R2 Standard edition in a Cluster. During the initial installation I used the product key which was automatically bonded with the setup DVD. Now I have a need to ...
- 11
1
vote
2
answers
131
views
How to see what is cached in memory in SQL server 2008?
Is there a way how to find out what is cached in SQL Server 2008 R2? I have found the following nice article here:
http://blog.sqlauthority.com/2010/06/17/sql-server-data-pages-in-buffer-pool-data-...
- 111
0
votes
0
answers
64
views
I must have done something wrong installing sample database
I downloaded file SQLEXPRADV_x86_ENU.exe (version 10.00.1600.22), and used it to install SQL Server 2008 Express with Advanced Services, which I think has capabilities comparable to SQL Server 2008 ...
0
votes
3
answers
5k
views
Increasing vCPUs for Server 2003?
I have a VM running Server 2003 and SQL Server 2008 on VMware ESXi. Can I safely assume this configuration can cope with a change to the number of vCPUs? Are there better solutions to address the ...
- 123
8
votes
3
answers
52k
views
SQL Server 2012 with account NT Service\MSSQLSERVER access is denied in domain
A few months ago we installed SQL Server 2012 in Windows 2008 R2 under the virtual account "NT Service\MSSQLSERVER", all good.
A few days ago, one of the admins of the IT dept installed Full Text ...
- 183
0
votes
0
answers
804
views
Identical tables, different sizes?
I have transactional replication with updatable subscriptions going between a few SQL 2008 R2 servers (publisher is Enterprise, subscribers are Express).
I need to add another subscriber, and come to ...
- 1
6
votes
4
answers
68k
views
How do I install SQL Svr Native Client 10.1 after SQL 2012 has been installed
On a Windows Server 2012 I have SQL Server 2012 installed which has the SQL Server Native Client version 11. I am being told by a developer that he needs the SQL Server Native Client version 10.1 (...
- 123
0
votes
1
answer
79
views
How to allow a SQL Login to see only ONE database
i have a SQL Server server 2008 r2. I wish to create a two new Login for a client who wishes to have access to their one database. But I don't want to give them access to the other my databases.
...
- 1
1
vote
0
answers
71
views
Failover cluster wouldn't fail over
I have an active-passive failover cluster on 2008r2 with SQL server 2008 clustered on it.
I go to fail it over for maintenance and the resource failed to come online on either node. Once I rebooted ...
- 163
0
votes
3
answers
147
views
How to connect to ms sql express?
I have sql express on my local network computer, I created new account, I enabled server auth, and when I am trying to connect to this account from local machine, everything works fine. But when I try ...
- 127
0
votes
0
answers
103
views
SQL failover cluster on single ESXi host
I'm setting up a virtual environment consisting of 10 VM's with 2 primary SQL databases required. The infrastructure allocates two pairs of SQL 2008 R2 Enterprise edition (VM's). The pairs are ...
- 105
1
vote
2
answers
3k
views
In sql-server, how do I give server-level permission to user to make backups on any database
I need to give a user server-level permissions, once and for all time, to back-up any existing or future database on the server instance, without making the user sysadmin. How can I do that?
I've ...
- 111
0
votes
1
answer
167
views
Restore backup from SQL 2008 to 2008R2 with standby
We are looking to replicate our production database to another instance so that when reports are run, it doesn't slow down the application to the point of being barely usable. I had limited success ...
- 703
1
vote
2
answers
29
views
Exploring / editing SQL Server data of a runtime installation
I installed some software which has built into its installer a sort of minimal installation of SQL Server 2008 R2 Express. The software itself uses the database just fine, but I want somehow to be ...
- 539
-1
votes
1
answer
1k
views
SQL server ODBC connection for Active Directory user who doesn't log in to the windows
Do you think it is possible to create a SQL server ODBC Connection for an active directory user who doesn't log in into the windows.
Ideally this type of users will be used in the batch process. So, ...
- 101
0
votes
0
answers
252
views
Download SQL 2008 R2 and install remotely with key
I have the media and product key for a copy of SQL Server 2008R2, however, I can not get my CD to the server at my data center. Is there a downloadable version (or can the trial be downloaded) of the ...
- 311
3
votes
1
answer
10k
views
How To Tell If a MSSQL 2008 Database Has Transparent Data Encryption (TDE) Enabled
Does anyone happen to know if there is a way via WMI to tell whether a MSSQL 2008 database has TDE enabled? We have a large SQL estate that I'd like to survey and find out where we have TDE enabled. ...
- 161
1
vote
1
answer
1k
views
My php site cannot connect to SQL Database - SqlExpress2012
Im quite new to SQL Express 2012, but have just installed it on my server 2008 r2.
Im trying to install a CMS called joomla, which I' ve done many times before both on SQL community server and hosted ...
- 11
1
vote
1
answer
1k
views
MS SQL 2008 - Can I use Windows Authentication to connect from a Mac
I have been using Navicat SQL on Mac (Snow Leopard) to connect to MS 2005 via "Basic Auth" and all is good.
However the DB is now being migrated to MS 2008 and try as I might I cant get on via Windows ...
- 11
0
votes
1
answer
3k
views
Cannot Connect to SQL Server 2008 R2 from Sharepoint Server
I have installed SQL Server 2008 R2 on dbserver and Sharepoint 2010 on webserver. When trying to configure Sharepoint to use the database installed on dbserver, it says it cannot connect. Then I ...
- 1
0
votes
1
answer
445
views
SQL 2008 R2 Clustering AND DB Mirroring (Async)
I've got a MS SQL 2008 R2 Fail-Over Clustered Instance running between two Windows 2008 R2 servers using the inbuilt Windows Clustering features, that is working with a DTC and Quorum with a disk ...
- 113
5
votes
1
answer
141
views
32-bit SQL eating up RAM on 64-bit OS until SQL is brought to its knees
This may be related to other threads I've seen, but I need a solution to this specific situation. The SQL instance continuously consumes more and more RAM until after about a week it's grabbed over 3....
- 51
0
votes
1
answer
1k
views
Can I move all DB files on SQL server 2008 to a different logical drive and then change the drive letter?
I've got a SQL Server 2008 (std) with 19 DBs. Because I'm replacing my SAN, I need to move all the DB files to a different volume. I've moved individual DBs before using MS's recommended method: ...
- 669
0
votes
1
answer
149
views
How to best move system DBs from SQL 2005 to SQL 2008 R2?
I'm in the process of moving from SQL 2005 to SQL 2008 R2. Moving the production DBs and logs is straightforward, through either detach/attach or backup/restore. (new hardware, so I have the old ...
- 150
3
votes
0
answers
4k
views
SSMS stuck scripting database objects
SQL Server Management Studio sits stuck, after scripting all objects in a database. Except it didn't script all objects in a database.
i scripted all the objects in an SQL Server 2008 database from ...
- 5,373
0
votes
1
answer
40
views
MS SQL - syncronising "a view" to another MS SQL server
Let me open by saying that I am no MSSQL expert. I'm a linux admin, so please forgive me if I should know this.
I've been asked to syncronise a view or a table from one MSSQL database to another. I'...
- 1,188
0
votes
1
answer
399
views
SQL Server reliance on Domain Controller
Just have had an interesting situation with a remote database server which I did not think happened.
The setup is server A is a domain controller in the main network, and server B is on a remote ...
- 103
0
votes
1
answer
64
views
How to un-install sql server 2008 analysis service only?
Initally I installed SQL server 2008 R2 Evaluation version. Then we bought licence key for SQL server 2008 R2 Web and wanted to update my licence, but unfortunately I installed analysis service when I ...
-1
votes
1
answer
107
views
MS SQL Express - Memory limitation vs. web application [duplicate]
I have web application that will be similar to forums. I plan to have few thousands+ users on this application, and i wonder if i can use MS SQL Express - here is the list of it's limitations:
...
- 127
1
vote
1
answer
1k
views
Trouble Publishing an MVC4 site on HostGator
I have been working on a C# MVC4 website and trying to publish it to a Host Gator shared Windows hosting account. They are running both MSSQL 2008 and mySql. We have run into some trouble when trying ...
- 169
0
votes
1
answer
268
views
opening firewall 1433 port to IP address that require a direct connection
We are upgrading from sql server 2005 to sql server 2008 and windows server 2008 R2.
New server is behind a firewall, we have 30 or so windows XP machines, that will require the port 1433 to be ...
0
votes
1
answer
356
views
DateTime of data file autogrowth in sql server
How to determine the datetime of the last auto file growth of a data file in sql server 2008, if I dont have a trace file at the time of autogrowth. One of the online posts mentioned that the "...
1
vote
1
answer
3k
views
SQL Server 2008: Large transaction log file in Simple Recovery Mode
I am having a problem with disk space in SQL Server 2008.
This is the situation:
- I had a DB set with Simple Recovery and this DB used to use 2-3 GB for the transaction log file
- I moved this DB to ...
- 33
1
vote
1
answer
61
views
Installing MS SQL Server 2008 R2 Utilizing Data Array
Maybe I can't put together a query that finds what I am looking for on the Internet, but I want to make sure this is done right.
I have a new server that has Windows Server 2008 R2 loaded onto a RAID ...
- 195
0
votes
1
answer
478
views
SQL Server 2008 intermitent error 40 running parallel queries
Here's our setup :
We are using Red Gate SQL Multi-Script to run queries on our ~1000 databases which reside on a single SQL Server 2008. SQL Multi Script can be configured to run queries in ...
- 237
0
votes
1
answer
533
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 ...
- 1,312
3
votes
1
answer
2k
views
Missing MSSQL10.SQLEXPRESS folder
I seem to be missing my
C:\Program Files\Microsoft Sql SERVER\MSSQL10.SQLEXPRESS
folder. I have reinstalled SQL Server 2008 and Visual Studio 2010 but still do not have it.
Any ideas?
- 33
25
votes
4
answers
247k
views
Install SQL CLR types & Report Viewer 2012 on Sql 2008 server
I'm in the process of installing a client's ASP.net site on a Windows Server 2003 box running Sql 2008.
The site uses Report Viewer 2012, but when I attempted to install it on the server, I got the ...
- 353
0
votes
1
answer
40
views
Backing PDF files and SQL server DB
I have my own Windows Server an Asp.Net application hosted live. The application allows users to upload CV PDF files and I have the DB also on that server. Which steps should I take to ensure that all ...
- 681
0
votes
1
answer
342
views
HA Options for Windows Servers
We are looking at different options to allow us to stay up and running when our primary datacenter (DC1) goes down for any reason. What is the main difference in having a offsite server updated all ...
- 259
1
vote
1
answer
1k
views
Error upgrading from SQL Server 2008 to SQL Server 2008 R2
I needed to restore a database (created in SQL Server 2008 R2 - version 10.50.1600) to a new DB in Server 2008 (version - 10.00.2531). I got the error - Restore failed for Server ....
Additional info
...
- 145
0
votes
2
answers
8k
views
Server failed, can I retrieve my database from the my hard disk?
I have an old server running Windows Server 2003 R2. Windows got corrupted due to an improper shutdown. I attempted to repair the Windows installation, but it made things worse (it gets to the desktop,...
- 125