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
38
questions
11
votes
2
answers
13k
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 ...
- 1,172
3
votes
1
answer
648
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:
How to Monitor Bandwidth usage in real terms
Network monitoring
application monitoring tools
Network Traffic Monitoring
...
- 1,523
1
vote
4
answers
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 ...
- 151
0
votes
4
answers
418
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 ...
- 231
38
votes
7
answers
54k
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 ...
- 483
12
votes
2
answers
8k
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 ...
- 1,172
8
votes
9
answers
21k
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 ...
- 1,908
5
votes
5
answers
3k
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
...
- 153
4
votes
5
answers
16k
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 ...
- 2,210
4
votes
3
answers
3k
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 ...
- 170
4
votes
5
answers
316
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....
- 2,897
4
votes
6
answers
7k
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 ...
- 225
4
votes
4
answers
1k
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 ...
- 243
4
votes
4
answers
38k
views
DBCC CheckDB The operating system returned error 21(The device is not ready.) [closed]
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 ...
ManishKumar1980
4
votes
5
answers
490
views
What is the best way to move 20+ databases to a new database server? SQL 2005
Current database server: SQL Server 2005 - Windows Server 2003
New destination database server: SQL Server 2005 - Windows Server 2003 Enterprise - VM Ware image
Current database server has 20+ ...
kmc
4
votes
0
answers
56k
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 ...
- 41
3
votes
3
answers
18k
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 ...
- 203
3
votes
2
answers
2k
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 ...
- 5,373
3
votes
2
answers
601
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?
- 269
3
votes
3
answers
307
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 ...
- 5,675
2
votes
2
answers
3k
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 ...
2
votes
2
answers
386
views
2
votes
2
answers
427
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 ...
- 248
2
votes
2
answers
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 ...
- 273
2
votes
2
answers
823
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. ...
- 38k
2
votes
10
answers
634
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 ...
- 1,503
2
votes
2
answers
1k
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 ...
- 123
2
votes
3
answers
4k
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 (...
- 1,262
1
vote
2
answers
9k
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!
Manish
1
vote
3
answers
479
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 ...
- 827
1
vote
4
answers
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 ...
- 743
1
vote
1
answer
2k
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 ...
- 611
1
vote
2
answers
124
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 ...
- 193
1
vote
1
answer
104
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 ...
Brandon
0
votes
6
answers
5k
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 ...
- 757
0
votes
1
answer
445
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 ...
- 449
0
votes
1
answer
336
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 ...
- 1,158
0
votes
1
answer
140
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 ...
- 11