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
10
votes
1 answer

Cancel Database Take Offline

I accidentally tried to take offline a DB via the context menu command > Tasks > Take Offline. The process is ongoing now and no new connection can be made. How do I cancel this process?
Adrian Godong
  • 577
  • 4
  • 9
  • 20
10
votes
6 answers

How to migrate from SQL Server 2005 to 2008

How do you migrate SQL Server 2005 databases to SQL Server 2008? Is it as easy as backing up 2005 databases and simply restore in 2008? Are there any compatibility issues? Is SQL Server Reporting service changed in anyway? How would you go about…
dance2die
  • 1,961
  • 7
  • 31
  • 40
10
votes
2 answers

What are the implications of the SHOWPLAN permission on SQL Server 2005?

A user wants the SHOWPLAN permission in order to use Execution Plans to tune a query. What are the implications of this permission. Is it safe to grant a user? I've seen the security note here, and that doesn't concern me with this user. Are there…
Josh
  • 245
  • 3
  • 8
9
votes
3 answers

SQL Server - Cluster vs Mirror for high availability?

I have been doing research into various high availability options for SQL Server 2005. With regard to high availability, what circumstances would favor clustering over mirroring as an option? From what I can tell, mirroring has numerous advantages…
Jeremy
  • 641
  • 3
  • 11
  • 16
9
votes
5 answers

Calling sp_start_job from a stored procedure

Our developers need to be able to start a SQL Server Agent job from their .Net code. I know I can call msdb..sp_start_job to do just that, but I don't want to give general user accounts direct access to run jobs. What I'd like to do is to create a…
Ed Leighton-Dick
  • 1,094
  • 1
  • 7
  • 12
9
votes
2 answers

How to attach mdf files from a different SQL Server Install?

Hi I have mdf and ldf files from a different SQL Server install from a machine i dont have access to now, and would like attach them to my current install to get at the data. When I try this, I get an error: Cannot attach a database with the same…
Drew
  • 275
  • 2
  • 3
  • 7
9
votes
2 answers

Can I fit an entire DB in memory?

My database is about 1gb in size (according to the mdf file of my db). My database server has 4gb of ram. Looking at the memory consumption on the computer while active, it sits at around 85% used (including OS, etc) Does this mean that all DB read…
Joda Maki
8
votes
7 answers

My templog.ldf is huge (45gb), What if anything should I do?

I've a SQL 2005 installation and my templog.ldf file keeps growing to consume all the free space on the drive it's on. Sometimes it'll stop with a few mb free but sometimes it goes further, this being the c drive I think this behaviour may be…
Robin
  • 807
  • 3
  • 11
  • 19
8
votes
4 answers

Does MSSQL Server have the equivalent of MySQL's query logs?

I have used MySQL for a long time and have found the general query log and the slow query log to be very useful in finding out what is happening on the server, and in identifying bottlenecks. Now I need to use SQL Server. Does SQL Server have…
Martin
  • 506
  • 2
  • 4
  • 13
8
votes
9 answers

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 see queries taking longer and longer to complete…
Dave Holland
  • 1,898
  • 1
  • 13
  • 17
8
votes
4 answers

Best way to backup a SQL Server database nightly?

What is the best way to backup a SQL Server 2005 database nightly? I'm looking for a solution/strategy that would make the database backup file, and place it in an "outgoing" directory. We're wanting our FTP software to move it out to an offsite…
Urda
  • 509
  • 4
  • 16
8
votes
3 answers

How to monitor activity on a single table using SQL Server profiler

I have a table which uses and identity seed for its unique identity column. We have noticed some massive jumps in the identity value which we are not able to explain. The table has 20,000 odd rows, the maximin identity value is over 560,000,000 and…
user22785
  • 189
  • 1
  • 1
  • 3
7
votes
6 answers

How to find when the stored procedure was deleted and who deleted it?

Actually, one of the critical jobs failed while executing. In the error message it was found that the failure is because it was missing a stored procedure. Now how do I find out when was the stored procedure was affected by the user. How do I find…
srihari
  • 193
  • 1
  • 1
  • 3
7
votes
7 answers

SQL Server Security Crackdown

I've been working a job for 2 years now as a SQL Server DBA for a city. I was brought in to support an existing DBA, so I've slowly taken everything in and have been working for a while, trying to gain credibility in the organization. It's time…
a_dba
7
votes
5 answers

Opening .mdf files

Apologies for the newbie question - I've got a .mdf file, and I've no idea how to run queries against it. I've downloaded and installed SQL Server Express 2005, but don't know when to start. I know that I'm not meant to open the file directly, but…
Dominic Rodger
  • 345
  • 2
  • 4
  • 10
1
2
3
…
71 72