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 Development (2000)
 how to seperate databases from .bak file NOINT

Author  Topic 

naaz
Starting Member

1 Post

Posted - 2009-02-16 : 11:46:55
Dear Experts,

My mistake i took a backup on the same file three time while the NOINIT is on. So the actual file size is 6mb and now after take 3 backup on the same file its size is 17mb.

I need to extract the record from the second or third Database file while when i restore its only showing me the first file records which are only 4 and actaully the number of records are 316. If i tried to import it in sql2005 i can see the 3 files but i can't restore it becasusee of the version.

Can any1 tell me how to extract the record from the second database which is backup in one bak file.

Regards,
Naaz

Naaz

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-02-16 : 12:26:30
Lets be clear:

so you mean you overwrite the bak file.
Go to Top of Page
   

- Advertisement -