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

SQL Server 2005 Restore from Backup Failing

I have .bak files for the database of a project my company recently took over. I was able to restore several of the .bak files, but the most important one is failing. When it fails I simply get a generic error, and asked to check the log. This is…
Jack Marchetti
  • 561
  • 1
  • 6
  • 15
3
votes
1 answer

sql server 2005 encoding problem

Ive got text file with utf-8 encoding with more then 2k lines of insert command. Now I would like to execute it as a sql script to insert data into database. There is greek text with which there are problems. After inserting there are only ?…
potatoMan
  • 153
  • 1
  • 1
  • 5
3
votes
1 answer

sql server limitation of data size

This question is related to my SQL Data type size A varchar(max) seems to be able to store up to 2GB. What I can not understand though is that in this link sql row overflow MS says (my emphasis): A table can contain a maximum of 8,060 bytes per…
user76678
  • 349
  • 3
  • 5
  • 16
3
votes
3 answers

SQL Server won't start due to LUNs being unavailable

I've got a standalone SQL 2005 server (on Windows Server 2003) which has 2 LUN drives attached for the datafiles and transaction logs. When the server reboots, the SQL Server service starts before the LUN drives are available and therefore errors…
Richard Jones
  • 33
  • 1
  • 3
3
votes
2 answers

How do you fix the Performance Dashboard datetime overfow error

I'm a programmer/DBA by accident and we're running SQL Server 2005 with Performance Dashboard for basic monitoring. The server has been up for a few weeks and now we can't drill into certain reports. Is there any way to reset these reports without…
Mike L
  • 719
  • 1
  • 6
  • 11
3
votes
1 answer

Uninstalling SQL Server 2005 express - blue screen

Few months ago, I installed sql server 2005 express edition. When I am trying to uninstall it, it keeps throwing a blue screen saying, the subsystem system has terminated unexpectedly 000x...Is there a way to uninstall sql server 2005 express. Does…
user80994
  • 131
  • 1
3
votes
4 answers

Setting up ASP.NET Membership provider for an application

I recently downloaded DotWiki which I plan on using for a support section for my companies website. The application itself has two different security modes "simple" and "full". Full uses an ASP.NET Membership provider for security. However when I…
Kevin Wiskia
  • 31
  • 2
3
votes
3 answers

SQL Server won't let me log in

I have installed SQL Server 2005 (Developer edition) on a Windows 7 machine (I know - it wasn't my choice!) Machine is named user-PC, and has only one user: user no pwd. I am trying to connect to DATABASE ENGINE, using server USER-PC (taken from…
Chris Kemp
  • 31
  • 2
3
votes
3 answers

SQL 2005 Diff backups failing - no full backup exists?

I have a SQL 2005 SP 2 server running a maintenance plan that performs full backups every day at 22:00, diff backups every 4 hours and log backups every 30 minutes. The plan backs up all system & user databases (all user DBs are in Full recovery…
Chris W
  • 2,670
  • 1
  • 23
  • 32
3
votes
2 answers

What could cause mirrored databases to both become the principal database?

We use SQL Server 2005 in a high-availability configuration: 1 principle server, 1 mirror server, 1 witness server. This morning we found that several databases were listed as the principle database on both the principal server and the mirror…
Omlette
  • 46
  • 3
3
votes
3 answers

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 sure as a) I'm not a DBA and b) I'm still in the…
Holocryptic
  • 5,665
  • 2
  • 29
  • 37
3
votes
3 answers

What is the standard method to keep track of the latest Cumulative updates for SQL Server?

What resources are good for keeping track of cumulative updates for SQL Server? I noticed that Windows update does provide a service for SQL Server.
Kyle Brandt
  • 83,619
  • 74
  • 305
  • 448
3
votes
5 answers

TempDB contention on sysmultiobjrefs SQL 2005

We've been having trouble caused by what we believe is contention within tempDB. Whenever we are having problems, our system is always waiting on one particular resource: 2:1:103, which when we look it up (using DBCC PAGE(2,1,103)) tracks back to…
Rob
  • 31
  • 4
3
votes
1 answer

Script to mirror MS SQL Server databases between 2 servers

I have about 200 sites each of which have 2 servers running MSSQL (2k5 at some sites, 2k8 at others) One server is production and the other is primarily there as a backup. We're rebuilding all of these servers this year and as part of that we will…
David W
  • 91
  • 1
  • 7
3
votes
1 answer

What happens when tempdb can't grow any more?

I have run into a problem where a tempdb database set to have unrestricted growth has used up all the available disk space (10x its norm). I am considering setting a maximum size limit, something big but just not all the space. If a query pushes…
Iain Hoult
  • 143
  • 1
  • 7
1 2 3
…
71 72