Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [sql-server-2005]

Microsoft's SQL Server is a relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases. This tag is for questions on the 2005 version

1072 questions
4
votes
5 answers

Justifying a memory upgrade

My employer has over a thousand servers (running SQL Server 2005 x64 and a couple of other apps) all across the country. And in my opinion they are all massively underpowered for what they need to do. Specifically, I feel that the servers simply do…
AngryHacker
  • 2,877
  • 6
  • 32
  • 33
4
votes
3 answers

Crossover cable in addition to normal network connection on servers?

I have 2 servers, both with Windows 2003 R2 Each have 2 NIC ports that are 10/100/1000 They are both connected to our LAN + joined to the domain (1 NIC port free on each server) The problem is that our main router is only 10/100 on the ports that…
Zero0ne
  • 137
  • 2
  • 6
4
votes
1 answer

How to configure/save layout of SQL Server's Log File Viewer?

When I'm viewing the job history of a particular SQL Agent Job, I typically want to see whether it succeeded, its duration and maybe the duration of the individual steps of the job. When I open the history in the Log File Viewer, I always need to…
Chris Burgess
  • 248
  • 1
  • 4
  • 11
4
votes
2 answers

Will this force a reinitialize in Merge Replication Topology?

I need to add a couple of columns to a table that is a part of a replication set. It is not a constraint coulumn or a part of any article filters and it allows NULL. I have a pretty good idea that I can run this --> ALTER TABLE tblPlanDomain ADD…
Refracted Paladin
  • 345
  • 7
  • 20
4
votes
2 answers

Running "Rebuild Index" maintenance plan with "Online indexing"

I am using Windows Server 2003 SP 2 and SQL Server 2005 Enterprise edition I am creating a "Rebuild Index" job for a particular database and I am successfully able to run the job. But when I try to enable the "Keep index online while rebuilding"…
bdhar
  • 195
  • 5
4
votes
1 answer

SQL 2005 Security - Users: What are they used for? (and other various questions)

I am not a DBA and so dont really know anything about SQL 2005 security settings, etc. I am attempting to set up an empty copy of our database by generating the full database from SQL Management Studio generated scripts. Unfortunately I don't know…
MrLane
  • 247
  • 1
  • 3
  • 9
4
votes
2 answers

How do I create a Linked Server in SQL Server 2005 to a password protected Access 95 database?

I need to create a linked server with SQL Server Management Studio 2005 to an Access 95 database, which happens to be password protected at the database level. User level security has not been implemented. I cannot convert the Access database to a…
Brad Knowles
  • 71
  • 1
  • 3
4
votes
1 answer

SQL Server Developer Edition versus SQL Server Standard

not sure I understand this but I am going to throw my assumption out there: SQL Server 2008 Standard & Enterprises editions are for running full database services on server (not just but for comparative sake), and SQL Server Developer Edition is…
Justin
  • 189
  • 1
  • 8
4
votes
1 answer

List of things to check before turning on SQL Server CLR?

I am trying to deploy a CLR function (which computes a hash of a text or a file, not available from SQL Server) for the first time on a production server. I was able to test the function on a development machine but I am still wondering, Are there…
dance2die
  • 2,011
  • 7
  • 32
  • 41
4
votes
1 answer

Why does Reporting Services fail to import an existing encryption key during a service account change?

I've changed the service account for SQL Server 2005 Reporting Services a number of times now, but yesterday was the first time I'd run into the dreaded 'The report server cannot decrypt the symmetric key used to access...' error. The environment is…
Tim Benninghoff
  • 51
  • 2
  • 4
4
votes
4 answers

DBCC CheckDB The operating system returned error 21(The device is not ready.)

The operating system returned error 21(The device is not ready.) to SQL Server during a read at offset 0x0000000001c000 in file 'E:\SQL Database\S*****d\NewAdvWorks.mdf'. Additional messages in the SQL Server error log and system event log may…
ManishKumar1980
3
votes
4 answers

Using linked servers to query across database servers?

We have multiple MSSQL 2005 servers that contain silos of information. We want our database developers to be able to join across these silos in the most transparent and performant way possible. The databases vary in size, but average in the tens…
Jeff Meatball Yang
  • 233
  • 2
  • 7
3
votes
6 answers

SQL Server 2005 Backup Failing

I have a database in full recovery model. This database's transaction log backups (scheduled via a Maintenance Plan) fail nightly. Here is the database's CREATE statement, etc: USE [master] GO /****** Object: Database [Gatekeeper] Script Date:…
andyhky
  • 2,732
  • 2
  • 25
  • 26
3
votes
1 answer

SQL 2005 won't fully uninstall

I am trying to uninstall my default instance of SQL Server 2005 from my Windows 7 machine but having a few problems. Everything uninstalls as it should using Add/Remove programs but for some reason I am still left with the SQL Server Reporting…
Cragly
  • 163
  • 3
3
votes
5 answers

How do I restore to a SQL backup I made two days ago?

Database disasters only happen to other people, right? RIGHT?!? I'm sure this has never happened to anyone since the beginning of computer history, but, believe it or not, I'm having a problem with a database restore. Perhaps you can help. I'm…
Jason
  • 247
  • 2
  • 9
1 2 3
…
71 72