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 |
|
jeer
Starting Member
32 Posts |
 Posted - 2008-03-17 : 05:45:49
|
| Hi experts!I am using SQL Server 2005. while restoring a database. I got following error:"An exception occured while executing a Transct-SQL statement or batch.(Microsoft.SqlServer.ConnectionInfo)Additional Information:Too many backup devices specified for backup or restore; only 64 are allowed.RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error:3205 )"Please guide me to resolve this problem.Thanks |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-17 : 23:17:19
|
| How did you restore db? |
 |
|
|
jeer
Starting Member
32 Posts |
Posted - 2008-03-18 : 00:11:30
|
quote:
Originally posted by rmiao
How did you restore db?
I restored the database CRF by following steps:SQL Server Management Studio -> Right Click on CRF (Database Name) -> Tasks -> Restore -> Files and File Groups |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-21 : 20:03:04
|
| Why choose Files and File Groups when you want to restore db? |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-03-24 : 14:21:01
|
| You can use Files and File Groups if there is an individual file (for example ) to restore. Is the current format .BAK?Jack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-24 : 15:29:01
|
| Did you backup using filegroup? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-24 : 15:30:02
|
| You really need to read BOLfor backup.restore in SQL 2005 |
|
|
|
|
|
|
While restoring a database, Error:3205