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
0
votes
2 answers

Who Added a SQL 2005 Login?

I'm in the uncomfortable position of finding out one of my users has a db.owner level user account they are using. We had previously taken away rights, but a whole new account was created to get around that. A member of the IT staff has recently…
David Crowell
  • 183
  • 4
0
votes
1 answer

Advantages of multiple SQL Server files with a single RAID array

Originally posted on stack overflow, but re-worded. Imagine the scenario : For a database I have RAID arrays R: (MDF) T: (transaction log) and of course shared transparent usage of X: (tempDB). I've been reading around and get the impression that if…
GilesDMiddleton
  • 385
  • 3
  • 9
0
votes
2 answers

como se que esta funcionando AWE?

Tengo un servidor con 8GB de RAM de 32 bits, instale windows server 2003 enterprise y sql server 2005 enterprise, el Sistema Operativo reconoce los 8GB, pero el Sql Server solo usaba 1.6 GB de memoria, entonces agregue al boot.ini el parametro /PAE…
adan851018
  • 3
  • 1
0
votes
3 answers

SSRS 2005 inaccessible after install

Hi I've just installed Full SQL 2005, however after I've configured Reporting Services I can't seem to access it. When I go to http://localhost/reports I get this prompt for a username and password and no mather what I put there it fails with 401.1…
Gabriel Guimarães
  • 405
  • 5
  • 18
0
votes
3 answers

Migrate data from SQL 2005 (hosted) to SQL 2008 (in-house server)

We have a databased hosted with a "commodity" SQL hosting company. It's currently hosted on a SQL 2005 server. We have just configured a dedicated server (to which we have "root" access) running SQL 2008. Unfortunately, getting a backup file of…
orbistechnology
  • 15
  • 4
0
votes
2 answers

Problem on starting SQL Server “FCB::Open: Operating system error 3”

i have installed SQL SERVER 2005 sp3 and when i try to start it, i get the following error from sql server ErrorLog： 2010-12-12 01:05:54.40 Server Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86) Nov 24 2008 13:01:59 Copyright (c)…
user539029
0
votes
1 answer

SQL Server encryption/decryption

As part of disaster recovery testing I am trying to ensure that I am able to recreate my DB and still be able to decrypt previously encrypted strings. So here is what I am doing as a test... Creating a database certificate. Backing up the…
pmcilreavy
  • 103
  • 3
0
votes
2 answers

SQL Perfmon Trace: Wait for the Worker

I am trying to track down a sql issue with timeouts and am by no means a DBA, but i'm stuck with the job so i'll get it done. I've been running a trace on just about everything i can think of related to IO and network connectivity. The only number…
Zypher
  • 37,405
  • 5
  • 53
  • 95
0
votes
2 answers

MS SQL 2005, automatically kill processes

we are running a program which creates 4-5 processes on our MS SQL Server per instance. When the number of processes surpasses 230 the program stops working and crashes every few minutes(The sql server logs say "All schedulers on node0 appear to be…
DaVinci
  • 101
  • 1
0
votes
2 answers

Can't connect to SQL Server 2005 x64 SP 4 on Windows 7 x64

I have an issue with connecting to SQL Server 2005 x64 SP 4 on Windows 7 x64 with Visual Studio 2008 DataBase edition. I always receives message about error 26 and named pipes provider. It is irrational because I have disabled firewall, enabled…
truthseeker
  • 157
  • 2
  • 7
0
votes
1 answer

Potential Buffer I/O issues

I have a database that is constantly slowing to a crawl. The hardware for it is more than enough so I'm confident that's not the issue. When looking at resource waits through activity monitor, Buffer I/O is the highest by far. It's in the hundreds…
Shane
  • 1,869
  • 4
  • 20
  • 34
0
votes
1 answer

Why did my newly added index show up as a 'statistic'?

We are attempting to tune our SQL Server 2005 database as we frankly have no indexing on our tables and our CPU usage is starting to max out at 100%. We have ran SQL Server profiler for a 3 hour period which covers the time we recieve the most usage…
Neil Trodden
  • 262
  • 5
  • 14
0
votes
1 answer

What is the correct way to backup, move and restore a database that uses Service Broker?

I'm currently developing an application which uses SqlDependency which relies on the Service Broker. I'm running into an issue every time I move the database from development to staging in that I'm getting a YSOD stating that The SQL Server…
Greg B
  • 1,598
  • 5
  • 17
  • 32
0
votes
2 answers

How to remotely administer SQL Server 2005?

I have administrative RDP access to a server (call it ServerA) that has access to a SQL Server 2005 service (on ServerB). I do not have RDP access to ServerB, but would like to be able to use SQL Management Studio to browse the SQL Server…
Gabe
  • 133
  • 6
0
votes
2 answers

Steps in restoring database back up on SQL server 2005 and configuring database

I just want to know the steps on how to restore our SQL server 2005 in case its fail. I perform a backup of our database on our SQL server 2005 using SQL server management studio. My concern is if the computer crashes what are the steps to restore…
user64100
  • 1
1 2 3
…
71 72