Issue with the restore database

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.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Issue with the restore database

Author

Topic

venkath
Posting Yak Master

202 Posts

Posted - 2006-12-12 : 03:44:06

Hi all

I am trying to restore a database in the local server from the backup that was taken from the client server.

While restoring the database, i am getting the following error.

Error3205: Too many backup devices specified for backup or restore; only 64 are allowed.
RESTORE FILELIST is terminating abnormally.

What could have caused the above error.?

Thanks

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-12-12 : 03:49:00

Maybe you have attached to many devices?

select * from master..sysdevices

Peter Larsson
Helsingborg, Sweden

venkath
Posting Yak Master

202 Posts

Posted - 2006-12-12 : 03:50:51

ok thanks

I don't have access to the server from where this particular backup was taken.

Then how can i restore the database now in the local server..

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-12-12 : 04:15:19

You should run the query above on the target server, where you want to restore the file...

Peter Larsson
Helsingborg, Sweden

venkath
Posting Yak Master

202 Posts

Posted - 2006-12-12 : 04:25:37

When i execute the above query on the target server, i got the following output..

How can this result helps in understanding the issue...

name                                                                                                                             size        low         high        status cntrltype phyname                                                                                                                                                                                                                                                              
-------------------------------------------------------------------------------------------------------------------------------- ----------- ----------- ----------- ------ --------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 
master                                                                                                                           512         0           2047        2      0         D:\Program Files\Microsoft SQL Server\MSSQL\data\master.mdf
mastlog                                                                                                                          128         0           511         66     0         D:\Program Files\Microsoft SQL Server\MSSQL\data\mastlog.ldf
modeldev                                                                                                                         80          0           319         2      0         D:\Program Files\Microsoft SQL Server\MSSQL\data\model.mdf
modellog                                                                                                                         96          0           383         66     0         D:\Program Files\Microsoft SQL Server\MSSQL\data\modellog.ldf
tempdev                                                                                                                          256         0           1023        2      0         D:\Program Files\Microsoft SQL Server\MSSQL\data\tempdb.mdf
templog                                                                                                                          64          0           255         66     0         D:\Program Files\Microsoft SQL Server\MSSQL\data\templog.ldf

(6 row(s) affected)

Thanks

Kristen
Test

22859 Posts

Posted - 2006-12-12 : 04:31:26

See also: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=RESTORE%20syntax%20/%20example

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources