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

What kind of values should I worry about in in sys.dm_os_wait_stats?

While reading Will disabling hyperthreading improve performance on our SQL Server install I started wondering what the values I get for Jeff's first query: SELECT * FROM sys.dm_os_wait_stats order by signal_wait_time_ms desc Which gives me a…
lambacck
  • 376
  • 2
  • 4
0
votes
3 answers

SQL Transaction log backups after Full SQL Backups

Environment: VM with 20 gb of HD space and secondary hard drive with 3 gb. Windows Server 2003 and Sql 2005 Backup Scenario: Weekly Full backups with Backupexec Nightly Diff. backups with Backupexec Daily 15 min. log file backups maintenance…
tjinak
  • 31
  • 1
0
votes
1 answer

SQL Server 2005 Service Pack 2 - Failed Cluster Node

We have SQL server 2005 running on our cluster with Service Pack 2. However one of the nodes failed, after rebuilding the node I added the node back to the clster with SQL server setup. However it gave me a warning that the version being installed…
user57767
0
votes
3 answers

How can one use Reporting Services against a log shipped database?

Using MS SQL SERVER 2005. I have log shipped the ReportServer database to the secondary server in Standby/Readonly. I seem to be unable to use Reporting Services on the secondary database because it complains about the ReportServer database being…
SeanDav
  • 161
  • 1
  • 3
0
votes
3 answers

MSSQL2005 database hanging during maintenance

Our database server has a maintenance plan which runs each night: Back up databases & logs (10-20GB max) Check Database Integrity Rebuild Indexes Update Statistics Normally this all executes in under a minute per database. However, in the last…
realworldcoder
  • 281
  • 1
  • 3
  • 15
0
votes
1 answer

Change the logical name of sql server express 2005 database file?

In Microsoft SQL Server Management Studio Express for Sql Server Express 2005, I needed to copy a database for testing and keep it on the same server as the old database. I did the following: Right Click on Databases Created new database Detached…
oob
  • 215
  • 2
  • 6
0
votes
2 answers

How can I tell if SP3 is installed for my SQL Server 2005 instance?

How can I tell if SP3 is installed for my SQL Server 2005 instance?
kenwarner
  • 265
  • 2
  • 5
  • 16
0
votes
1 answer

Running two kinds of backup at the same time

I'm going to schedule a differential backup at 01AM and transaction log backup every one hour for a database. What will happen differential backup takes too long and transaction log backup starts while differential backup still running? Also same…
dstr
  • 197
  • 2
  • 6
0
votes
3 answers

How to do a single backup of SQL Server 2005 Data for out of place restore?

My problem: I got a virtual Windows XP machine with a specific database driven software installed using SQL Server 2005. A similar machine is also in use by several customers. One customer reports an SQL Server error, which I cannot reproduce…
elsni
  • 425
  • 1
  • 4
  • 8
0
votes
1 answer

is it possible to lower the priority of the replication process in sql server 2005

we're planning on running transactional replication of a part of our database for some near-time reporting. I'm not quite sure which process will run to 'do' the replication, but is it possible to give this process a lower priority then sql server…
Michel
  • 239
  • 2
  • 4
  • 10
0
votes
1 answer

How to change schedule of backup jobs using SQL Management Studio

I have an SQL Server 2005 on our lab network, I installed MS SQL Management studio on separate computer to connect to the SQL Server to schedule a backup job of a few database. It worked fine for the backup jobs as scheduled, my question is how am I…
Bonifacio Acebedo
  • 1
  • 1
  • 1
0
votes
2 answers

About sql server remote access

i am using sql server 2005. my system is connected in network. i want to give access to my sql server to specific person(IP) in the network and other persons should not access. please solve this issue. thanks in advance.
Cup Of Life
0
votes
1 answer

Sending alerts with Database Mail

I've been looking into SQL Server alerts and it looks like I need to enable database mail on the server to be able to send e-mail alerts. The other solution appears to be to send those events to another server which already sends e-mail alerts (for…
pete the pagan-gerbil
  • 181
  • 2
  • 13
0
votes
2 answers

Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection

Sql server is in Mixed Mode and I changed the user Password through Windows Authentication Mode from Security. After that when I try to connect the server it throw the error TITLE: Connect to Server ------------------------------ Cannot connect to…
Azhar
  • 115
  • 3
  • 4
  • 10
0
votes
2 answers

sqlserver not respond to query

My 2005sql server doesn't respond to the query sometime , and when I check the event I get the following event : Auto grow of file "databasename_log" in database was cancelled by user or timeout after 30125 milliseconds . Use alter database to set a…
parsa
  • 1
  • 3
1 2 3
…
71 72