Tagged Questions

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

0
votes
1answer
227 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) ...
5
votes
0answers
365 views

Database Backup and Full-Text Search

I am running SQL Server 2005 EE. When trying to perform a full database backup I recieve the error message: "Failed to pause catalog for backup. Backup was aborted.BACKUP DATABASE is terminating ...
0
votes
1answer
44 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
193 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
4answers
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
2answers
3k 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
64 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
392 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
23 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
223 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
48 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
198 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
213 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
125 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
64 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
179 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 ...
1
vote
2answers
31 views

MSAccess doesn't see sql2005 dataset

I have a sql2005 setup on a windows7 machine. I am able to see the dataset in SSMS, but am unable to create a connection string that will see the dataset from MSAccess. I am able to connect to the ...
3
votes
3answers
553 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
255 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
190 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
249 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
214 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
1k 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
96 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
155 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
344 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
100 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
185 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
173 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
147 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
139 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
139 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 ...
2
votes
2answers
468 views

SQL-Server 2005 default trace log file not inherits directory permissions

I need to backup the SQL-Server 2005 default trace log files (%sqlserverpath%\MSSQL\LOG\log_*.trc) and when it is created it isnt inheriting the directory file permissions (Windows 2003 Server) so I ...
0
votes
1answer
37 views

Data Type Error - Merging columns in a new view using SELECT AS

I have a [TABLE] with 3 columns like this: [Column1-smallint] [Column2-nvarchar] [Column3-nvarchar] I would like to create a new view with only 1 column like this: [Column1 & Column2 & ...
1
vote
3answers
263 views

SQL2005 Express Machine believes it's part of a Cluster fails to Upgrade

I have a machine where I am attempting to upgrade from Sql2005 Express to Sql2008r2 Express, but it is failing on the Rules check. Rule Check Result Rule "Not clustered or the cluster ...
3
votes
3answers
209 views

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 ...
2
votes
4answers
247 views

Log shipping on select tables

I know I am most likely using incorrect terminology so please correct me if I use the wrong terms so I can search better. We have a very large database at a client's site and we would like to have up ...
0
votes
1answer
230 views

Can't uninstall Reporting Services on SQL 2005 (SBS 2008)

I am running SBS 2008 and have just installed SQL 2008 alongside SQL 2005. My understanding is that the default instance created in SQL 2005 is not needed and only the SBSMONITORING instance is ...
0
votes
1answer
423 views

Unable to restore database using Microsoft SQL Server Management Studio Express

I am unable to restore database in form of .bak files using Microsoft SQL Server Management Studio Express. It gives following error message: Too many backup devices specified for backup or ...
2
votes
1answer
199 views

Configure SQL Server 2005 to take advantage of 32GB of RAM on 64-bit version of Windows Server 2003

I'm looking for recommendations/best practices for configuring SQL Server 2005 to take advantage of a recent memory upgrade to 32GB of RAM. The OS version is Windows 2003 64-bit Enterprise Edition. ...
0
votes
2answers
153 views

Removing SQL Server Express 2008 Instances

How can SQL Server 2005 Instances be manually removed (if uninstall does not clean them up)?
0
votes
1answer
11 views

sql server installation problem

can sql server 2005 service pack 3 be installed in windows vista?