Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqlgirlatty
Starting Member
5 Posts |
 Posted - 2010-10-12 : 13:58:29
|
| We're running SQL 2005 and attempting a restore to another server and receiving this errorRestore failed for Server 'abcd'. (Microsoft.SqlServer.Smo)Additional information: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)The file or filegroup "OurFiles_log" cannot be selected for this operation.We are restoring to a different server than the one where we took the backup.Thanks! |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-10-12 : 14:52:37
|
| What versions are the SQL Servers?Are you restoring filegroups?Try RESTORE DATABASE command using WITH MOVE option |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sqlgirlatty
Starting Member
5 Posts |
Posted - 2010-10-12 : 17:05:34
|
| Thanks for the replies! Turns out another process was keeping it from restoring. Once that was stopped all went well.Cheers |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
failed db restore
Tara Kizer