cant restore database - SQL Server Forums

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 2008 Forums

SQL Server Administration (2008)

cant restore database

Author

Topic

mayerl
Yak Posting Veteran

95 Posts

Posted - 2011-11-14 : 16:32:35

Afternoon,

I am trying to restore a database. I can see the contents of the backup set yet when I try to run it with replace, on a test database, I get the message

system.data.sqlclient.sqlerror: cannot find file id 16 on device 'd:\sqlbackups\productionbackup'

Can anyone help?

Thanks

Laura

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-11-14 : 16:40:26

What's the exact restore statement you're running?

--
Gail Shaw
SQL Server MVP

mayerl
Yak Posting Veteran

95 Posts

Posted - 2011-11-15 : 07:44:51

RESTORE DATABASE [Inventory]
FROM DISK = 'D:\SQLBackups\ProductionBackup' WITH FILE = 16,
RECOVERY,
NOUNLOAD, REPLACE, STATS = 10
GO

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-11-15 : 07:57:01

And the backup has 16 or more backup sets in it?

What does RESTORE HEADERONLY return?

--
Gail Shaw
SQL Server MVP

mayerl
Yak Posting Veteran

95 Posts

Posted - 2011-11-15 : 10:01:29

16 is not listed. However I can see it in management studio. Why is that?

I did just restore it from a later backup but I want to figure out what happened.

Thanks

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-11-15 : 10:50:02

No idea. Can't see and don't have the backup file to play with. But that's why the restore fails, the file you're specifying doesn't exist.

--
Gail Shaw
SQL Server MVP

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources