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
4 answers

How to check if a server runs in pressing mode

Layout: i have at customer side a server (win2003 R2 SP2 standard edition 32-bit) with a sql-server 2005 and some databases. This system starts with the /3GB-Switch. The system reports 3.25 GB RAM and taskmanager reports the process of…
Ice
  • 404
  • 1
  • 7
  • 16
0
votes
1 answer

How do you enable Trace Rollover for audit traces on SQL Server 2005?

I need to find out if Trace Rollover is enabled on my SQL Server 2005 machine. Where can I find this out and turn it on if I need to?
wahle509
  • 333
  • 1
  • 2
  • 8
0
votes
1 answer

SQL Server; how to import data from another DB with different collation; conversion errors?

I have 2 databases setup on a server. I want to import data from DB1 to DB2, using the SSIS wizard (right click DB > Tasks > Import Data) DB1 is the source DB, it has a collation set to Cyrillic_General_CI_AS DB2 is the destiantion DB, it has a…
user155695
  • 290
  • 3
  • 5
  • 14
0
votes
1 answer

Adding .mdf and .ldf of an existing database by renaming them in SQL server 2005?

I am trying to attach .mdf and .ldf file of an existing database with some change and different name.When i am attaching them , sql server automatically converting them to their original names(existing data base name) and giving out an error .
None
0
votes
0 answers

MSSQL server hacked by ANONYMOUS LOGON

My server was hacked with the Mirai Botnet, we cleaned the system, Disabled the Server Agent completely and the system is stable and clean BUT... If I re-open that sql server PC to the internet ( port 1433 ), it gets reinfected.. I experimented with…
Omarico7
  • 1
  • 1
0
votes
1 answer

SQL Server Express Uninstall / Enterprise Install Issue

I need help installing SQL Server 2005 Enterprise edition.I really need to remove the current SQL Server 2005.installation that is no longer on my Add/Remove software list but yet still installed on the machine. I tried to uninstall SQL Server…
user19049
  • 487
  • 2
  • 13
  • 25
0
votes
2 answers

SQL Server 2005 can't increase log file size

I have a small SQL Server 2005 DB (one data partition 21MB, one log file 10MB initial size). Users are getting an error that the log file is full. Upon checking, it is full and currently 10MB even though it's set to auto-grow in 10% increments…
Eric J.
  • 752
  • 2
  • 14
  • 27
-1
votes
1 answer

Weird TPS peaks on SQL 2005 replicated database

When monitoring the Transactions/Sec using perfmon on one of my SQL2005 replicated databases - I'm seeing the TPS increase to 1000 and then immediately drop back down again - this happens every 5 seconds. I'm not sure what's causing this - is this…
SuperCoolMoss
  • 1,252
  • 11
  • 20
-1
votes
1 answer

SQL Server Express 2005 cannot accept connection (but ODBC working from external and local server)

I'm having a problem with SQL Server Express 2005 edition; it's unable to be contacted from an application (3rd party monitoring utility software). I have perform the following tests, all of which succeeded: Ping and DNS resolve test from internal…
Senior Systems Engineer
  • 1,155
  • 2
  • 27
  • 55
-1
votes
1 answer

Sql Server Transaction Log Backup Fails

I have a SQL Server 2008 Standard version. Mirroring is set up on the server in full safety mode. It has been working fine till today. The transaction log back-up fails every-time with an error Error: 2014-09-25 08:34:33.17 Code: 0xC002F210 Source:…
kishore
  • 852
  • 3
  • 13
  • 27
-1
votes
1 answer

MS SQL Express is not enough - whats to do?

I now have my first bigger project of my own. I invested around 500 working hours and the project is done. It's actual ASP.Net with C# and Linq to SQL, the platform is an MS SQL Server 2005 Express edition on a Windows server 2008 Web edition -…
PassionateDeveloper
  • 183
  • 9
-1
votes
1 answer

How to modify an existing back up database task

I am trying to modify and existing sql server 2005 maintenance plan. It's currently set to run a full backup that will expire in 3 days. It is also set to append existing under if files exists. I want to set it to overwrite if files exist however…
Jim B
  • 23,938
  • 4
  • 35
  • 58
-1
votes
1 answer

How to configure a trusted connection between IIS 7 and SQL Server 2005?

How do configure a trusted connection between IIS 7 and SQL Server 2005? My webapp was working fine with Windows Authentication enabled in IIS. Now, in order to solve a problem, we need to use a trusted connection. Unfortunately, enabling the…
user1180652
  • 101
  • 1
  • 2
-1
votes
1 answer

SQL Server 2005 SP4 & VS 2005

We have SQL Server 2005 SP1 currently and VS 2005. We're planning on installing SP4 for Sql Server 2005. Question: Are there any specific requirements for this install or known negative effects that we should know about? Thank you.
Rivka
  • 353
  • 2
  • 3
  • 12
-1
votes
2 answers

SQL Server 2005: Corrupt database - Automatically shutdown DB?

Lately I experienced a corrupt DB because of a defective harddisk. SQL Server 2005 detected the issue and put entries into Windows event log about inconsistent DB and invalid page checksums. But it just tried to deal with it. It kept on making daily…
Krumelur
  • 109
  • 3
1 2 3
…
71
72