SQL Server 2005 - Restore failed

[BobHachmeister]

I did a COPY_ONLY backup of a production DB. The BACKUP worked fine, here's the code:

BACKUP DATABASE [ifas] 
  TO DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\IFAS Backup Copy Only' 
  WITH COPY_ONLY, DESCRIPTION = N'Backup COPY ONLY for restore to IFASTest  ',  
  RETAINDAYS = 60, NOFORMAT, INIT, NAME = N'IFAS-Full Database Backup COPY ONLY ', 
  SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO
declare @backupSetId as int
select 
  @backupSetId = position 
from 
  msdb..backupset 
where 
  database_name=N'ifas' and 
  backup_set_id=(select max(backup_set_id) from msdb..backupset where database_name=N'ifas' )
if @backupSetId is null 
  begin 
    raiserror(N'Verify failed. Backup information for database ''ifas'' not found.', 16, 1) 
  end
RESTORE VERIFYONLY 
  FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\IFAS Backup Copy Only' 
  WITH FILE = @backupSetId, NOUNLOAD, NOREWIND
GO
 

I then tried to restore the backup to an existing test version of the DB. The restore failed. Here's the code:

RESTORE DATABASE [ifastest] 
  FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\IFAS Backup Copy Only' 
  WITH FILE = 1, NOUNLOAD, REPLACE, STATS = 10
GO
 

The RESTORE failed with this message:
[ERROR MESSAGE]
Msg 233, Level 20, State 0, Line 0
A transport-level error has occurred when sending the request to the server. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)
[/ERROR MESSAGE]

Totally unrelated to the reason for doing the BACKUP, in between the backup and restore, I did a RESTART of the server, plus executed this script:

ALTER DATABASE [ifas] SET READ_COMMITTED_SNAPSHOT ON;
go
ALTER DATABASE [ifastest] SET READ_COMMITTED_SNAPSHOT ON;
go
select
  name
 ,is_read_committed_snapshot_on
 ,snapshot_isolation_state
from
  sys.databases
go
 

Does anyone know what the problem is?
Thanks a bunch in advance.

[Jerry Winston]

The snapshot is the problem. You can't drop, detach, or restore a source database when a snapshot is present. Try removing the snapshots and trying it again. If this works, let me know.

[BobHachmeister]

I was able to restore that database without removing the snapshot. It just took several attempts. The DB is being used for training, so I am unable to re-try the restore at this time. When I do, I'll post another message.