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
47
votes
6 answers

How to check progress of DBCC SHRINKFILE?

Is there a way to find out the progress of DBCC SHRINKFILE statement? Here is how I was running it dbcc shrinkfile('main_data', 250000) I am running above statement on both SQL Server 2005 and 2008. [UPDATE] Here is the query I ran to check the…
dance2die
  • 1,961
  • 7
  • 31
  • 40
38
votes
7 answers

How do I reduce transaction log backup size after a full backup?

I have three maintenance plans set up to run on an Sql Server 2005 instance: Weekly database optimisations followed by a full backup Daily differential backup Hourly transaction log backups The hourly log backups are usually between a few hundred…
Dave D
  • 483
  • 1
  • 5
  • 10
17
votes
4 answers

Timeout saving table in SQL Server

I'm trying to add a column to a table with much data in SQL Server 2005, using SSMS. So I browse to the table, select Modify, and add the new column. Then, when I press Save, I get the following warning: Saving Definition Changes to tables with…
Tor Haugen
  • 449
  • 4
  • 6
  • 14
16
votes
6 answers

How do I change the collation of a SQL Server Database?

I'm trying to standardise all databases on a single collation - Latin1_General_CI_AS (the standard collation). I have some databases that are in SQL_Latin1_General_CP1_CI_AS. I know I can use ALTER DATABASE to change the database collation, but…
Richard Gadsden
  • 3,696
  • 4
  • 28
  • 58
15
votes
7 answers

SQL Server restore a backup results in an error

I have a database in dev (SQL Server 2005 on Windows Server 2008) that I need to move to prod (SQL Server 2000 on Windows Server 2003). My process is as follows: Login to dev, open SQL Server Management Studio Right click on the database | Tasks |…
Mario
  • 321
  • 1
  • 5
  • 12
14
votes
5 answers

How can I detach a database that is in use?

Even though nothing is using it I am unable to detach a database because it is use. Cannot detach the database 'DEMO' because it is currently in use. I have tried rebooting and get the same message.
Jack B Nimble
  • 1,505
  • 1
  • 10
  • 13
14
votes
7 answers

SQL Server - Force DB in memory?

We have a beefy Windows 2008 x64 server (4 x 4 core CPU, 32GB RAM) running SQL Server 2005 64-bit. We have a small (6GB) but very important database that is somewhat slow to access until the pages are cached in memory (the usage is very much random…
Matt Rogish
  • 1,512
  • 6
  • 25
  • 41
12
votes
7 answers

How much RAM does a server actually need?

I have a quite a few servers deployed around the world. They are running Windows 2003 x64 with SQL Server 2005 x64 with 6 GB of RAM. The boxes do not have the best (or even an acceptable) configuration, because the guy that ordered them years ago…
AngryHacker
  • 2,877
  • 6
  • 28
  • 33
12
votes
2 answers

How to undo assigning ownership of db_datareader/db_datawriter schema?

i meant to assign an SQL Server login to the db_datareader db_datawriter database roles. But if a moment of sore tummy and tiredness, i accidentally give that user schema ownership of them instead: Ignoring for the moment what it can…
Ian Boyd
  • 5,131
  • 14
  • 57
  • 79
12
votes
4 answers

SQL Server Installation: Is it 32 or 64 bit?

Recently I was performing an OS upgrade on one of our DB servers, moving from Server 2003 to Server 2008. The DBMS is SQL Server 2005. While reinstalling SQL on the new Windows installation, I went to another of our DB servers to verify a couple of…
CapBBeard
  • 948
  • 2
  • 9
  • 13
12
votes
4 answers

Why is "DbccFilesCompact" status is "Suspended"?

I am running SHRINK file on a 600G data file. Currently, status is reported as "suspended" and sys.dm_exec_requests.percent_complete for DbccFilesCompact command reports that it is running (but very slowly) Is there a way to check why it's being…
dance2die
  • 1,961
  • 7
  • 31
  • 40
12
votes
2 answers

Find out which database in SQL Server 2005 uses how much RAM

A friend of mine asked me today (trying to calm down an agitated customer of his) how you could find out in SQL Server 2005 which database uses how much memory (in the server's RAM that is) at any given time. Is that possible at all? If so - how?…
marc_s
  • 1,132
  • 4
  • 21
  • 35
12
votes
2 answers

How can a Perfmon "% Processor Time" counter be over 100%?

The counter, Process(sqlservr)\% Processor Time, is hovering around 300% on one of my database servers. This counter reflects the percent of total time SQL Server spent running on CPU (user mode + privilege mode). The book, Sql Server 2008…
Bill Paetzke
  • 855
  • 4
  • 12
  • 19
11
votes
5 answers

Database planning - Multiple Schemas vs Multiple Databases vs Single large database vs Partitions

We design websites for Realty companies. The websites are used only to display the information and all the websites share a common template. We have around 150 websites for different customers. Some third party data providers, provide us all the…
kishore
  • 852
  • 3
  • 13
  • 27
11
votes
2 answers

SQL Server 2005 / 2008 - multiple files / filegroups - how many? Why?

I'm a developer at heart - but every now and then, a customer doesn't have a decent DBA to deal with these issues, so I'm called in to decide.... What are your strategies / best practices when it comes to dealing with a reasonably sized SQL Server…
marc_s
  • 1,132
  • 4
  • 21
  • 35
1
2 3
71 72