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
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
7
votes
7 answers

How do I automatically run nightly backups for Microsoft SQL Server 2005?

I don't see any built in mechanism for scheduling nightly backups in SQL Server 2005. What tools are available to perform this task and how reliable are they?
cowgod
  • 3,500
  • 6
  • 28
  • 20
7
votes
2 answers

SQL Server: dbo vs db_owner role member?

I'm assinging user to a new database. What is the difference of user being a default dbo user compared to assinging login as a db_owner role member?
nickel
  • 75
  • 1
  • 1
  • 4
7
votes
3 answers

Is there a way to run sqlcmd to get query output without showing the number of rows affected?

I am running a simple query in SQL Server 2005 and want it to export to a file via sqlcmd. I was hoping to get the results in a csv format without the headers and the query metadata (how many rows are affected). for the headers you can actually…
rumz
  • 225
  • 1
  • 4
  • 13
7
votes
8 answers

MSSQL Large Delete

I have a table within a MSSQL database that contains more than 100 Million records spread over about 100 days worth of data. I need to purge some of this data based on its date which is an indexed field in the table. I've tried doing a DELETE FROM…
user2946
  • 263
  • 4
  • 8
6
votes
1 answer

SQL Server 2005 Performance Audit

Do you guys have any good step by step type links for performing an SQL Server 2005 Performance Audit? Something like this link would be great but for SQL Server 2005.
Nai
  • 743
  • 1
  • 6
  • 24
6
votes
4 answers

How long does reindexing take on SQL Server?

I've inherited a very large and very messy database recently and need to clean it up. To give some idea of size, the primary database currently contains 3 big tables each with around 300 million rows and takes up about 225GB storage space. Over 5…
Whiteknight
  • 183
  • 1
  • 1
  • 5
6
votes
1 answer

Copy SQL Server Databases

I am looking to "move" databases to different servers with minimal disruption to data and service. These databases vary in size from 5GB to 140 GB. I've seen and even used some of the various data transfer tools of SQL Server but I'm unsure of what…
Black Dynamite
  • 523
  • 2
  • 5
  • 16
6
votes
2 answers

Why is SQL Server 2005 hanging up when I try to delete a database?

I've got a Windows 2003 server with SQL Server 2005 and when I log into the Management Studio, right-click on a Database and choose "Delete" I get the Delete Object dialogue. I then click OK at the bottom and it grays out the dialogue and shows a…
Austin
  • 205
  • 3
  • 5
6
votes
3 answers

Can't see all catalogs on a MSSQL Linked Server

On SqlServer 2000 I have created a Linked Server to a SqlServer 2005 machine, with "Server type" set to "SQL Server" (first radio button), and the linked server name set to the remote machine's hostname. But SqlServer 2000 can only see ONE of the…
Chris Wenham
  • 189
  • 1
  • 1
  • 8
6
votes
3 answers

Schannel: Certificate received from the remote server was issued by an untrusted certificate authority

i'm not sure whether to ask this on dba.stackexchange.com or here. Periodically following error is logged in Windows Server 2008 Administrative events: The certificate received from the remote server was issued by an untrusted certificate…
Tim Schmelter
  • 163
  • 1
  • 1
  • 6
6
votes
4 answers

Why "Begin Transaction" before "Insert Query" locks the entire table?

I wrote a stored procedure to insert a record. I added "Begin Transaction" just above the Insert Query and execute the query. I noticed that another application that was showing a web page with records from the same table, hanged by the time the…
RPK
  • 215
  • 1
  • 5
  • 12
6
votes
4 answers

Why does Sql server write 100's of files to System Volume Information (all with the same name)

I noticed that SQL Server has a surprisingly large number of writes to \System Volume Information\{guid1}{guid2} What is Sql Server doing when something like this happens? In the above image half of my write IO for sqlsevr.exe is used for the…
Scott Chamberlain
  • 1,455
  • 2
  • 21
  • 37
6
votes
1 answer

Database Backup and Full-Text Search

I am running SQL Server 2005 EE. When trying to perform a full database backup I receive the error message: Failed to pause catalog for backup. Backup was aborted.BACKUP DATABASE is terminating abnormally. After googling the issue, it seemed to…
user82392
  • 61
  • 1
6
votes
4 answers

SQL Server 2Kx: How to move a database to a different partition in the local file system?

SQL Server creates its databases in the system program files directory structure. I want to separate the database files away from the system partition. Assuming the database is already created and populated: How do I move all files related to a…
Matias Nino
  • 1,392
  • 7
  • 25
  • 40
1 2
3
…
71 72