Server Fault Stack Exchange
Server Fault 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.

SQL Server 2008 is Microsoft's version of SQL Server following SQL Server 2005. A list of the new features can be found here

1806 questions
0
votes
1 answer

Error when creating Publications

Here`s a screenshot of error I get when I try to create publication .... Here's a link! What should I do? edit So now I have problem that I cant delete distributor I created, any tips?
Nidzaaaa
  • 103
  • 4
0
votes
1 answer

Best practice for setting up SQL server on a Virtual Machine

This is my first attempt at virtualizing SQL server on VMWare and I want to make sure I am doing things correctly. Should I have SQL server installed on the C: drive / same partition as the OS, Then add a virtual disk for the Data files, say 300GB,…
CrazyCoderz
  • 113
  • 1
  • 5
0
votes
1 answer

Does the disk space used by this database seem normal (MSSQL 2008)?

The Disk Usage report is showing lots of unused transaction log space (seems normal, there are hourly log backups). However the data file is mostly indexes and there is very little unused space. Is this normal?
Marcus
  • 400
  • 2
  • 5
  • 16
0
votes
4 answers

SQL 2008 vs. SQL 2008 R2 - which to choose?

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 Microsoft. We have no special requirements, our SQL 2005…
boj
  • 121
  • 4
0
votes
1 answer

SQLOLEDB from sql2005 to sql2008?

Can I use the SQLOLEDB provider in an OPENROWSET query from sql2005 to sql2008??? SELECT * FROM OPENROWSET ('SQLOLEDB','[servername]';'login';'pw', 'set fmtonly off EXEC DB.dbo.SP 6,1,''B20121110'' ') Thanks
Jim
  • 1
0
votes
4 answers

SQL 2008 Replication over Internet

We have decided to put our servers in data centers on east and west coast of US, to keep high level redundancy. After evaluating number of replication options, apart from VPN there is no other way to do replication for SQL Server. We are…
Akash Kava
  • 467
  • 3
  • 8
  • 19
0
votes
1 answer

clustered windows service

I will have a clustered instance of SQL server over two nodes (active/passive) available in my deployed architecture. I want to deploy a windows service and have it also be active/passive on the two nodes. Is it is as simple as installing the…
user195166
  • 113
  • 1
0
votes
2 answers

In Amazon RDS, how can a disabled master user be re-enabled?

With a SQL Server instance on Amazon RDS it is possible to do the following to your master user: ALTER LOGIN masteruserid1 DISABLE GO If this command is executed while logged in as the that master user through SSMS, every other command will fail,…
ElHaix
  • 269
  • 3
  • 13
0
votes
1 answer

How to Deploy an ASP.NET Web API- and Browser-based Application to a Production Environment

Possible Duplicate: How to Deploy an ASP.NET Web API- and Browser-based Application to a Production Environment We have an ASP.NET Web API server that serves up a SQL Server data driven website. The API uses JSON to transfer data from SQL Server…
lmttag
  • 197
  • 1
  • 3
  • 8
0
votes
1 answer

SQL 2008 Datawarehouse Collection Agent Fails with Mirrored Databases on instance

I have a data collection job that fails when a Database on the instance is in Recovery Mode. The database in recovery is the MIRROR partner in the database mirror. The Job that fails is as follows. collection_set_1_noncached_collect_and_upload The…
Dale Wright
  • 91
  • 1
  • 3
0
votes
1 answer

What to do instead of shrinking your databases and how to fix issues caused by previously shrunk databases?

I'm a fairly new SQL Server DBA but come from a software engineering background. I've been reading on several blogs that shrinking a database on a regular basis is bad and I understand why. The issue I'm having is that a database maintenance plan…
user1777238
  • 1
0
votes
1 answer

Sql Server 2008 Create Foreign Key Manually

I have inherited an old database which wasn't designed very well. It is a Sql Server 2008 database which is missing quite a lot of Foreign Key relationships. Below shows two of the tables, and I am trying to manually create a FK relationship between…
tcode
  • 119
  • 4
0
votes
2 answers

Why do I only see the 'default' DB when linking an Oracle server in SQL Server 2008 Mgmt Studio?

When I add an Oracle server as a Linked Server in SQL Server 2008 Management Studio, I can only see a database named 'default', and none of the other DB's on the server. Using Microsoft OLD DB Provider for Oracle or Oracle Provider for OLE DB--same…
theog
  • 111
  • 3
0
votes
3 answers

2008 SQL Server, attach option does not show all the drive letters

I have a cluster DB, and i am trying to attach DB files, it doesn't let me navigate to any other drive except for DB? Is there something wrong that i am doing? Example, if my DB is created in F:\, i am allowed to attach only to mdf files from…
Nida Sahar
  • 103
  • 2
  • 5
0
votes
1 answer

SQL Server 2008 R2: starting SQL browser failed

During troubleshooting of the failed connection to sqldb in my testsystem I've tried to start sqlbrowser via command line. This results the following error message "failed starting SSRP redirection services -- shutting down". Does anybody have an…
msh
  • 221
  • 3
  • 5
  • 11
1 2 3
…
99 100