0
votes
1answer
246 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 ...
0
votes
0answers
26 views

Merge_Replication_Tables_Not_In_Sync

We've merge replication configured in our environment(1 Publisher, 3 Subscribers) and We know by default merge replication is bi-directional. Its working fine in case of inserts i.e, if a row is ...
3
votes
1answer
140 views

Are SQL Collations per Instance or per Database?

I have a single SQL Instance, let's say MSSQLSRV - is the collation per Instance, i.e. every database in the given instance has the same collation, or are collations set per database? i.e. multiple ...
0
votes
1answer
63 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 ...
0
votes
0answers
268 views

SQL Server 2008r2 SP2 Manual Install Error

I am receiving an error I have never seen before, nor can I find any info on the net. When I try to install SP2 for SQL Server 2008r2 I receive the following error. Cannot find the value of the ...
0
votes
0answers
31 views

Instant File Initialization Turned on but file grows slower in sql server 2008r2

What are the reasons a data file (8 GB) could take a long time to grow even if Instant file initialization is turned on in sql server 2008r2? The sql service account has admin access to "Perform ...
0
votes
1answer
159 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
1answer
362 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 ...
0
votes
4answers
72 views

SQL 2008 vs. SQL 2008 R2 - which to choose? [closed]

We should change our SQL 2005 Server to SQL 2008. My bet was 2008 R2 SP1 but in this week we had several problems with it (related to CU7 and CU8) and as far I see, R2 has bugs - confirmed by ...
1
vote
1answer
118 views

Will more memory help my CPU-peaking SQL Server 2008 R2

I'm supporting a system running against a SQL Server 2008 R2. The server is a single-CPU box with 8 GB of memory. As traffic has increased, the server has started saturating, peaking to 100% CPU ever ...
0
votes
1answer
448 views

Error in install sql server 2008 rn

When running the SQL Server 2008 setup, I receive the following error message: TITLE: Microsoft SQL Server 2008 R2 Setup The following error has occurred: Unable to open Windows Installer file ...
4
votes
2answers
2k views

Can I restore a SQL Server 2008 R2 backup to SQL Server 2008 R2 Express?

I have a server that's currently running SQL Server 2005 Express, and I need to restore a database backup that a developer has modified using SQL Server 2008 R2 [I think the full version, but still ...
1
vote
3answers
544 views

SQL Server returning empty result sets (to busy?)

My apologies from the start, I don't have much information to go on and I am just looking for some help debugging my issue. I have 5 sites running on a Windows Server Web Edition 2008 with SQL Server ...
0
votes
1answer
626 views

Enable remote access to SQL Server 2008

I've just built a virtual SQL Server 2 node cluster using VMWare workstation. The windows cluster has been created, SQL has been installed on both nodes and added to the cluster, all latest updates ...
0
votes
1answer
113 views

Can a network failure cause a user to be removed from SQL as an authorized user?

We are trying to get to the bottom of our issue. We have a service that connects as MyDomain\ServiceAdmin to a SQL 2008 database. I believe we have just setup database mirroring too in case the ...
2
votes
1answer
203 views

Electricity gone off while shrinking database, how can I recover my database?

While executing a shrink on a 25GB database, the electricity has gone down, and I can't access my database. It shows as "In Recovery". How can I recover it?
1
vote
2answers
132 views

Transaction log backups

I'm studying for the 70-432 (SQL Server 2008) exam, and I'm a bit confused about how the transaction log works. From what I understand, (correct me if I'm wrong...) the log is actively stored in ...
3
votes
2answers
481 views

How to change max server memory in SQL Server

I was trying to change the max server memory for my database server, and I accidentally saved it as "4" instead of the number I wanted to enter. Now I can't even connect to the server. Is there a ...
0
votes
1answer
1k views

Can I downgrade SQL Server 2008 R2 Standard To Web Edition?

We are running a SQL Server 2008 R2 Standard Evaluation version. The client has decided they don't want to pay for full SQL Server standard and feel the Web edition is suitable. Can I downgrade SQL ...
0
votes
2answers
164 views

what is a good frequency for setting up snapshot replication in sql server 2008

My requirements: I have a publisher database from which I intend to replicate to a subscriber. Not all tables need to be replicated. Amount of data could be ~20-30GB. Given the above: is ...
0
votes
1answer
2k views

SQL Server 2008 service pack installation error

When I am trying to install the SQL Server 2008 service pack I am getting the error as: There are no SQL Server instances or shared features that can be updated on this computer, and The version ...
4
votes
2answers
893 views

MS SQL access to restored database without sysadmin role

I have databases from different projects on one server. I can't give all developers administrative (sysadmin) access to the databases. They have to have the permissions needed to create and restore ...
2
votes
1answer
347 views

SQL Server Reporting Services subscription creation silently fails. No error message is displayed, but the subscription does not get created

I'm trying to set up a subscription for a SSRS report. I have deployed the report to the server and I can view the report in a web browser with no problems. I have tried to reproduce this issue on ...
0
votes
2answers
408 views

SQL Server 2008 Web edition - access from another IIS?

We are planning to purchase and install SQL Server 2008 R2 Web edition for our live servers. The grand plan was to install a shiny new server with this SQL Server (web edition), and change the ...
1
vote
2answers
437 views

Upgrade sql server 2008 to 2008 R2, in-place upgrade or new install

When upgrading we normally create a new install and migrate databases over, but we are going to test out in-place upgrade from sql server 2008 to sql server 2008 r2 (standard) in our development ...
0
votes
1answer
135 views

SQL Server 2008 R2 and copy-only default value in SQL Server Management Studio

We are using Tivoli Storage Manager for taking backups of the database but sometimes our consultants need to take separate backup copies of the database using Management Studio. If they forget to mark ...
1
vote
1answer
2k views

sql server cluster - “the given network name is unusable” error in creation wizard

I'm trying to create a sql server 2008 R2 cluster. I've got two windows machines running server 2008 that are clustered and have all passed the validation tests etc. I'm now going through the ...
4
votes
1answer
7k views

Difference between “SQL server 2008 standard” and “SQL server 2008 standard for small business”?

There seems to be a big difference in price for these licenses, but after a lot of googling I can't find any info on how the two compare. The blurb for the "small business" version is: "This edition ...
2
votes
1answer
413 views

Can I log ship from SQL Server 2008 R2 to Sql Server 2008 “R1”?

I have two sql server instances, on is SQL Server 2008 R2, one is the first release of SQL Server 2008 ("R1"), is it possible to log ship from the R2 machine to the R1 machine? If is not possible, is ...
0
votes
1answer
168 views

MS-SQL Server 2008 size limitation on data

I recently discovered that MS-SQL Server 2008 imposes an upper limit of 8000 bytes for a column (for character data). I need to store data that occusionally could surpass this limit. Is there a way to ...
0
votes
2answers
243 views

SQL Server 2008 login failed

I have a virtual machine (vmware) with Windows Server 2008 R2 x64 and SQL Server 2008 R2 installed. I see 2 SQL Server services on this vm : sqlexpress, mssqlserver. Both of them are use the default ...
2
votes
1answer
195 views

Creating a small .bak file without indexes or excessive log

I recently was asked to ship a .bak file of our database to a client, and through reindexing all tables with a 100% fill factor (to make sure there were no empty slots), and resizing the transaction ...
0
votes
2answers
510 views

what type of replication transaction should I use?

I can't understand the difference between transactional replication and merge replication. This is my scenario: In an organization I have a SQL server which need to collect information from different ...
0
votes
2answers
2k views

Non-SA role restoring database?

If I'm reading Books Online correctly, a user can restore an existing database if they're the DBO of that database; the actual words are: If the database being restored does not exist, the user ...
2
votes
2answers
99 views

Backwards-compatible (to SQL 2000) server version and compatibility version check

I have a script which uses features not present in SQL Server 2000. Specifically, the script creates a stored procedure which uses a data type added in SQL Server 2005. I need to use conditional ...
0
votes
1answer
73 views

How to configure SSL on an instance of SQL Server to allow dedicated users to remotely access it?

I have configured the instance of SQL Server to allow dedicated users to access it remotely. Connection string Data Source = 192.168.1.2,1433\sqlexpress;etc... has been tested and works. However, I ...
3
votes
2answers
69 views

Can I create SQL v10.0 databases in SQL R2 server?

Is there a way to create non-R2 databases in an R2 database server? I was hoping to do this in the compatibility options during the database creation, but only options are available for 2005 and 2000. ...
0
votes
1answer
254 views

Supertype question from a mega noob

I've tried a couple database creation tools (MS SQL Server, MySQL Workbench, etc.) and I cannot figure out how to create a super-type relation (complete, disjoint). Below is an example of how it looks ...
0
votes
2answers
186 views

setting MAXDOP server default value

Hi I've a server with 2 physical processors with 8 cores each. Looking through Management Studio Shows me a tree with NUMA 0 and NUMA 1 and inside 8 childs. The current maxdop is on 0, should I set ...
1
vote
3answers
100 views

To get Sql Server 2008 r2 installed, do I just install Sql Server 2008 and then use windows update?

I have been told I need to install Sql Server 2008 r2 on my development PC, do I just install Sql Server 2008 and then let windows update install r2 – e.g. is it like any other service pack?
0
votes
2answers
1k 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
841 views

Can you upgrade SQL Server 2008 SP2 Standard Edition to 2008 R2 Developer Edition?

We have a development server that was initially setup with SQL Server 2008 SP2 Standard Edition. Is it possible to upgrade that edition to 2008 R2 Developer Edition so we can play with the extra ...
3
votes
4answers
1k views

Log Shipping to an Existing Database

We have a few huge databases we would like to log ship on SQL Server 2008. Unfortunately the link between primary and secondary servers is fast enough to handle log shipping but the initial ...
3
votes
3answers
4k views

Does SQL Server 2008 R2 lock memory pages by default?

Does anyone know if the locked pages of SQL 2008 ENT R2 x64 operates as ON as default (I assume it does as my SQL memory usage does not show up in task manager) on Server 2008 R2 x64. And if so, ...
1
vote
1answer
2k views

what does R2 stands for in SQL Server 2008 R2?

What does R2 stand for in SQL Server 2008 R2? Is it Revision 2 or Release 2? Is it an another version with additional features?
0
votes
1answer
8k views

Installing SQL Server 2008 R2 32bit on 64bit : WoW64 error

It looks like it's possible for 2008 SP1: previous question. But what about current newer 2008 R2 version? We plan to use single 32bit Express edition package to install on every machine. However, ...
0
votes
1answer
814 views

Programmatically Copy Database like SQL Server 2008 Copy Database Wizard

I need the ability to copy a database similar to what the Copy Database wizard accomplishes in SQL Server, but in a more automated (i.e. command line) fashion. I am writing a small application in C# ...
1
vote
3answers
4k views

“RESTORE HEADERONLY is terminating abnormally” error when restoring backup

When I try to restore a database backup file, I get the following error: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ...
6
votes
6answers
26k views

Can't connect to SQL Server 2008R2 on Windows Server 2008R2

I reinstall a server Windows Server 2008 R2, I installed SQL Server 2008 R2 no problem during installation. When I try to connect with "Microsoft SQL Management Studio" via sa account or Windows ...
6
votes
7answers
12k 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 ...