Server Configuration

Restore sql 2000 database .bak file to sql 2005
I am trying to restore a sql 2000 .bak file to a sql 2005. Error I get is " Restore failed for Server" - The backup set holds a backup of a database other than the existing 'db name here ' database. (Microsoft.SqlServer.Smo) Pleawse help ... 9 Feb 2006 02:07

Failed uninstall of named instance
Hi I attempted to remove a named instance on a test server (SQL 2000 sp4). The uninstall failed and after trying to follow Microsofts recommendations (Article id 290991 - How to manuall remove sql server 2000 ... instance) I have got myself with a partially deleted instance but which has left services and lots of ... 9 Feb 2006 05:42

INSTALL PROBLEM
when i try to install sql server on a windows 2003 server with service pack 1. I get the following error any workarounds? or anyone know what version of sql server i can install on 2003 server? I tried the demo verion of sql 2000 but that also can installed. Thanks for any help regards TITLE: Microsoft SQL S... 8 Feb 2006 10:29

Installing SQL Server 2005
Hello, I have SQL Server 2000 on my machine and just installed SQL Server 2005 but my registered server on my local machine still reads MyServer (SQL Server 8.0.760- MyServer\drake). Can I have two registrations on my local machine using Windows Authentication. One for the old version and one for 2005? If not... 14 Feb 2006 08:09

Connection error
Hi, I get the following error when I try to connect to SQL 2005 Beta from VS 2005. "A connection was successfully established with the server, but then an error occurred during the login process. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.) " The calli... 7 Feb 2006 14:39

Database Naming Convention - Sanity Check
Hi, I've been putting together a database naming convention standard for our SQL developers the last couple of days. I've chosen a more verbose standard to help reign in my developers and to help improve the documentation, use and understanding of their T-SQL code. I've looked over it a few times but it is... 6 Feb 2006 20:24

restore master database: no restart
Dear all, I'm working on MS SQL 2000 SP3. I'm trying to switch to a new server. When I tried to restore the master database, the server wouldn't re-start. so I tried another way, that is to restore user-databases and transfer the users-accounts (DTS) but it seems that the users cannot connect to the new serve... 6 Feb 2006 06:13

Restoring Files and Filesgroups
I have a database with with two filegroups - the primary and one other. Each filegroup has its own data file. I want to restore the database to a different database server but restore only the primary filegroup. When I try to do this, I get the following error for each of the data files associated with the ... 2 Feb 2006 12:59

Backup and restore
Hi, When I tried to restore a database backup that was created by SQL Server 2000 / SP3a installation into a SQL Server 2000 / SP4, I got the following error message - --------------------------- Microsoft SQL-DMO (ODBC SQLState: 42000) --------------------------- The file on device 'D:\Program Files\Micro... 2 Feb 2006 12:59

register sql2000 on SQL2005 manager
I have two servers 2003, one running sqlserver 2005 and the second sqlserver 2000. I'd like to register the sql2000 on the sqlserver management studio provides with sql2005. when I trie to connect to server with sql2000 I get an time out error. I've already activated all the protocol : tcp/ip, named pipe ... ... 1 Feb 2006 02:27