SQL Server restore problem - Error 3154: The backup set holds a backup of a database other than the existing database

On SQLServer 2005 Standard Edition Service Pack 2  - we have a routine that backs up databases onto a dedicated drive. It is a full backup to disk. This routine does not drop the database

BACKUP DATABASE MY_DB TO  DISK = 'I:\backups\jvTest20081127.BAK' WITH NOFORMAT,COPY_ONLY, INIT,  NAME = MY_DB  , SKIP, NOREWIND,

NOUNLOAD,  STATS = 10;

 

 

A couple of weeks later , I needed one of the databases and attempted a standard RESTORE DATABASE
but without the WITH REPLACE parameter.

   RESTORE DATABASE MY_DB FROM DISK =  'I:\backups\jvTest20081127.BAK'

An error was encountered : Error 3154: The backup set holds a backup of a database other than the existing database
The error occurs because I was  trying to restore the database on another existing active database.

The solution is :

RESTORE DATABASE myDB
   FROM DISK = N'I:\backups\jvTest20081127.BAK' 
WITH REPLACE

mssqlsystemresource moving error

Trying to run the following :

ALTER DATABASE mssqlsystemresource
MODIFY FILE (NAME = data, FILENAME = 'D:\MSSQLSERVER\MY_SQL_SERVER_INSTANCE\Data\mssqlsystemresource.mdf')
GO
ALTER DATABASE  mssqlsystemresource
MODIFY FILE (NAME = log, FILENAME = 'D:\MSSQLSERVER\MY_SQL_SERVER_INSTANCE\Data\mssqlsystemresource.ldf')
GO

error is :
Could not locate entry in sysdatabases for database 'mssqlsystemresource'

 

Tried the following  and it solved the problem:

 

NET START MY_SQL_SERVER_INSTANCE /f /T3608

The "/f" switch - This flag starts SQL Server with minimal configuration and allows updates to system tables. Sometimes a DBA makes config

changes , which won't allow the SQL Server instance to start.The switch is useful , as sometimes it is the only way to correct

configuration mistakes

The "/T3608" flag skips automatic recovery for all databases except the master database at the startup

Source:Jack Vamvas (http://www.sqlserver-dba.com)