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

learn more… | top users | synonyms

11
votes
2answers
12k views

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 ...
3
votes
1answer
622 views

windows server 2003 monitoring software combining SQL Server monitoring with CPU-IO stats

I'm aware this type of question has been asked many times before: http://serverfault.com/questions/499/how-to-monitor-bandwidth-usage-in-real-terms http://serverfault.com/questions/1259/network-...
1
vote
4answers
1k views

Why upgrade from SQL 2005 to SQL 2008 R2?

have been tasked to write a document outlining the best reasons to use SQL 2008 R2 instead of SQL 2005 for my brand new BI project. We have a policy of only using two versions at a time and there are ...
0
votes
4answers
392 views

Why some XP installs don’t automatically Start SQL2005 Service (Instance)

I have a number of XP machines that have a SQL 2005 Instance running on them, and they are set to start automaticly in Service Control Manager. On 1 or 2 of these machines when you reboot, the SQL ...
34
votes
7answers
45k views

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 ...
12
votes
2answers
7k views

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 ...
3
votes
6answers
5k views

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 ...
7
votes
9answers
15k views

MS SQL Server slows down over time?

Have any of you experienced the following, and have you found a solution: A large part of our website's back-end is MS SQL Server 2005. Every week or two weeks the site begins running slower - and I ...
4
votes
4answers
839 views

Creating a SQL server Maintenance Plan without the wizard

Is there a way to generate a SQL server maintenance plan that will be the same as the one generated by the wizard, but without going through the wizard dialog. I need something that can be created ...
3
votes
2answers
451 views

How do you backup a database within SQL Server 2005 from the command line?

I need to create a scheduled task that will backup a database within a SQL Server 2005 instance. Is there a command line argument that I can use to achieve this?
3
votes
2answers
958 views

SQL Server Management Studio not scripting all objects

i've been attempting to script a database using SQL Server 2005 Management Studio. i cannot get it to script some objects. It scripts others, but skips some. i can provide detailed screen shots the ...
4
votes
5answers
286 views

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....
3
votes
3answers
11k views

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 ...
3
votes
3answers
9k views

Queries run extremely fast locally, extremely slow on remote machines

We have a query that take takes anywhere from 24-38 seconds to run when you run it from SQL Server Management Studio from a remote machine, but <1 second to run when it is run from the machine ...
3
votes
3answers
2k views

What is the best practice for the database owner in SQL Server 2005?

What is the best practice for the database owner in SQL Server 2005? I have already searched this page... http://technet.microsoft.com/en-us/sqlserver/bb331794.aspx and didn't find what I was ...
2
votes
2answers
288 views

Should I avoid SQL Server Replication?

I have an app that is used by people in the US and in China and the database sits in the US. The people using it in China complain that the performance is poor, so I was thinking of using SQL Server ...
2
votes
0answers
23k views

Cannot telnet to SQL Server on port 1433

I've been working solidly on this issue for the past three weeks. I cannot seem to find where the actual issue is. I just recently found this article on how to troubleshoot the connection. I made it ...
2
votes
2answers
788 views

How do I configure SQL Server 2005 to accept a connection to a private or internal IP address on a private network?

I'm in unfamiliar territory, but here's the scenario: I have an application server and a database server, and both are on a private network. How do I allow connections from my app server to the ...
2
votes
10answers
602 views

SQL2005 vs SQL2008

We are investigating replacing an existing SQL2000 server on Windows2003 (32Bit) with new hardware and a newer version. We are looking at an application that requires at least SQL2005, but will run ...
2
votes
2answers
351 views

mysql to ms sqlserver

How can I convert database from Mysql to SqlServer 2005?
1
vote
5answers
7k views

Recovering a specific job definition from an MSDB backup?

We've been asked to recover a specific SQL 2005 job from how it existed at a certain time in the past. We have MSDB database backups from that time period, but I can't overwrite the current MSDB ...
1
vote
1answer
1k views

SQL Server 2005 Accidentally removed a user from public role, can't add user back into role

I'm trying to crearte a DB user account that only has access to a specific database, and can't read or change other databases, and can't alter credentials for any other accounts. I accidentally ...
1
vote
1answer
84 views

ms sql 2005 server role problem

On one of our sql 2005 servers we are no longer able to give any users server roles (ex. sysadmin). It appears to be successful both through the UI and through code. But when we check in the db and in ...
1
vote
4answers
1k views

SQL Server backup and restore process

Just wondering what backup processes you guys have. I am currently operating a weekly full database backup with daily differential backups. My understanding is that with such a set up, the ...
1
vote
2answers
1k views

Migrating to a new SQL Server machine: should master database be restored?

I'm currently working on a migration plan to migrate our SQL Server to some new hardware. The current installation is SQL Server 2005 standard: it used to be clustered but the node got removed at ...
7
votes
1answer
10k views

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 + ...
5
votes
5answers
2k views

SQL2005 Stuck in Single Mode User

Hey currently have a database stuck in single mode after setting it to single mode to attempt to try take if offline which I wish I never did.... I tried ALTER DATABASE DB SET MULTI_USER but get ...
3
votes
3answers
263 views

Renamed computer with MSSQL 2005 installed - might have broken something

I have SQL 2005 SP4 installed on Win2k8. After I had it setup, we decided to change the name of the computer. In doing so, I think I might have broken something (possibly named pipes?) but I'm not ...
2
votes
3answers
3k views

Too many connections to SQL 2005

I have a situation where an application is over time opening a cumulative 6000 + connections to a 32 bit SQL2005 SP2 backend from a couple of app servers eventually causing internal memory pressure (...
2
votes
2answers
4k views

SQL Server Management Studio missing when I installed SQL Server 2005

For some reason SQL Server Management Studio is missing when I installed SQL Server 2005 Developers Edition. Any reason why or how can i get SQL Server Management Studio on my PC? My operating system ...
2
votes
2answers
739 views

SQL Server 2005 Patch Corrupts SQL Installation on Windows 2003 Standard x64

We're in a holding pattern on this one right now, but I thought I'd poll folks for some added info in case this has happened to anyone else. We have 2 SQL 2005 Enterprise servers on Win2K3 Std x64. ...
2
votes
3answers
1k views

Can a SQL Server 2000 database be hosted on SQL Server 2005/2008

I have a SQL Server 2000 database backup, but I don't have SQL Server 2000 installed. I have SQL Server 2005 installed. I'd like not to have multiple pieces of DB server software installed. Is it ...
1
vote
2answers
48 views

Difference of speed if SQL Server is on one server and website is on another, rather than both on same server

We have db and website on same server. I would like to know that what would be the pros and cons of dedicated server for db (SQL Server 2005) and for website (webserver is IIS). Same db is also ...
1
vote
3answers
423 views

How do I change the system wide collation setting in SQL Server 2005

I've got a recently upgraded SQL Server which I'm getting ready to put live, we've gone from SQL Server 2000 to SQL Server 2005. The collation setting on the 2005 box is different though (I didn't do ...
0
votes
6answers
4k views

Is it possible to configure SQL Server 2005 to auto-compress backups?

I have created scheduled backup and shrink maintenance plans for my SQL 2005 instances using the tools in SQL Server Management Studio. I am wondering, is there an equally easy method for ...
0
votes
1answer
290 views

Monitor network drops between Windows Server 2003 servers

This is probably a ridiculously simple question, but here goes... I'm troubleshooting an issue where an application (SQL Server Analysis Services) becomes unavailable for anywhere from 30 to 60 ...
0
votes
2answers
6k views

How to connect to a local SQL Server?

how to configure SQL Server 2005 for remote connection? I have to access a local SQL Server with a web application. Thank you!
0
votes
1answer
126 views

Configuring SQL Server Express 2005

What's the proper way to configure SQL Server Express 2005 so that it can allow for a number of clients to get connected to the server? I have my application running both in the server machine and the ...
0
votes
1answer
371 views

SQL Server 2005: Cannot install database diagram support objects

I have run into a "good old" problem on SQL Server 2005 Express. When I select the "Database Diagrams" node in SSMS, I get the message: Database diagram support objects cannot be installed ...