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

2
votes
7answers
2k views

Problem attaching mdf file in sql server 2008

I have an mdf file of sql server 2005 database now i want it to attach in sql server 2008 R2 but when i try to attach it, it gave me error saying. Unable to open the physical file ...
9
votes
2answers
11k 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
610 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 ...
5
votes
5answers
1k 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
8answers
5k views

How to stop Log file from growing in SQL Server 2008?

In my application right after restore I perform many(>100,000,000) updates to the newly created database. Thus, LOG files grows significantly. How can I stop it from growing? NOTE: Setting recovery ...
1
vote
2answers
381 views

Distributing SQL Server on Internet regarding security issue

We are going to put our servers in two places to keep high level redundancy and to avoid bandwidth critics. The two servers are on different LANs but communicate over a WAN network (via Internet). One ...
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
375 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 ...
31
votes
7answers
36k 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
6k 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 ...
2
votes
6answers
3k 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
10k 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
760 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
741 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 ...
3
votes
2answers
412 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?
4
votes
5answers
262 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 ...
3
votes
3answers
1k 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
259 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
2answers
308 views

mysql to ms sqlserver

How can I convert database from Mysql to SqlServer 2005?
2
votes
2answers
620 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
3answers
5k 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 ...
2
votes
10answers
597 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
vote
1answer
982 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
67 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
3answers
1k views

Sql Server 2005 and AWE

we have SQL Server installed on a Windows Server 2003 with 2GB of memory. Would it help if we enabled AWE? Or do we have to add more memory and then enable AWE? Thanks
0
votes
2answers
993 views

Windows Server 2003 supports SQL Server 2008 Express edition?

I am wondering whether we could install SQL Server 2008 Express edition on Windows Server 2003? Or only SQL Server 2005 Express is supported on Windows Server 2003? thanks in advance, George
4
votes
1answer
5k 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 + ...
4
votes
2answers
5k views

Running SQL server 2005 and 2008 on same machine?

Running SQL server 2005 and 2008 on same machine ? Is this possible/practicable ? It's only for developers and not very resource intensive - is there anyone out there who's done it ? Would be ...
3
votes
3answers
198 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
1answer
374 views

Transaction log is full and does not free up space

I have a database in SQL Server 2005 whose transaction log becomes full. It is using snapshot replication. I noticed the transaction log is not freeing up space. So I created an additional transaction ...
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 ...
2
votes
2answers
3k 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
672 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
4answers
435 views

SQL Server 2005 on 64-bit, Memory > 3GB

Does AWE help on a 64-bit server? The option is still available. Does it do anything?
1
vote
1answer
434 views

Does Sql Server Express supports MSDTC

I need MSDTC(Microsoft Distributed Transaction Coordinator) in one of my application. I am not sure whether it is available on Sql Server Express editions. I googled on MSDN and haven't got clear ...
1
vote
3answers
419 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
2answers
1k views

Set Command Timeout from SQL Server 2005 rather than through the code?

I have an issue where things are timing out and I need to get an intermediate fix up while I work on making it faster. I can apparently set Command Timeout on the code side and it will prevent this, ...
0
votes
1answer
121 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
364 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 ...
0
votes
1answer
231 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
6answers
3k 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
2answers
4k 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!