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

Lower the I/O priority for backups

I have a job that nightly runs a backup of all attached databases however it can bog the server down if someone is connected during that time. I have TONS of CPU overhead to work with (I am barely above 5% in use, 8 cores total the highest is maybe…
Scott Chamberlain
  • 1,455
  • 2
  • 21
  • 37
4
votes
6 answers

What is typical SAN performance?

I have very little experience with SANs, so please excuse this newbie. One of our production sites has an HP EVA8000 SAN with a bunch of disks (forget exactly how much). it has been configured into a bunch of raid5's and the SQL server uses one RAID…
Soraz
  • 225
  • 1
  • 4
  • 11
4
votes
3 answers

SQL Server 2005 died

My SQL Server died and I can access the files on the C Drive but booting is a no go. Yesterdays backup is great but need today's data. I found the C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data with all my databases in there but I am…
Jimmy
  • 111
  • 6
4
votes
1 answer

Delete Database Information

We had our production database located on a production server. The database got deleted some how but I don't know how is was deleted. How can I determine who deleted the database, what was the IP address of the PC, at what time it got deleted and so…
xorpower
  • 141
  • 6
4
votes
3 answers

Log perfmon data to SQL Server

I am trying to log perfmon log (Windows Server 2008) to SQL Server 2005 (Windows Server 2003) using dsn (SQL Server authentication). On start perfmon counter i am getting error: "Call to SQLAllocConnect failed with [Microsoft][ODBC SQL Server …
Kartik M
  • 41
  • 3
4
votes
1 answer

How to enumerate SQL Server role members with Powershell?

I have a powershell script to enumerate the members of SQL Server role members using powershell. I have this script <... cut the connection details for brevity, $SqlInstance is a Microsoft.SqlServer.Management.Smo.Server object ...> $db =…
Mark Allison
  • 2,188
  • 7
  • 26
  • 45
4
votes
3 answers

Shrink SQL Server data file, but not all at once?

I have a database file that's currently 150GB, but only 75GB is being used - it's because I moved all the indexes (the other 75GB) to a new data file. I'd like to reclaim at least part of the space from this data file, but when I attempt to shrink…
SqlRyan
  • 906
  • 5
  • 14
  • 22
4
votes
3 answers

SQL Server Backup retention policy

I need to backup database in full recovery mode with a condition as: 1. Backup database, only when space is available for backup operation and Backup retention policy must be like expect last two days backup folder, delete all other backup…
Dhiva
4
votes
3 answers

If logs are being truncated, why use Full recovery?

We are doing nightly full backups and noon differential backups. We use Full recovery model with SQL Server 2005, but logs are never backed up and are truncated(TRUNCATE_ONLY) after the full backup. Restoring to a point in time is not a…
AaronLS
  • 955
  • 1
  • 10
  • 22
4
votes
2 answers

Installing .NET 1.1 over later versions: Safe?

I have a server that is running all versions of .NET Framework, from 2.0 up to 4.0. An application I need to deploy won't run correctly on later versions, and was originally compiled for 1.1. Is it safe to install version 1.1 on the machine…
Cyberherbalist
  • 337
  • 1
  • 4
  • 14
4
votes
2 answers

When successfully configured SQL Server for database mirroring, got an error saying it's not configured for database mirroring

I need to replace the old database in our test environment with a fresh copy of the production database. The test environment is actually comprised of two instances of the test database, on 2 different servers, in a mirroring configuration (it's got…
MGOwen
  • 307
  • 2
  • 4
  • 11
4
votes
1 answer

Extracting a SQLCLR assembly

One of our in-house applications has a SQLCLR assembly which is currently experiencing problems. The developer is having problems recreating the issue using the version that is stored in our source control system, so he suspects that some code may…
Ed Leighton-Dick
  • 1,094
  • 1
  • 7
  • 12
4
votes
1 answer

SQL Server 2008 Unique Problem for bring DB Online

This is my error I am facing TITLE: Microsoft.SqlServer.Smo Set offline failed for Database 'Go3D_Retailer ------------------------------ ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. …
Nai
  • 743
  • 1
  • 6
  • 24
4
votes
1 answer

How to get permission to create full-text index?

I tried to create a full-text index on my new full-text catalog and got this error: Msg 9967, Level 16, State 1, Line 1 A default full-text catalog does not exist in database 'foo' or user does not have permission to perform this action. FYI-- I…
Bill Paetzke
  • 855
  • 4
  • 12
  • 19
4
votes
5 answers

Use SQL varchar(max) or text?

I'm using SQL Server 2005 and I have a column where I need to store large amounts of text (sometimes over 8000 characters, the varchar limit). Is there a disadvantage to using the "text" data type? I also read about using varchar(MAX) -- would…
Austin
  • 205
  • 3
  • 5
1 2 3
…
71 72