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

5
votes
5answers
2k 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 ...
1
vote
1answer
673 views

Help with SQL Server 2008 permissions

Today I migrated a database from SQL Server 2005 to SQL Server 2008 R2 using the backup/restore method which went fine and did not generate any errors. I can log into SQL Server 2008 through the SQL ...
1
vote
2answers
136 views

SQL 2005 - Disable Page Caching

I know this is kind of a funny request, but I'd like to disable page caching on our development database. I believe it would make it much easier to see the impact of various tweaks that are done, and ...
0
votes
1answer
218 views

Sql Server 2005 Service Pack 3 does not install

I'm trying to install SP3 on an install of Sql Server 2005 running on Server 2003 32 bit. When I run the installer it doesn't seem to recognize that I have SQL Server 2005 installed. The dialog box ...
0
votes
1answer
36 views

SQL SERVER Query result performance question

When I run a simple query on server SSMS it takes 3 seconds. When I run the same query on my computer on SSMS it takes 35 seconds. What could be the reason? What should I check first? I tried disable ...
0
votes
3answers
228 views

Batch file function

I need to create a batch file that will purge data from an existing file. Basically SQL server management studios does not overwrite backup data; therefore after the backups have been run and the data ...
1
vote
3answers
69 views

slow database insertion slowness sql server

At some costumer we have a really slow insertion to the database (three time slower then normal). I cannot see the reason why it happening. Checked the network and it seems to be ok. Any suggestions ...
0
votes
2answers
269 views

ColdFusion 9 and SQLServer Express 2005

I'm installing a virtual machine with Windows 2003 Web Edition with ColdFusion 9 and a SQL SERVER 2005 Express. I've imported and attached the databases from two files and I can use it correctly from ...
6
votes
2answers
6k views

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 ...
2
votes
1answer
936 views

How to extract data from an MSDE .dat backup file

A client wants me to extract customer data from his old system The application he was using appears to have used MSDE as the database and its backups have the extension .dat SSMS express edition or ...
0
votes
2answers
3k views

SQL Server 2005 Express on Windows 7: Service does not start during installation [closed]

During SQL Server 2005 Express installation on a computer with Windows 7 Home Premium x64, the installation failed upon trying to start the instance service. No log file was created in the instance ...
0
votes
1answer
260 views

Error on creating job SQL Server 2005

Error on creating job: Unable to cast object of type 'Microsoft.SqlServer.Management.Smo.SimpleObjectKey' to type 'Microsoft.SqlServer.Management.Smo.Agent.JobObjectKey'. (Microsoft.SqlServer.Smo) ...
6
votes
1answer
474 views

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

SQL 2005 Server memory requirements and performance

What is the risk involved in running on 91% RAM usage on Windows Server 2003 32 SP2 and SQL Server 2005 in terms of SQL Server performance? Server has 3GB and mostly sits at around 80% mark with ...
0
votes
2answers
205 views

Why does the MSSQL stay at “restoring… ” even after 2 hours?

I have backed up a database at my old server and restored it at the new server. I am totally new to MSSQL 2005 Server Express, so it took me quite a while. I spent 30 minutes to find out back-ups are ...
1
vote
5answers
1k views

User not functioning after backup and restore of database to another server in SQL Server 2005

We have a database called 'foo' on the first sql server instance called 'SQL01' that is backed up nightly via a snapshot with Snap Manager for SQL Server and then flex cloned and restored to a second ...
1
vote
3answers
4k views

Is it safe to restart Sql Server Agent?

I've found myself in the tenuous role of a developer tasked to manage a SQL server. I've set up some jobs to run on a schedule, but would like to receive email notification on completion. I've set ...
1
vote
2answers
67 views

Sql Server improving performance with monitoring etc

What are some ways I can constantly monitor and report on my production sql server so that I can determine where locks and performance improvements can be made?
1
vote
1answer
429 views

SQL 2005 Cluster - How to move MSDTC

We currently have a 2 node (Win2003) SQL 2005 Cluster running 2 instances. We need to move all drives to a new SAN but are pondering over how to move the DTC that is currently 'logging' te Quorum ...
0
votes
1answer
24 views

MSSQL2005: is there a sproc to set the default distribution agent profile?

I'm trying to work out how to set the default profile for the distribution agent programatically using t-sql. I see there is the sp_help_agent_profile and sp_help_agent_default sprocs which allow you ...
0
votes
1answer
336 views

Is it possible to move sql server databases (physical files) without detach/attach

I want to move physical location of all my databases (around 20) to new location. sys.master_files (physical name) column gives me path of databases. If I copy physical files to new location and ...
1
vote
1answer
51 views

Troubleshoot DBMail in SQL Server 2005

On a SQL Server 2005 machine, I have DBMail setup and correctly configured. I am able to use "Notify Operator" and EXEC msdb.dbo.sp_send_dbmail to queue emails. But the problem is the queued mails ...
3
votes
1answer
217 views

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 ...
1
vote
1answer
253 views

Can you use a relatively expensive filter on transactional replication?

I'm trying to replicate (transactional, push) a relatively small table (50K rows), subject to several different filters, which are rather expensive (each taking at least an hour long to complete, ...
0
votes
1answer
133 views

Connect to SQL Server using Windows Group Authentication

I've got this SQL Server 2005 Express installation that's got a Database I'm trying to connect to through a software that gives me the error "cannot connect using the user 'mydoimain\myuser'. Meaning, ...
1
vote
2answers
65 views

SQL Server Job Question

In our project, we have two SQL Server Jobs- one to run on every night 12 AM (let’s call it “JobA”) and another one to run on every month ( 1st of every month 12AM. And let’s call it “JobB”). These ...
0
votes
2answers
1k views

Windows 2003 Enterprise Server becomes unresponsive occasionally

We're experiencing issues with our Windows 2003 server, which runs SQL Server 2005 SP1. We notice that sometimes the entire server becomes unresponsive and I captured a screenshot of the task manager ...
0
votes
2answers
2k views

SQL Server 2005 version 9.00.4035.00 vs 9.00.1399.00

I have two servers with the versions above (9.00.4035.00 vs 9.00.1399.00), but we installed from the same source. Now some projects don't open. How can I solve this - applying Service Pack 3?
1
vote
0answers
196 views

tfs problem :TF31001Team foundation can't retrieve the list of team project from team foundation server

Q: When i want to create a new project : File ---> New ---->Team Project I get the following error , i googled it but in vain . Error: TF30224: Failed to retrieve projects from the report server. ...
1
vote
2answers
34 views

Migrating and consolidating database from SQL Server 2000 into Existing SQL Server 2005

I’d like to know what should I prepare and pay special attention to in migrating and consolidating the SQL Server 2000 database into SQL Server 2005 ? From what I can think of now is that manual ...
3
votes
3answers
666 views

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 ...
1
vote
2answers
281 views

SQL Server read-only user can connect local but not remotely

I have a SQL Server where admin users can connect locally and remotely, but read only users can only connect locally and get a "Login failed" error when connecting remotely. It's using SQL Server ...
2
votes
2answers
204 views

How To Backup A Maintenance Plan

I'm using SQL Server Management Studio 2005, and I'm about to make changes to the (rather important) Maintenance Plan. I would like to backup (or export) the Maintenance Plan, so it can be restored ...
2
votes
1answer
336 views

How do you setup mirroring in SQL 2005 with IP addresses for server names? (EC2 / no AD)

I am setting up a mirror in Amazon EC2 and I have all servers with dedicated IPs. When i try to connect my mirror to my principal with the following command alter database DB_NAME set partner = ...
2
votes
2answers
2k views

How do you setup a SQL 2005 cluster in amazon EC2?

I am trying to setup a highly-available DB architecture in an EC2 servers. We are forced to use SQL 2005 for now. What kind of solutions would work in this context? Has anyone done it? I can't ...
2
votes
3answers
227 views

How can I migrate the default four system DB into another partitions?

Why can't I see any detach / attach command in the 4 SQL Server system DB objects? I want to move it into separate partition for each database files and the log files for greater performance. Am I ...
1
vote
1answer
2k views

How to reduce the SQL Server transaction log on the fly for production DB?

I'd like to know which is the best solution possible to reduce the SQL Server transaction log in the live production server without downtime ? Database full backup - which should commit transaction ...
0
votes
2answers
515 views

what type of replication transaction should I use?

I can't understand the difference between transactional replication and merge replication. This is my scenario: In an organization I have a SQL server which need to collect information from different ...
1
vote
2answers
1k views

Why did my tempdb fill up, and what was trying to shrink it?

After months of perfectly flat disk usage, my tempdb file suddenly grew by several gigs over the weekend. Nobody at the company is aware of anything that might have changed. When I checked the tempdb ...
0
votes
1answer
97 views

How to config a Linked server?

How do I config my linked server to connect to the other database with following properties: ServerName:saleh user:sa password:.... Computer IP address:192.168.100.146
1
vote
1answer
167 views

Sql Server Migration from 2005 to 2008?

We are planning to migrate sql server from 2005 to 2008.We have decided to create user logins manually instead of migrating from 2005 server, as we have different applications (windows services) ...
0
votes
1answer
432 views

How to change the email address where SQL Server sends log shipping warnings to?

Years ago, I set up log shipping in our main database. I'm sure that I had to enter my email address somewhere, because every time when something bad happens now (for example, when the secondary ...
2
votes
2answers
104 views

Backwards-compatible (to SQL 2000) server version and compatibility version check

I have a script which uses features not present in SQL Server 2000. Specifically, the script creates a stored procedure which uses a data type added in SQL Server 2005. I need to use conditional ...
0
votes
1answer
257 views

I/O error in database restore

I am getting the below error while I am trying to do a restore. Can you please suggest a fix? Backup,Unknown,During restore restart an I/O error occurred on checkpoint file 'd:\dwd\smot\res.CKP' ...
0
votes
2answers
294 views

insert bulk statement - SQL 2005 - not “bulk insert”

I am trying to look for the process/processes that is causing the transaction log to grow out of control. I have tried setting the DB to Bulk-Logged and it seems to still be growing. When set to ...
0
votes
2answers
48 views

Is it possible to change a cluster that is dependent on a domain?

Recently we received (2) Poweredge 6850 and (2) PowerVault 220s from our managed server company. These two servers hosted SQL Server 2005 with our SQL database on it. The cluster was dependent on ...
0
votes
2answers
149 views

SQl 2005-2008 vs. SQL 2000 maintenance

At my company we've been using SQL Server for quite a while and have followed the recommended upgrade path. I've noticed that over the last couple of years I'm spending way more time rebuilding ...
1
vote
5answers
2k views

DBCC: The database could not be exclusively locked to perform the operation

I run DBCC CHECKDB ([MyDb]) WITH NO_INFOMSGS, ALL_ERRORMSGS, PHYSICAL_ONLY And after 20 seconds it fails with an error: Msg 5030, Sev 16, State 12, Line 1 : The database could not be ...
2
votes
3answers
142 views

Changing a SQL Server 2008 installation from instance to default

I've had SQL2005 on my pc, and recentely IT has also installed SQL 2008. Unfortunately, it was installed side-by-side with SQL2005, with the unfortunate side-effect that the SQL 2005 installation is ...
3
votes
2answers
147 views

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 ...