cant recover a table that was save to a file

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)

cant recover a table that was save to a file

Author

Topic

pelegk2
Aged Yak Warrior

723 Posts

Posted - 2007-03-25 : 13:26:45

i am using this code :


RESTORE DATABASE LA_Billing
   file = 'january2007',
   FILEGROUP = 'january2007'
   FROM DISK='D:\BACKUP\LA_Billing_January2007Final.bak' 
   WITH file=1,norecovery,
   MOVE 'january2007' TO 'D:\Program Files\Microsoft SQL Server\MSSQL\Data\fg_january2007_data_1.mdf', 
   MOVE 'january2007' TO 'D:\Program Files\Microsoft SQL Server\MSSQL\Data\fg_january2007_data_2.ndf'
GO

and recive this error :

quote:

Server: Msg 3135, Level 16, State 2, Line 2
The backup set in file 'D:\BACKUP\LA_Billing_January2007Final.bak' was created by BACKUP DATABASE...FILE=<name> and cannot be used for this restore operation.
Server: Msg 3013, Level 16, State 1, Line 2
RESTORE DATABASE is terminating abnormally.

any idea what i can do?
Thanks i nadvance
peleg

Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:)

TonyTheDBA
Posting Yak Master

121 Posts

Posted - 2007-03-26 : 05:53:54

Try RESTORE FILELISTONLY FROM DISK='D:\BACKUP\LA_Billing_January2007Final.bak' To see aht is contained in the backup

--
Regards
Tony The DBA

pelegk2
Aged Yak Warrior

723 Posts

Posted - 2007-03-26 : 07:34:43

this is waht i recive:

quote:
January2007,Y:\Program Files\Microsoft SQL Server\MSSQL\Data\fg_January2007_Data.NDF,D,January2007,23538368512,35184372080640

what to do next?
thnaks
peleg

Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:)

MohammedU
Posting Yak Master

145 Posts

Posted - 2007-03-27 : 01:06:13

I don't think your backup file is database full backup...
Run BACKUP HEADERONLY and check the backup type column in the output...

Backup type:
1 = Database
2 = Transaction Log
4 = File
5 = Differential
Database
6 = Differential File

MohammedU

pelegk2
Aged Yak Warrior

723 Posts

Posted - 2007-03-27 : 03:53:51

ok check it
the backup type is 4=File
and the it isnta full backup (of all the DB but only 4 tables saved to a file caleed january2007
what can i do next?
thnaks in adbvance
peleg

Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources