I have two instances of SQL Server 2005. I have backup a database in once instance. And now trying to restore to another. Process worked fine for 2 of databases, but I got problem with one database. This one is 13GB big database. Others are small ones. When I tried to restore it I got error"Restore failed for Server 'servername' (Microsoft.SqlServer.SmoExtended) Additional information: System.Data.SqlClient.SqlError: File 'C:\MSSQL_DATA\DataBaseName.mdf' is claimed by 'databasename_Data_01(3)' and 'databasename_Data'(1)'. The WITH MOVE clause can be used to relocate one or more files(Microsoft.SqlServer.Smo)Kenny_I

it seems like the data file with same names are already present in the target folder where you are restoring the database. try restoring with different file name. RESTORE DATABASE [DatabaseName] FROM DISK = N'C:\DatabaseBackupFile.bak' WITH FILE = 1, MOVE N'DataFileName' TO N'C:\MSSQL_DATA\NewDataFileName.mdf', MOVE N'LogFileName' TO N'C:\MSSQL_DATA\NewLogFileName.ldf', NOUNLOAD, STATS = 10 GO - Vishal SqlAndMe.com